Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Place 6-cell row in another folder when cell #3 is verified
Four cells in a given row of a Salesman's File (Start Date, Job No., Company
Name, Dollar Cost) are created many times per day and are placed in a Master Folder. The remaining two cells (Invoice Number, Invoice Date) are entered as they occur which may be one day to three weeks after each Start Date. The file is sorted by increasing Invoice Number, which may contain skips because of other users in other unrelated files. Separate folders containing the same six cells of data are to be maintained for some of the Company Names. I want the six cells from the Master File to Appear in the folder of Company A or Company B as soon as the Invoic Number and Date are entered and the Master File is sorted in order of Invoice Number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell. | Excel Discussion (Misc queries) | |||
Automatically place text in one cell into cell in another sheet | New Users to Excel | |||
Anyone verified if 8192 non-contiguious cell delete fixed in XL 2007? | Excel Discussion (Misc queries) | |||
move a sheet out of my workbook and place in another folder? | Excel Discussion (Misc queries) | |||
How to place a value in another cell | Excel Discussion (Misc queries) |