Excel 2010 formula/macro help

Closed
AJ - Feb 17, 2012 at 02:54 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Feb 23, 2012 at 05:42 AM
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

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Feb 23, 2012 at 05:42 AM
Use filter than copy paste data in worksheet 2
0