copy row to different sheet if criteria met

MAP

Active Member
Joined
Mar 22, 2007
Messages
307
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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

MAP

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

gd6noob

Board Regular
Joined
Oct 20, 2017
Messages
162
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,878
Office Version
  1. 365
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,777
Messages
5,833,643
Members
430,221
Latest member
jmmccormick

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