Ok,
I've got a spreadsheet that I'm trying to create and one of the requirements is as follows; I have a load of tasks down the left side, with a row of dates along (they are split into monthly sheets) the top. What I'd like on the right hand side is an automatically filled column on the right hand side of the sheet that reads the row for a last filled date for each specific task, that then reads the date that it was completed and enters it on the right hand side. I think its called HLOOKUP but i've no idea how to use it?
Example:
Uploaded with ImageShack.us
So where the Black box is, those dates are automatically filled by some clever code that reads across each of their respective columns and reads the date along the top row!
Thanks
I've got a spreadsheet that I'm trying to create and one of the requirements is as follows; I have a load of tasks down the left side, with a row of dates along (they are split into monthly sheets) the top. What I'd like on the right hand side is an automatically filled column on the right hand side of the sheet that reads the row for a last filled date for each specific task, that then reads the date that it was completed and enters it on the right hand side. I think its called HLOOKUP but i've no idea how to use it?
Example:
Uploaded with ImageShack.us
So where the Black box is, those dates are automatically filled by some clever code that reads across each of their respective columns and reads the date along the top row!
Thanks
Last edited: