VBA to transfer values to one table to another

[Camaalot]

Hi,

I have some problem with this VBA code that is use to transfer values from one table to another.

Please Login or Register  to view this content.

I don't understand why I can transfer values from :

Chequing to Savings account and vice versa,
Chequing to Celi
and Chequing to Line

but I can't transfer from Celi to chequing and
LIne to Chequing.

My second question is :
Why do the values in Line of credit appear in AO9 instead of AO7 ?

Thanks for your answer. This project is important for me

Camaalot

[AlphaFrog]

but I can't transfer from Celi to chequing and
LIne to Chequing.

This line exclues changes to columns 31, 33, 43, and 45
And the entry in cell AQ10 is missing an n; Transfer Line-Chequing

Please Login or Register  to view this content.

My second question is :
Why do the values in Line of credit appear in AO9 instead of AO7 ?

This line of code finds the last used row starting from the bottom row 102 on up. It does not find the first empty cell.

Please Login or Register  to view this content.

[AlphaFrog]

This code...

Please Login or Register  to view this content.

Can replace this...

Please Login or Register  to view this content.

Or you could do it by column Headers.

Please Login or Register  to view this content.

[Camaalot]

Thanks AlphaFrog for your quick reply.

Your answer made my life easier.

Thanks again,

Camaalot

[AlphaFrog]

Your welcome. Thanks for the feedback.

I edited the Headers line of code in post #3 from an OR to AND.