![]() |
copy several cells if one cell is set
I have a customer worksheet that contains information about items each
customer bought. What I want to do is have a main spreadsheet for all weekly sales. Once those are entered all items for Customer #1 will go to a separate spreadsheet, same with #2,etc. Each customer will have their own sheet, and the company will have the main one with all of them. For Example... A1 is Cust #, B1-J1 is item info that goes to that customer. If I have #01 in A1 then all info in B1-J1 gets copied to the seperate sheet, if I have to I may be able to use names instead of customer numbers.... |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com