Good morning Everyone,
I am hoping that you can help me please.
I am looking to have a spreadsheet with 3 tabs.
Tab 1 will a report which is generated and filtered from an application I want the user to paste the latest report to this tab.
I want the macro to take the content from all fields in tab 1 and update the fields in tab 3 which will be a working tab, I would like the macro to highlight certain fields in different colours if there has been additional text/update to that field say amber or yellow, then highlight other fields like If there is a new row of info added then highlight that row in green.
Tab 2 is a second report which I would like to have the user cut and paste the latest report into.
There would be buttons on tab 3 to take the updates from tabs 1&2 and place them in tab 3 with different colours like I described above.
Are you able to help?
Point in the direction or even say what it’s called and I can Google and YouTube to find it.
Hi Jay,
Without sample data it's pretty much impossible to help you - please provide a sample file with:
1. Enough data to properly represent your situation
2. Clear examples of the result(s) you want
Please describe what you want to do not how you want it done. I make this point because having read your description above, it may be better to do it with Power Query and Conditional Formatting than using VBA.
regards
Phil
