Workbook will be shared, and apparently shared workbooks cannot have vba? ugh..
So my problem is this:
I have a workbook with a summary sheet. This summary sheet has a row for each aircraft. and each aircraft has its own sheet. When any status changes to an individual aircraft, we go to the appropriate sheet, input all required info in the next available blank row.
On the summary sheet I would like the last row with data from the aircraft sheets to show up in the specified row.
To summarize: Instead of having to go to each individual aircraft sheet and check the last status (row) I would like to have 1 row per aircraft automatically show the last data from each row on the summary sheet, also I cant use VBA since this will need to be opened and edited by multiple people at a time.
So what are my options??
So my problem is this:
I have a workbook with a summary sheet. This summary sheet has a row for each aircraft. and each aircraft has its own sheet. When any status changes to an individual aircraft, we go to the appropriate sheet, input all required info in the next available blank row.
On the summary sheet I would like the last row with data from the aircraft sheets to show up in the specified row.
To summarize: Instead of having to go to each individual aircraft sheet and check the last status (row) I would like to have 1 row per aircraft automatically show the last data from each row on the summary sheet, also I cant use VBA since this will need to be opened and edited by multiple people at a time.
So what are my options??