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.