Display last row entered

Spero

New Member
Joined
Jul 22, 2008
Messages
3
Hey all,

I need help with Excel. I need to put together an Excel workbook to keep track of our interactions with clients. Each client would have a log on a separate sheet in the workbook, and people would fill in the last point of contact/action done for that client.

So the question is, is there a formula that I can use on worksheet A to automatically find/display only the last row entered for worksheet B?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Oaktree

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

If they're entering text, try =MATCH(REPT("Z",255),'Sheet 2 name'!B:B)
If they're entering numbers, try =MATCH(9.99999999999999E307,'Sheet 2 name'!B:B)
 

Spero

New Member
Joined
Jul 22, 2008
Messages
3
Thanks Oaktree.

I fiddled with the formula until I thought I understood it, but it only returned the row number for the last row in the spreadsheet, but not the contents of an actual cell. Is there a sister cell this should be paired with?
 

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Spero, try this macro. be sure to replace the names of the worksheets into the macro.

Code:
Sub LastRowCopy()
Dim LR as Integer
 
Sheets("*name of worksheet B*").Select
LR = Range("A" & Rows.Count).End(xlUp).Row
Rows(LR).Copy
Sheets("*name of worksheet A*").Select
Rows(2).PasteSpecial
 
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,122,655
Messages
5,597,384
Members
414,141
Latest member
Joey_T92

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