Copy in range from one wb to another from a cell in column A with a spesific word

Hello

How to copy all above a cell in column A contain the word sum "Sum the above items" is the whole word in range A10:I, i use this this vba to day and have some plan with another wb

Please Login or Register  to view this content.

Not sure if this is what you want...

Please Login or Register  to view this content.

Hello

Thanks, i was not think clear, i must copy from a different wb as here in the attacment

I will copy data from wb Prisoverslag various date after Prisoverslag and Column B62 this time, and B66 have a name Sum this time

paste it in wb E.A B8

Possibly...

Please Login or Register  to view this content.

Hello

Thank you, i get an error 1004

It say it can not find the file Workbooks.Open "Prisoverslag . 07-jun-2020.xlsx"

And this file will get new name tomorrow, Prisoverslag. 08-jun-2020.xlsx, so filename will get various except "Prisoverslag"

This will let you choose the file to open...

Please Login or Register  to view this content.

Hello

Thank you Works like a charm

Great to hear!

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