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.
|