Copy last data entered into mulitiple sheets within a workbook?
 

Hi Boffins,

I'm stuck :(

My collegues take multiple plant readings on an oil rig, and enter them into
several spreadsheets within a workbook. Each piece of plant requires certain
data to be recorded at regular intervals throughout a working shift.
Presently they input manually into each spreadsheet within the workbook
detailing the data and time which they enter the data. The data is then
compared with certain design parameters and if higher then designed, then
conditional formatting of the spreadsheets turns the text to either yellow or
red depending on the value.
What I would like to do (and this is where you guys come in), is extract the
most current data in the spreadsheet (last entered) and pull it onto a
separate report to give to the team onshore. Can anyone suggest a way of
doing this.
At the moment it's a manual task.

Grateful for any suggestions

Copy last data entered into mulitiple sheets within a workbook?
 

Is the latest data always the last entered row??
--
Gary''s Student - gsnu200845


"Big Al" wrote:

Hi Boffins,

I'm stuck :(

My collegues take multiple plant readings on an oil rig, and enter them into
several spreadsheets within a workbook. Each piece of plant requires certain
data to be recorded at regular intervals throughout a working shift.
Presently they input manually into each spreadsheet within the workbook
detailing the data and time which they enter the data. The data is then
compared with certain design parameters and if higher then designed, then
conditional formatting of the spreadsheets turns the text to either yellow or
red depending on the value.
What I would like to do (and this is where you guys come in), is extract the
most current data in the spreadsheet (last entered) and pull it onto a
separate report to give to the team onshore. Can anyone suggest a way of
doing this.
At the moment it's a manual task.

Grateful for any suggestions

Copy last data entered into mulitiple sheets within a workbook
 

Yes it would be.

"Gary''s Student" wrote:

Is the latest data always the last entered row??
--
Gary''s Student - gsnu200845


"Big Al" wrote:

Hi Boffins,

I'm stuck :(

My collegues take multiple plant readings on an oil rig, and enter them into
several spreadsheets within a workbook. Each piece of plant requires certain
data to be recorded at regular intervals throughout a working shift.
Presently they input manually into each spreadsheet within the workbook
detailing the data and time which they enter the data. The data is then
compared with certain design parameters and if higher then designed, then
conditional formatting of the spreadsheets turns the text to either yellow or
red depending on the value.
What I would like to do (and this is where you guys come in), is extract the
most current data in the spreadsheet (last entered) and pull it onto a
separate report to give to the team onshore. Can anyone suggest a way of
doing this.
At the moment it's a manual task.

Grateful for any suggestions