Dec 26 2021 10:58 PM - edited Dec 28 2021 09:08 PM
Hello Everyone,
I have multiple files (same template) placed on one location. I need to open file available at folder one by one & pull only required data from each file.
Template which have data is attached herewith (form.xlsx) & required output file is also attached.
I tried to note down flow of process & tried to devlop code as well however not able to execute completely, can someone look at files & suggest easy code for this flow.
Thanks!
@Hans Vogelaar can you help on this
Dec 27 2021 12:05 AM
Dec 27 2021 01:11 AM
Dec 27 2021 01:26 AM
Dec 27 2021 05:25 AM
Dec 29 2021 05:06 AM
In your description, two different cells have to be copied to I2:
"Copy from L7:O7 till L56:O56 (or row till we have data) & paste without formatting in cell F2:I2"
"Copy E4 & paste without formatting in cell I2 of required output file"