Excel 2010 formula/macro help [Closed]

Question

Excel 2010 formula/macro help [Closed]

Report

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

Excel 2010 formula/macro help
Excel 2010-VB Macro formula into many spreadsheets ✓ - Forum - Excel
How to get formula bar in excel 2010 - How-To - Excel
Excel 2010 VBA Date Formula ✓ - Forum - Excel
Excel @ in formula ✓ - Forum - Excel
How to copy data from one sheet to another in excel using formula - How-To - Excel

1 reply

Ask a question

RWomanizer · Answer 1 · 2012-02-23T05:42:15-0500

Answer 1 / 1

RWomanizer

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

118
Feb 23, 2012 at 05:42 AM

Use filter than copy paste data in worksheet 2

Excel 2010 formula/macro help [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!