ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copy several cells if one cell is set (https://www.excelbanter.com/excel-programming/363506-copy-several-cells-if-one-cell-set.html)

formula using percentage question

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