copy several cells if one cell is set

  • Thread starter formula using percentage question
  • Start date
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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top