I have a datasheet (ProjectData) that collects data from a userform. Each time the userform is used it puts the data into the next empty row of my datasheet.
However, I then want to link the data from the last used row in the datasheet to specific cells in other worksheets (which make up the report I am trying to create).
Normally I would just copy from the datasheet i.e. A5 and then paste (link) into the specific cells of other worksheets i.e.
=ProjectData!$A$5
BUT instead of row 5 of column A in the worksheet ProjectData, I want it to automatically link whatever was the last row of column A populated in my datasheet ProjectData
It is driving me crazy because it has to be something really easy.
Bookmarks