How to get consecutive data in different sheet

[rodante]

I am attaching my related work trying to find a way to get a row consecutive dated data from a sheet to another sheet from the same workbook.

From Register Sheet I want to get data automatically transfered in a consecutive row dated matter to Account Sheet. As you can notice in Account Sheet, data is transfered from Register Sheet, but leave some blank rows.

I had asked this before, but I could not get the exact match that I am looking for.

Please I appreciate all your help you can give me.

Thanks!

[acw]

Hi

Have a look at the attached file.

1) I've created a defined name AccNo on sheet Register to cover the dynamic range that contains the account number.
2) I've updated the formulas on Cash to bring in the relevant details
3) I've update the options on Cash to not show zero values.


HTH

Tony

[rodante]

Thank you very much!

This is been working wonderful! I appreciate your help.

God bless you.

Hi

Have a look at the attached file.

1) I've created a defined name AccNo on sheet Register to cover the dynamic range that contains the account number.
2) I've updated the formulas on Cash to bring in the relevant details
3) I've update the options on Cash to not show zero values.


HTH

Tony