Last input on an excel speadsheet

arodriguezsawao

New Member
Joined
Nov 22, 2005
Messages
1
Hi!
I don't if this is even possible but maybe someone can help me. Is it possible to have another spreadsheet link to another one and have a cell that has some kind of formula that will give the number that was last inputed on the other spreadsheet?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,994
Welcome to the board.

Code:
=LOOKUP(9.99999999999999E307,sheet2!A:A)
will return the last value in column A of sheet 2

Is that along the lines of what you're after?
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Welcome to the board,
Oaktree's formula above will show you the value of the last cell with a value in it (the one furthest down the column) in column A of sheet2.

If you're looking for a bit more than that, and don't mind a VBA solution, you could use the worksheet change event. Try this out.
Right click the sheet tab for sheet1 and choose View code.
Paste this code into the white area that is the sheet code module.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = "" Then Exit Sub
If Target.Count > 1 Then Exit Sub
Sheets("Sheet2").[A1].Value = " '" & Target.Value & "' is the value of the last cell changed (" & Target.Address(0, 0) & ") in '" & Sheets("Sheet1").Name & "'"
End Sub
Press Alt+Q to get back to your excel sheet.
Make an entry anywhere in Sheet1 and look at cell A1 in sheet2.

Just another idea...
 

Watch MrExcel Video

Forum statistics

Threads
1,123,265
Messages
5,600,603
Members
414,393
Latest member
Vignesh Mechz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top