Forum

Use Macros to updat...
 
Notifications
Clear all

Use Macros to update one sheet in a workbook when the data is in another 2 sheets

2 Posts
2 Users
0 Reactions
104 Views
(@xcalibar69)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 25/01/2022 7:09 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

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

 
Posted : 26/01/2022 8:34 pm
Share: