Hi,
I have a macro that moves data from the INPUT tab to TWO other tabs. There are two parts to the macro:
1. Compare the locations listed in the imported rows of data against a "master location list" in Column "U" of the INPUT tab.
2. Move the rows of data to different tabs as defined by the macro script (i.e. if the location is Diamond Bar, then the row of data will get moved to sheet 24).
The problem with this setup is that every time an additional new location needs to be added I have to add it to my list in Column "U" on the INPUT tab and then also update the script to A) have the script check this additional location in the "U" column and B) tell the script to move all rows with this new location to a specific sheet.
I would love help figuring out how to have the script rotate through my list in "U" one at a time, assign a variable with a value of each "location name", and then move each row of data with the corresponding name to the tab that has the same name as the current location stored in the variable. It would need to cycle through the list of locations in Column "U" until it senses that there are no further values in the column to cycle through. (i.e. "U2:U2 is the location "Newport Beach", so move all rows of data that have "Newport Beach" in the A column to the tab that is titled "Newport Beach")
I have attached a sample to this post.
Thanks in advance for your ideas!
Bookmarks