I have two worksheets in the same workbook, Sheet 1 which has % by date and Sheet 2 which I overwrite each month with the new %.
Sheet 1 Looks like this, I want to copy each instance of Location A and paste it into the next blank cell in Sheet 2. So that I copy Container 1 - Location A and paste into D13 which is blank and then copy Container 2 - Location A and paste it into the next BLANK cell in Sheet 2 which is D24 and corresponds to Nov-21 of Container 2. I want to repeat this until the last cell in the Range on Sheet 2 because I don't want to continue the process for EVERY blank just the Blanks in the current populated range. Any help with this is greatly appreciated!
Sheet 1 Looks like this, I want to copy each instance of Location A and paste it into the next blank cell in Sheet 2. So that I copy Container 1 - Location A and paste into D13 which is blank and then copy Container 2 - Location A and paste it into the next BLANK cell in Sheet 2 which is D24 and corresponds to Nov-21 of Container 2. I want to repeat this until the last cell in the Range on Sheet 2 because I don't want to continue the process for EVERY blank just the Blanks in the current populated range. Any help with this is greatly appreciated!