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?
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,940
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,453
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...
 

Forum statistics

Threads
1,081,690
Messages
5,360,614
Members
400,592
Latest member
badgergurl

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top