F
formula using percentage question
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....
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....