WednesdayC
Board Regular
- Joined
- Nov 7, 2010
- Messages
- 201
- Office Version
- 2016
- Platform
- MacOS
Hi All
Please can someone help me as I really stuck with this.
I need to match several values to another worksheet, where these values will be the column headers and retrieve the last entry in that column.
So for instance - say I am looking for "CHECK 4" on 1 sheet and this will be the header of one of the columns in another sheet - (the position of the column header will change, but it will always be a column header and assuming it is row 1 of column D for now) then I need to retrieve the last entry in column D on to my other worksheet.
I am happy with either a formula or VBA. Any help would be appreciated.
Many thanks in advance
Wednesday
Please can someone help me as I really stuck with this.
I need to match several values to another worksheet, where these values will be the column headers and retrieve the last entry in that column.
So for instance - say I am looking for "CHECK 4" on 1 sheet and this will be the header of one of the columns in another sheet - (the position of the column header will change, but it will always be a column header and assuming it is row 1 of column D for now) then I need to retrieve the last entry in column D on to my other worksheet.
I am happy with either a formula or VBA. Any help would be appreciated.
Many thanks in advance
Wednesday