Excel experts,
I am a novice working with Excel 2007. I have SHEET1 where all my bank transactions are listed - not necessarily in chronological order. Column B has the date.
I need a formula in SHEET2 that would copy the contents of the entire row in SHEET1 to SHEET2 if the month in SHEET1 column B was "January"...
the copied content should be listed starting at 2nd row of SHEET2 and should be listed down in chronological order.
I hope i was able to explain myself properly.
I will appreciate all Excel Gurus' help with formula and explanation.
I am a novice working with Excel 2007. I have SHEET1 where all my bank transactions are listed - not necessarily in chronological order. Column B has the date.
I need a formula in SHEET2 that would copy the contents of the entire row in SHEET1 to SHEET2 if the month in SHEET1 column B was "January"...
the copied content should be listed starting at 2nd row of SHEET2 and should be listed down in chronological order.
I hope i was able to explain myself properly.
I will appreciate all Excel Gurus' help with formula and explanation.