Create a macro to open workbooks

[Closed]
Report
Posts
3
Registration date
Saturday March 24, 2018
Status
Member
Last seen
March 24, 2018
-
Posts
3
Registration date
Saturday March 24, 2018
Status
Member
Last seen
March 24, 2018
-
Hello,

Please help me to create a macro which will help me to open different excel workbooks and copy particular data/ figures from excel sheets to a new workbook m.

I have around 45-50 excel workbook with 3-5 sheets in each workbook.

Each workbook is named as different unique number such as 823456,823731...etc. All the excel sheets inside workbook is named as same as VOR, Customer Copy, etc..

I want to create a macro which will help me to open each workbook and will copy figures and paste in another excel workbook.

Is it possible!? What details we need more !!!

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,920
I suggest your hire a EXCEL consultant.

I am afraid that no one here is willing to spend their time to help you make money.
Posts
3
Registration date
Saturday March 24, 2018
Status
Member
Last seen
March 24, 2018

Thanks