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

Need help in collecting & pasting cell values.

SRES

New Member
Hi All,

Am new to VBA and in urgent need of some support to copy three values from cells @ different places of each worksheet of a workbook that contain not less than 200 worksheets. I need to collect these values from all worksheets.

Thanks, in advance.

Regards,
Vamsee.
 
So what cells contain info? Is it fixed cells on all sheets or different? (I.E. do all sheets share same data structure?)

Whats the expected output format? Upload sample workbook with 2 sheets (or as many variation as possible if structure is different from sheet to sheet) demonstrating how data is organized and 1 sheet demonstrating output.
 
Back
Top