tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I'll try make this as clear as possible I realise its quite complex but hopefully someone can help.
Ok so I have a sheet called "Employees Details"
Column F are the Names
Column G are salary's
Now I have a sheet called Staff
In this sheet i work out their wages each month,
what i need is a macro that can look up each employees rate in "Employees Details" column G by matching their name (All names are unique)
The thing is the layout is not even so we are going to need to search for "Hourly Rate" as a header down column "C"
So if was doing this in english heres what i'd put
For each "Hourly Rate" in Column "C" look at name in cell above,
then goto "Employees Details" and find that name in column F, take the value in same row column G and put it next to the "Hourly Rate" in column D
I hope that makes sense?
please help if you can
thanks
Tony
I'll try make this as clear as possible I realise its quite complex but hopefully someone can help.
Ok so I have a sheet called "Employees Details"
Column F are the Names
Column G are salary's
Now I have a sheet called Staff
In this sheet i work out their wages each month,
what i need is a macro that can look up each employees rate in "Employees Details" column G by matching their name (All names are unique)
The thing is the layout is not even so we are going to need to search for "Hourly Rate" as a header down column "C"
So if was doing this in english heres what i'd put
For each "Hourly Rate" in Column "C" look at name in cell above,
then goto "Employees Details" and find that name in column F, take the value in same row column G and put it next to the "Hourly Rate" in column D
I hope that makes sense?
please help if you can
thanks
Tony