Excel 2010 formula/macro help

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

1 response

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