Good evening experts, I have another need of your expertise!
I'd like to update my worksheets with new data from a worksheet in the same workbook.
I have a worksheet(let's call it Master) that pulls data from other sources. I actually already use a macro to grab the new set of data. Master will contain the new set of data that I'd like to be copied to the other existing worksheets based on a value and worksheet name.
For example, in the attached, I have the 1st column that contain an indicator value. I'd like to have all the rows that contain the worksheet name in the 1st column to be copied to the worksheet. In the specific example, I'd like to have the rows where Column A = Toronto to be copied to the worksheet named Toronto, New York to the worksheet New York, etc.
There will already be existing data in the worksheet named Toronto, so I'd like to have the new data added instead of overwriting the worksheet.
The "indicator" column is just the 1st column for simplicity's sake, but I'm hoping we can change this one to whichever column.
I actually already use a macro that does a similar function except it completely creates new worksheets. I got it from this video, maybe this can serve as an inspiration? = https://www.youtube.com/watch?v=5bOFNsdHiPk
Thank you in advance! Your input is very much so appreciated!!
z
Bookmarks