I have 2 spreadsheets that need to be linked. This is what I need:
Spreadsheet A has a basic log of information. The information is logged in
rows which each have an assigned number. This number needs to be linked to
spreadsheet A. However; Each time information in logged into spreadsheet A,
the formula needs to pick up the NEXT BLANK CELL's assigned number.