Is this possible?

S

Sam

What I'm trying to do is find a way to automatically
update the hour meter readings on a second separate Excel
spreadsheet when I update it on the first hour meter
readings of the first spreadsheet.
 
G

Gord Dibben

Sam

As simple as linking the second sheet cells to the first sheet cells.

In Sheet2 in A1 enter =Sheet1!A1

OR just copy the readings cells on Sheet1.

Click on Sheet2,select a cell and Paste Special>Paste Link

The not-so-simple is you may require more than this. i.e. you want the past
hour's readings on the second sheet to remain and the new readings added.

Post back with more detail if the latter is the case.

Gord Dibben XL2002
 
Top