scottmcclean
New Member
- Joined
- Jul 2, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi All,
I am new to the more advanced uses of Excel and a total novice at Macros etc. The problem that I have is that I have a userform that (amongst other things) adds overtime data for multiple people, for multiple project reports into a worksheet. The trouble is, is that I would like to be able to extract this data and format it in a certain way. I am struggling to firstly - understand what the best method is to select and format the data (is it a formula or macro) and then once that is understood how I structure the formula/macro.
I would appreciate a steer in the right direction please!
Overtime is submitted after the week it was done. (i.e. Current week minus 1).
"ProjectUpdates" is the main data form that is populated via a VBA Form.
"Overtime" is the second worksheet where I would like to put the data from "ProjectUpdates"
If Team Member's name in "Overtime" column A, matches a name and the week number (28) from "ProjectUpdates"
If match found then copy acrosss the week commencing date ("ProjectUpdates column E) and copy across the overtime hours for mon/tues/wed etc (Overtime columns 6/7/8/9/10 into the corresponding columns in "Overtime"
Then move to the next name in the list etc etc.....
many thanks
I am new to the more advanced uses of Excel and a total novice at Macros etc. The problem that I have is that I have a userform that (amongst other things) adds overtime data for multiple people, for multiple project reports into a worksheet. The trouble is, is that I would like to be able to extract this data and format it in a certain way. I am struggling to firstly - understand what the best method is to select and format the data (is it a formula or macro) and then once that is understood how I structure the formula/macro.
I would appreciate a steer in the right direction please!
Overtime is submitted after the week it was done. (i.e. Current week minus 1).
"ProjectUpdates" is the main data form that is populated via a VBA Form.
"Overtime" is the second worksheet where I would like to put the data from "ProjectUpdates"
If Team Member's name in "Overtime" column A, matches a name and the week number (28) from "ProjectUpdates"
If match found then copy acrosss the week commencing date ("ProjectUpdates column E) and copy across the overtime hours for mon/tues/wed etc (Overtime columns 6/7/8/9/10 into the corresponding columns in "Overtime"
Then move to the next name in the list etc etc.....
many thanks