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?
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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)
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

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
Back
Top