Hi, we have a need to enter some data from three messy excel sheets into one organized excel sheet, and categorize the entries being entered by vendor and week. The "source" data is a list of prices (expenses), dates and vendors from March 2019 to today. Each entry should be added into the final document where the column is the week of that expense, the row is the vendor (create a new row if it doesn't already exist or you're not sure), and the expense is entered in the cell (and if there are multiple entries in the same week for that vendor, the price is combined as a formula, like "=10+20" instead of just entering in "30"). It should make sense when you see the files.
There are 384 records and I would expect it to take 2 hours. Looking for a fast same-day turnaround. Thank you!
49 freelancers are bidding on average $23 for this job
Hello Sir, I can organize your vendor and week data as per instruction and format. I have expertise and experience in building spreadsheet like that. Kind Regards Gopal