Replies

Maybe I did not explain clearly.
I want to copy data from 5 sheets into one sheet (sumu). on this sheet I only use column A. paste the first sheet data on A1, When paste the second sheet data, I need to find next empty n*17th cell like A17 or A33 or A49…etc, depends on how long the first set data is. please see the attachment.

I found out why that is not working in excel 97 because my data has head row(a1is item, b1 is qty, c1is delivery date), and I need to change the range from a1:a100 to a2:a100, b1:b100 to b2:b100, c1:c100 to c2:c100. still do not understand why I need to do so.
thank you all

Hi Legare
that is perfect for my case, thank you, but
1) that does not work with excel 97(I have other older computer)
2) if I change the condition to or (count items meet any one of the condition)
any help will be appreciated.

=VALUE(TEXT(A1,”mmddyy”)) is the one I needed. thank you all for the help.

Ingrid S
thank you very much, it works wonderfully.