| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy several cells if one cell is set
I have a worksheet that I am setting up for weekly sales of my company...
currently I have it set for each single customer, but I want to make a main sheet so that I can enter all the weekly sales and the information for each customer goes to their respective worksheets.... Example: A5=Cust #, B5=Item Title, C5=Item Number, D5=EBAY or STORE, E5=Start Price, F5=Listing Fee, G5=Pre-Pay Fee, H5=Final Price, I5=E-Place Fee, J5=Payout What I want is that if A5=cust #1 then A5-J5 info gets copied to another worksheet, and so forth for each customer number(2,3,4....) How can I do this? |
| 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
