I need someone to take the sheets that have data for the months January 2017 to May 2018 (total of 17 sheets or months) and put the data into the two sheets labeled "Month" and "Date".
For the "Date" sheet, the first column is all the customer IDs for all the 17 sheets, the second column "17-Jan" is the total amount in the "Amount" column that matches the Customer ID for that month sheet i.e. "January 2017" sheet. In the "17-Feb" column, that is the total amount in the "Amount" column for each Customer ID in the "February 2017" sheet, and I need that for all the other sheets to put into the "Date" sheet.
For the month sheet, the first column is all the customer IDs for all the 17 sheets, and the "Month 1" column is the first payment that the Customer ID made a payment (found in the "Amount" column for each month in order January 2017, February 2017, etc.), "Month 2" is the second month that Customer ID made a payment "Amount". The "Amount" should include the total amount that person made in their first month's payment (Month 1). If there are two Amounts in the same month, then add them up. For example, if the Customer ID did not have any amounts from the January 2017 Sheet but their first payment was in March 2017 for $100, then the "Month" 1 for that Customer ID should be $100.
If you are interested in this project, I need you to do the first two months and send me a sample so that I know that you can do this project. If you want this project, please only do the sample and reply with the message "I have done the sample, message me so I can show you". Thank you!
21 freelancers are bidding on average $27 for this job
Hello.I read the description of your project.I offer my services for this task.I already completed work like [login to view URL] contact with me so we discuss more about [login to view URL]
Hi, I have done the sample, message me so I can show you. But there is no option to attach it here. Can I have your email address to send it. Let me know whether I am doing it correctly, Thanks Buddhika