Copy specifc cells from adjacent Workbook

Hello everybody

I have two workbooks (Customers and Bills)
In WB named Customers I have the following code that copy specific cells from first sheet only in WB Bills
I want to loop in all sheets not only one sheet and copy the data from these specific cells

Another point as for Type column it should be the letters before the backet (
say sheet name in Bills Workbook named INV.(12311) >> in Type column I have to get the letters before the first bracket (

As for Column Curr. I want to search for the string (Total Invoice) in the sheet and to use offset to get the string (EGP) for example..

And depending on Curr. column the value in the row (Net Due) to be copied in proper column .. as in my example to be put in column EGP

I hope it is clear

We caan start by using loop at first .. Step by step if it is difficult But I know it is very easy with professionals

After many tries I could loop through the sheets

Please Login or Register  to view this content.

But I still need it to be complete

In Type column it should be the letters before the backet (
say sheet name in Bills Workbook named INV.(12311) >> in Type column I have to get the letters before the first bracket (

As for Column Curr. I want to search for the string (Total Invoice) in the sheet and to use offset to get the string (EGP) for example..

And depending on Curr. column the value in the row (Net Due) to be copied in proper column .. as in my example to be put in column EGP

Now I solved that part of Column Type by this line

Please Login or Register  to view this content.

Help me with the rest... Just last point :
As for Column Curr. I want to search for the string (Total Invoice) in the sheet and to use offset to get the string (EGP) for example..

And depending on Curr. column the value in the row (Net Due) to be copied in proper column .. as in my example to be put in column EGP