Hi there;
i am trying to run a complex script to do the following:

1. copy a range that contains formulas from my master sheet ("Data_ Collector")
2. pick a list of existing workbooks in an existing directory
3. copy "Data_Collector" to each of the workbooks to a specific cell on "Sheet1" ("Daily Summary")
4. Run a command on the open workbook in order to copy the formulas to a clean range with values and formats only and without empty rows
5. copy this data (values only range) to my master sheet Sheet2 ("CSV") and append to the last empty row.
6. after all workbooks processed, save Sheet2 ("CSV") to a scv file.

I have the code working for item 4
any idea on how to do that?

Many thanks in advance