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