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

Summarising data from a number of Spreadsheets into one Spreadsheet

V

vatluri3101

New Member
I have a workbook with a number of spreadsheets with similar data for a single parameter(name) for each date. Now want to collect data for a single date for all the names into one worksheet. I tried to use vlookup to select the necessary data and dump into into the summary worksheet using a single formula formulating the name of worksheet dynamically using the value in a cell where the name is entered in worksheet dealing with each name. Can somebody in this forum help me?


Thank you,

Venkat

I wnnt clarify more about my requiremen: I am trying to use the value returned by a formuls, in VLOOKUP formuls but it is not using the value returned by the embedded formula. How to make it work?

Thank you,

Venkat
 
You might be able to find what you need here:

http://www.rondebruin.nl/tips.htm

Look under the Copy/Paste/Merge examples.
 
You must log in or register to reply here.
Back
Top