Excel and VBA Automation
$10-30 USD
Paid on delivery
Data from two worksheets needs to be regularly compared and the monthly comparison needs to be automated. I have two sheets in this workbook. I need a third tab with a macro button which can compare the two sheets, titles “Restated Data” and “Location File Data” each month. Data for person rows spans 2017, 2016, 2015, 2014 and 2013. The real data set is much larger.
On each tab, there are person ID numbers and month’s of entry, in columns A and AN, respectively. There are multiple entries on each for each person # and month combinations. “Location File Data” will be ultimately use. The comparison sheet, the third sheet, should list all row of data in Restated Data, but not in Location File data. The rows will eventually be added to Location File data. Also, all rows that are not in Restated data, but in Location File data, will need to be removed from Location file data. The third sheet should list all cases of both scenarios. The next macro button will then add the rows to Location File data that need to be added, which are in Restated, and remove from Location File Data those which are not in Restated. The tricky part is two fold:
- New data will need to be added at the top, corresponding to the year grouping it pertains to. If data for 2017 stops and row 3000 on Location File Data tab and a row for 2017 needs to be added, it should be added at row 3001, not at the end of the data. Formulas will be in columns AO to AA, and will need to be dragged down to apply to these new rows added, and only the new rows.
- Going forward, current month data will be in Restated, previous month’s in Location, so all data in Location File Data will be clear from column A to Column AN for 2017 ONLY (February), and replaced with the corresponding data from Restated (March here). Next month I will replace March data with April month end data then so on. This needs to be a monthly repeatable process. Again, new rows changed in Location File Data tab need to be at the same consistent grouping location and not added at the end of the sheet.
Project ID: #13818516
About the project
34 freelancers are bidding on average $35 for this job
Hi, I am good at Excel and building useful scripts for my clients. Please provide the files to read inline with the description once again. I just checked the description you have provided regarding the project More
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
we have expertise in excel VBA,data processing. clients satisfaction is our main motto for long term relationship.
Hello, I am proficient with Excel and VBA and would love to help you with this project. I have a lot of experience with similar work. Please contact me for more information.
Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. Please provide me the files.
I am experienced at comparing and sorting rows and selective columns in worksheets. I can conduct the required automation within one day as requested.
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
Hi, Got you requirement. I can deliver it. Please ping me if you have any question for me. Regards, Rajeev
Hay, I have gone through your project description. I am interested in your project. You can chat me up for further discussion about the project in the private chat. Hoping to hear from you soon. Thanks.
HELLO DEAR ! If you are reading my profile then I'm assuming you are considering me for your next project so this is my one chance to impress you and tell you why you should pick me over anyone else. I specialize in Da More
Dear Client, I have done MBA in Finance Management Also I am Microsoft certified in Advance Excel & having excellent knowledge of VBA Macros In my job I have always worked on big data, made dashboards prepared lots o More
I am extremely intelligent, creative and relentless when it comes to troubleshooting and making things work out for the best of my customer.
Hi, The comparison work which i am doing this kind of work on monthly basis. I can do this for you.. if you can able to provide me some sample data which will help me to give you the result as expected. you can More