multiple sheets to masterfile (different cells)- VBA

Dear all,

I'm new on this forum and I need your support.
I will really appreciate it if someone can help me


I have for 1 week like 50 PDF files that I have to convert to excel, so I found a program that creates 1 excel file with all the sheets.
now I need some data from each sheet ,to make it easy for you I marked the values that I need in 3 different colors. (see excel in attachment)

-adress : always in same cell (B8)
-order number: it depends if there is multiple work in 1 adress there are different order numbers
-Sap number : it will be in Cell F9/F10

conclusion : I need for each adress order number(s) and Sap number(s)

my question: is there any solution to create a masterfile with VBA ?
I Can't work with colors and sort/filter them later because as I mentioned there are like 50 sheets in 1 week.

Can someone help me? which function can i use ? or which way will be easiest?

thanks in advance.

For the data uploaded.

Please Login or Register  to view this content.

Hello Jindon,

thanks a lot for your quick reply.
I have an error on this line : .Cells(n, 2).Resize(UBound(a)).Value = a
I Can't run the VBA code..

thanks in advance for your reply.

with kind regards,
osman

Are you getting error on the file I uploaded?
If so, no idea, it is working fine for me.

Hi,

yes, it's strange..
Attachment 713672Attachment 713673

Perhaps, excel version...
Try

Please Login or Register  to view this content.

Hi Jindon,

I tried your first file with a different computer (office365) and it worked.

thanks a lot for your support have a nice day

with kind regards,
osman

The last one should work with any version and error trapping added, so better than the first one.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.