Hello All
I have 5 worksheets in this workbook, sheet 1 has data in columns A:H
A...Key
B...Prod.ID
C...Date
D...Item
F...Details
G...Quantity
H...Cost
The other 4 worksheets are for 4 different accounts, what I am trying to achieve is for the data from sheet 1 to be transferred to sheets 2/3/4/5 by rows, if the "KEY" = 1 then data would go to sheet 2, KEY = 2 data to sheet 3, etc.
I can make this work by using =IF(Sheet1!A10=1,ROW(),"") , in A10 on sheet 2, together with ....
=IF(ROWS($10:10)>COUNT($A:$A),"",INDEX(Sheet1!B:B,SMALL($A:$A,ROWS($10:10)))) in cell B10.
My problem is I only want the data to transfer if the KEY is 1/ and the date ( in sheet 1 , column C ) is between the first and the last day of a month.
Any suggestions would be appreciated.
Bill S
I have 5 worksheets in this workbook, sheet 1 has data in columns A:H
A...Key
B...Prod.ID
C...Date
D...Item
F...Details
G...Quantity
H...Cost
The other 4 worksheets are for 4 different accounts, what I am trying to achieve is for the data from sheet 1 to be transferred to sheets 2/3/4/5 by rows, if the "KEY" = 1 then data would go to sheet 2, KEY = 2 data to sheet 3, etc.
I can make this work by using =IF(Sheet1!A10=1,ROW(),"") , in A10 on sheet 2, together with ....
=IF(ROWS($10:10)>COUNT($A:$A),"",INDEX(Sheet1!B:B,SMALL($A:$A,ROWS($10:10)))) in cell B10.
My problem is I only want the data to transfer if the KEY is 1/ and the date ( in sheet 1 , column C ) is between the first and the last day of a month.
Any suggestions would be appreciated.
Bill S