hiljaisuus
New Member
- Joined
- Feb 8, 2012
- Messages
- 1
I'm quite stumped trying to figure out how to do this, so I'm turning for this community for help. I'm working with Excel 2011 for Mac.
The setup:
I have a workbook with two sheets: Master List and User List.
Master List contains a large number of rows (starting from a row 4) with various pieces of information on Columns B-H. I'm interested in Columns B and E.
User List has matching column headers, and a field A2 with the name that matches one of the possible values in the column E in the Master List.
What I'm trying to do:
I'm looking to create a macro that goes through the data in Master List, and:
1. if the column E on any row matches the value of A2 in User List,
2. copy the value in the column A on that row to the column D on the User List, starting from the row 6.
And does this for all the rows where the column E matches the given criteria.
The Master List data will be updated on a regular basis, so I'm looking for a macro that I can easily run whenever needed and update the data on the User List.
Any help, tips and pointers appreciated!
The setup:
I have a workbook with two sheets: Master List and User List.
Master List contains a large number of rows (starting from a row 4) with various pieces of information on Columns B-H. I'm interested in Columns B and E.
User List has matching column headers, and a field A2 with the name that matches one of the possible values in the column E in the Master List.
What I'm trying to do:
I'm looking to create a macro that goes through the data in Master List, and:
1. if the column E on any row matches the value of A2 in User List,
2. copy the value in the column A on that row to the column D on the User List, starting from the row 6.
And does this for all the rows where the column E matches the given criteria.
The Master List data will be updated on a regular basis, so I'm looking for a macro that I can easily run whenever needed and update the data on the User List.
Any help, tips and pointers appreciated!