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
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