copy row to different sheet if criteria met

MAP

Active Member
Joined
Mar 22, 2007
Messages
305
Office Version
  1. 2007
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

MAP

Active Member
Joined
Mar 22, 2007
Messages
305
Office Version
  1. 2007
Platform
  1. Windows
I will appreciate your help
 

gd6noob

Board Regular
Joined
Oct 20, 2017
Messages
91
Office Version
  1. 2016
Platform
  1. Windows
I think VBA would be a lot easier in this scenario...
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,066
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Please show us a sample of your data and the expected outcome. Use XL2BB to upload. See instructions in my signature. Since you joined here in 2007, your profile shows you using XL2007. Have you upgraded. If so, please advise and amend your profile as solutions vary according to your version.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,691
Messages
5,597,562
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top