| Post ID |
Timestamp |
Content |
User |
| 396775 |
2005-10-16 09:20:00 |
I create a total order list from a master date sheet to be allocated to 8 different cost codes. In my master sheet I have 8 columns into whcih I enter the orders for each item (row). I have created 8 worksheets for each of the columns which picks up the items entered into each column respectively. How can I arrange things so that the 8 worksheets only show items (rows) which have an order made against them? |
bpt2 (6653) |
| 396776 |
2005-10-16 10:21:00 |
Data / Filter / Autofilter & NonBlanks? |
rad_s4 (7401) |
| 396777 |
2005-10-18 02:33:00 |
Thanks, that'll work fine. |
bpt2 (6653) |
| 1 |
|