vbanovice01
New Member
- Joined
- Oct 29, 2014
- Messages
- 1
Hello!
i'm hoping someone can help me as i know the solution to my problem can be solved via a macro of some sort.
I have a spreadsheet that containing 3 tabs, sheet1 sheet2 and sheet3.
Sheet1 only has data in column A which is the unique values of my data range... there are over 100 different names of stores. e.g store 1, store 2 etc
Sheet2 contains information on stock in the store. Column A has the store name which ties back to sheet 1, each store will have multiple rows (over 50,000), ranges from column A to AP
Sheet 3 similar to sheet 2 over 50,000 rows all containing store name in column A.
in addition there are header rows in row 1 and 2 for both sheet 2 and 3
What i need to do is copy and paste the information relating to each store from sheets 2 and 3 in to a new work book for each store (keeping the information on different tabs) and then save the file down by the store name. at the end of it i'll have 100 excel workbooks, each with 2 tabs and only containing information of the store named on the file.
i'm hoping someone can help me as i know the solution to my problem can be solved via a macro of some sort.
I have a spreadsheet that containing 3 tabs, sheet1 sheet2 and sheet3.
Sheet1 only has data in column A which is the unique values of my data range... there are over 100 different names of stores. e.g store 1, store 2 etc
Sheet2 contains information on stock in the store. Column A has the store name which ties back to sheet 1, each store will have multiple rows (over 50,000), ranges from column A to AP
Sheet 3 similar to sheet 2 over 50,000 rows all containing store name in column A.
in addition there are header rows in row 1 and 2 for both sheet 2 and 3
What i need to do is copy and paste the information relating to each store from sheets 2 and 3 in to a new work book for each store (keeping the information on different tabs) and then save the file down by the store name. at the end of it i'll have 100 excel workbooks, each with 2 tabs and only containing information of the store named on the file.
Last edited:
