Attached I have an example of what I would like to accomplish.
In column A I have the website of toy stores I will look at for gifts.
In column B is a list of the toys I am looking for (this will be the same list of toys at all stores)
As you will see on the attached I have Toys-R-Us listed 12 times, one for each specific toy
Then starting at line 14 Kmart is listed 12 times again with the same 12 toys repeating
So this list will be very long
In Column E I have the list of the toy stores websites that I want to search (5 for this example)
And finally in column F are the 12 toys
What I’m wondering is it possible to have the website of the store in column E automatically added in column A equal to the number of times that there are toys in Column F? Basically can I just add or delete a store from E and/or add or delete a toy from F and have it do all the adding and deleting from A & B?
It would need to add or delete rows as required, so if my example was fully filled out I would have 5 groupings of 12. If I delete toy number 7 it would remove that line from each of the 5 groupings in Columns A & B. (This would be a nice to have but not a must.)
Lastly I believe the file type has to be a .xlsb for the macro to work, I hope that doesn’t limit options too much.
Thanks in advance for taking the time to read this.
Dave
Bookmarks