Page data copy and paste

Wes

Board Regular
Joined
Jan 30, 2004
Messages
191
Hi All,

I've got a wee bit of a challenge ... well for me anyway and would appreciate some direction. What I have is a report where id like to have the option of once the data is typed onto a/the report i press a button and certain data is copied from the report (Active sheet) to a sheet ("MudTracking") in the back ground but to a specific column identified by a number 1-60 in Row 2 starting at column G and data to be placed in row 4. This number in row 2 would be correlated with the report number in N2 which would be from 1-60.

I'm sure this is not as clearly outlined as it should be.

Many thanks in advance.

Wes
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Wes

Board Regular
Joined
Jan 30, 2004
Messages
191
I should mention and forgot to that the range to be copied from off the active sheet is m14:m54.

Thanks again.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top