2 Excel Macros with dynamic data
$10-30 USD
Paid on delivery
I need help developing two very simple excel macros.
The macros will do the following:
1. search through all rows of tab 1 of each spreadsheet and search for matches in tabs 2/3 of the excel. it will copy data from tabs 2/3 back into tab 1. note the # of rows and columns in all these sheets will vary daily - keep in mind when coding.
2. it will then do some formatting/highlighting of cells in tab 1 based on cell values. finally, it will show an alert at the end of the macro ending summarizing which rows do NOT have matches found.
**These macros should be made compatible on both windows AND mac excel. There should have a button on tab 1 to run the actual macro.
Project ID: #15875015
About the project
Awarded to:
Hi there, I am an expert VBA and Excel macro developer, I will place a button on tab 1 to call the macro function. And i read your requirement, and i understood about it. Just 1 confusion is, is there any differen More
5 freelancers are bidding on average $32 for this job
I have 7 years of experience in Excel and VBA with 100% client satisfaction history. see my profile for client reviews. Looking for your response