Hi Guys,
Thanks in advance, I'm needing help with getting a VBA macro to lookup a field on change and copy that lookup information from another sheet. Ok so basically I have 2 sheets, 'Daily Report' and 'Exceptions' in the attached when the Yellow marked sections change then I need the macro to fire off and do the lookup on the 'Exceptions' sheet and once it finds it then copies that row/cells to the 'Daily Report' sheet marked in Green. Hope this helps, please note that the data on the 'Exceptions' page will be dynamic, so new data will be added.
Thanks.
For some reason it won't let me post attachments, so here's a link to it: Test_Book.xlsx
Thanks in advance, I'm needing help with getting a VBA macro to lookup a field on change and copy that lookup information from another sheet. Ok so basically I have 2 sheets, 'Daily Report' and 'Exceptions' in the attached when the Yellow marked sections change then I need the macro to fire off and do the lookup on the 'Exceptions' sheet and once it finds it then copies that row/cells to the 'Daily Report' sheet marked in Green. Hope this helps, please note that the data on the 'Exceptions' page will be dynamic, so new data will be added.
Thanks.
For some reason it won't let me post attachments, so here's a link to it: Test_Book.xlsx
Last edited: