I am looking for someone who has advanced Excel Sheet skills including Macros. The project would involve comparing multiple sheets, add up different coloumns based upon validations in other coloumns. Then further compare these new coloumns and derive final output. For example, there are 5 sheets. Pick up Col A, Sheet A, check it against Col A in Sheet 2. If value is "Yes" in Sheet 2, then for Sheet A, add values in Col B for a particular date range. Similar exercise for other sheets and then cap the results for those sheet. Finally compare the first and second results and derive a third result.
There would be one "output" page that would provide these different values.
I am in the process of finalising the requirement sheet and then am happy to share it (should take 2-3 days)
Meanwhile, I want to finalise the expert who can deliver it
This may require some iteration along the way and may also require a couple of phone calls and screen sharing.
46 freelancers are bidding on average $134 for this job
Hello, It would be my pleasure to help you on this. I have done many reporting automations in Excel/Google sheets with using complex macros. Kindly message me to discuss further. Regards, Shereena Wilson P
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.