Hi Everyone,
I am working on a project for fun and the below is what I am trying to achieve:
- Copy all data over into a "Master" worksheet from tabs with "ABC" in the worksheet name, i.e. copy from "ABC - 1", "ABC - 2", "ABC - 3", but not "XYZ - 1" or anything without "ABC".
- Only copy over the header once, as each ABC worksheet has the same header
- Rename the values in the name column in the "Master" worksheet based on the "Name Key" tab (i.e. if name is Michael, change to Mike). Some sort of lookup?
- Rename the name for Juliana to either "Jules (1)" or "Jules (2)", based on the value in the date column. If date is before 10/1/2020, then change to Jules (1). If date is on or after 10/1/2020, then change to Jules (2). Just for this name though, no-one else.
I have managed to achieve the first and second bullets (as seen in the VBA and output in "Master" tab) through the following code:
If anyone can figure out or attach the VBA code for the rest, that would be really helpful! I have tried multiple times and browsed sites, but have not been successful.
I have attached an example of what the "Master" sheet would look like (this can be seen in the highlighted tab - "Intended Output - Master"), including a refresh button.
Thank you!
Bookmarks