Help please!
I have been asked to create a spreadsheet that tracks the hours worked on different building jobs. Each building job is assigned a unique identifying number, which is in column A on both workbooks.
What I now want to be able to do is make it so that, if the number in column A on my new workbook matches the number on column A on the existing work tracker then import the total number of hours worked on that particular job (recorded in column BT on the existing work tracker) into a new column (F) on my new workbook.
Anybody got any idea at all about how to do this?
I have been asked to create a spreadsheet that tracks the hours worked on different building jobs. Each building job is assigned a unique identifying number, which is in column A on both workbooks.
What I now want to be able to do is make it so that, if the number in column A on my new workbook matches the number on column A on the existing work tracker then import the total number of hours worked on that particular job (recorded in column BT on the existing work tracker) into a new column (F) on my new workbook.
Anybody got any idea at all about how to do this?