copy specific cells based on topics headers from sheet to another

[tubrak]

hi experts
I have many data for many customers , each customer contain table show the process of purchasing and pay the debits and how the balance becomes after all of theses processes
so it should bring the values based on headers contain (name,debit,credit,balance) with considering the data are increasable every time add a new customer then should update in sheet
result , I put the expected result in sheet RESULT with highlight the minus value in cell BALANCE

[maniacb]

Here is an option

Please Login or Register  to view this content.

[tubrak]

perfect !
just question when loop the data in sheet DATA it loops through the filled cells or also the blanks cells
I just want loop through the cells contain data to doesn't make slow the code

[maniacb]

It currently looks at all cells in the loop, because we don't know the separated rows between each table.

[tubrak]

we don't know the separated rows between each table.

you're right , it missed me . OK but can you do that by array or dictionary. I'm afraid the code becomes slow if I increase the data .
is that necessary or not ?

[maniacb]

Try this one

Please Login or Register  to view this content.

[tubrak]

thanks very much

[maniacb]

I took your advice and used an array(coudn't think last night) and came up with a faster solution this morning.

Please Login or Register  to view this content.

[tubrak]

thanks again it's better