Hello!
I have a workbook that contains a data validation list between G4:G31. I am looking for a macro that automatically populates H4:J30 with data from its corresponding sheet.
Example: Someone clicks on "Client Services" from the list located in the "Billing" tab. Data is copied from the Client Services tab A1:C24 to H4:J30 in the "Billing" tab. There is a sheet for every list item in the data validation list and the data will always be copied into H4:J30 on the "Billing" tab.
Thank you!
I have a workbook that contains a data validation list between G4:G31. I am looking for a macro that automatically populates H4:J30 with data from its corresponding sheet.
Example: Someone clicks on "Client Services" from the list located in the "Billing" tab. Data is copied from the Client Services tab A1:C24 to H4:J30 in the "Billing" tab. There is a sheet for every list item in the data validation list and the data will always be copied into H4:J30 on the "Billing" tab.
Thank you!
