Hi,
I have attached a sample file to this thread as I think it will be a lot easier for me to explain my problem.
I have two sheets of data...
30Day sheet
The columns I'm interested in are:
Column D holds USER ID's
Columns F to AI which contain numbers or blanks, with the headers being dates (oldest to most recent from left to right)
IDs sheet
Column B holds USER ID's
Column D currently blank
What I want to do is:
1. On the 'IDs' sheet, look at the first USER ID in Column B
2. Search for that USER ID in column D of the '30Day' sheet
3. Once the USER ID has been found on the '30Day' sheet, I'd like to look between columns F:AI for the the most recent non blank cell. Meaning, starting from the RIGHT working backwards to the left, looking for the first non blank cell.
4. Once this cell is identified (lets say it's column AA), I'd like to capture the value of header row of Column AA
5. Then place this value into Column D on the 'IDs' sheet against the correct USER ID
6. Repeat this to the last row on the 'IDs' sheet, searching for the next USER ID in column B
Note: if the USER ID cannot be found, I'd like "not found" to be placed in Column D on the 'IDs' sheet
I'm ok at editing code but not the best at starting from scratch. I can create a loop to cycle down the USER ID's and store that as a variable, but I'm not sure how to search for that within the range on sheet '30Day' and then look up the header (row 1) value.
Any help would be great!
Thanks
Bookmarks