| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select max value from 9 cells, copy cell col heading to other cell | New Users to Excel | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
Hybrid Mode
