• 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.

Copy data from multiple sheets to a new workbook in a different format

N

Nagendra.rao

New Member
hi..


i have status report for each project. Each sheet is dedicated for one project and contains history of project. We append a new row every week for the latest update for each project in their respective sheets.


i need to get a consolidated report of all projects in a single excel sheet same workbook or new workbook. i.e. the latest row added and respective 5 columns details.


Which formula should i be using or what is the best way.
 
Hi Rao,


It will be good if you maintain all your data in Tables as the data is updated everyweek.

You can use the 3D reference or try out with the inbuilt consolidation in Data Tab(excel 2007 & above)

Please post a sample workbook as it will be more clear as to how your data looks & what type of consolidation you want.
 
You must log in or register to reply here.
Back
Top