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