You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • Do this:
    Put a unique id in a new column of you tine recording work sheet. Put it one column to the left of the existing columns. So each row now has a unique id.
    Go the worksheet your work wants you to use. Put a new column to the left of that.

    Make it say a1 = a1 time sheet.

    Then do a vlookup of this number so it returns the numbers from your time recorder in the order you want.

  • In that case I'd skip the id column and use the INDIRECT formula along with ROW and COLUMN to tidy it up. (Am I doing this right?)

About

Avatar for aggi @aggi started