• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically copy last row from worksheets and past in Summary work sheet

N

ng876

New Member
Hi,


I have a work book with 50 work sheets. Idea is to copy the last row ( most recent update in that work sheet) and past it in summary work sheet. So that users don't have to go through every single work sheet to get most recent information. Please help me with macros.


Thank you in advance.
 
Ng876


Firstly, Welcome to the Chandoo.org Forums


If the data in the worksheets is changing from time to time, I'd suggest just using formulas


You would basically have a list of the sheet names in a Column

the Summary fields across the top

and a Formula using Indirect and a few offsets to retrieve the last values in each sheet


I'd suggest that if you can post a sample file with a few sheets we can give you a better answer.

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
You must log in or register to reply here.
Back
Top