Excel 2010 formula/macro help [Closed]

Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,

I'm hoping some of you excel wiz's can help me, I've been off the tools too long.

Worksheet 1
Column A contains dates
Column B contains numbers

I want to copy all numbers from column B into Worksheet 2 if a particular month is beside the number in column A. i.e. 1A = January, 2A = February, 3A = January copy cell contents (numbers) from column B next to 1A and 3A in to worksheet 2

Hope this makes sense.

Many thanks inadvance,
AJ

1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
Use filter than copy paste data in worksheet 2

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!