P
Paulo
Hi,
I wonder if anyone can help me please.
I am importing a master list of records into a worksheet I call Master. Then
filter on column A to categorize the column by name, the name-field contain
the Julian-date and the initials of the individuals that created the record.
Each day I have to filter and copy the categorized records into its
corresponding worksheet. In example given below I am trying to copy a
worksheet for CR, DR, DZ and U, etc.
In the first try in setting up the formula was this but I keep having problems
=MASTER!A1((IF($A1:$E1000), $A$2='DR')
BATCH NAME BATCH DATE INVOICE NUMBER VOUCHER AMOUNT
7066I066CR 16-Mar-07 06 31JAN07 111888 $6,482.32
7066I066DR 16-Mar-07 5-28FEB07 111887 $350.00
7066I066DR 16-Mar-07 7796-JAN07 111884 $78,149.00
7066I066DR 16-Mar-07 16362615-0101 111881 $7,398.59
7066I066DZ 16-Mar-07 C-Feb07 111878 $3,230.69
7066I066DZ 16-Mar-07 P251758985 111868 $1,687.74
7066I066DZ 16-Mar-07 07-01-025 111870 $7,201.91
7066I066U 16-Mar-07 5 28FEB07 111872 $850.00
7066I066U 16-Mar-07 7-02MAR07 111873 $11,564.00
7066I066U 16-Mar-07 1 Feb07 111875 $3,013.00
7066I066L 16-Mar-07 2842.002 111876 $107.01
7066I066L 16-Mar-07 6-26Feb07
111879 $3,230.50
7066I066Q 16-Mar-07 5A-07MAR07 111883 $1,623.00
7066I066Q 16-Mar-07 001-JAN07
111886 $17,393.00
Thank you in adavce for your help.
Paulo
I wonder if anyone can help me please.
I am importing a master list of records into a worksheet I call Master. Then
filter on column A to categorize the column by name, the name-field contain
the Julian-date and the initials of the individuals that created the record.
Each day I have to filter and copy the categorized records into its
corresponding worksheet. In example given below I am trying to copy a
worksheet for CR, DR, DZ and U, etc.
In the first try in setting up the formula was this but I keep having problems
=MASTER!A1((IF($A1:$E1000), $A$2='DR')
BATCH NAME BATCH DATE INVOICE NUMBER VOUCHER AMOUNT
7066I066CR 16-Mar-07 06 31JAN07 111888 $6,482.32
7066I066DR 16-Mar-07 5-28FEB07 111887 $350.00
7066I066DR 16-Mar-07 7796-JAN07 111884 $78,149.00
7066I066DR 16-Mar-07 16362615-0101 111881 $7,398.59
7066I066DZ 16-Mar-07 C-Feb07 111878 $3,230.69
7066I066DZ 16-Mar-07 P251758985 111868 $1,687.74
7066I066DZ 16-Mar-07 07-01-025 111870 $7,201.91
7066I066U 16-Mar-07 5 28FEB07 111872 $850.00
7066I066U 16-Mar-07 7-02MAR07 111873 $11,564.00
7066I066U 16-Mar-07 1 Feb07 111875 $3,013.00
7066I066L 16-Mar-07 2842.002 111876 $107.01
7066I066L 16-Mar-07 6-26Feb07
111879 $3,230.50
7066I066Q 16-Mar-07 5A-07MAR07 111883 $1,623.00
7066I066Q 16-Mar-07 001-JAN07
111886 $17,393.00
Thank you in adavce for your help.
Paulo