Formula Help

[Accounting_FLA]

So this is my first time posting on here but I was hoping I could get some help with an issue I keep having to deal with and I am sure there is some excel formula that could make this way easier. I am at a client who switched General Ledger software mid year and it's caused some issues. What I am looking to do is pull the account number from the hundred or so tables and put it next to the individual transactions so they can be filtered by account number. Each table has the corresponding accounting number at the top, how would I pull it down and have it update the account number it is placing next to the transactions as the new ones come up?

 

[Accounting_FLA]

 

[dreid1011]

Are all the transactions in each table specific to the account number listed at the top? It sounds that way.. and if that is the case, then in A10 and copy down:

=IF(B10<>"",$D$6,"")

Or

=$D$6 and copy down.

If that is not the case, how do you identify which transactions belong to each account?

 

[Accounting_FLA]

Are all the transactions in each table specific to the account number listed at the top? It sounds that way.. and if that is the case, then in A10 and copy down:

=IF(B10<>"",$D$6,"")

Or

=$D$6 and copy down.

If that is not the case, how do you identify which transactions belong to each account?

So as you can see here, the account number changes at the top of each table and the transactions within it are specific to the table. I was thinking some sort of V lookup but I'm not really looking up a specific number, it changes with each new table in the workbook.

 

[dreid1011]

And the tables are all on one sheet yes? Are the amount of empty rows in Col A the same between each table? In this case, I count 10 empty cells in Col A from 26350 to 26359.

 

[Accounting_FLA]

You got it right, all the tables are on this one sheet and there is always that space between them

 

[dreid1011]

Ok, I'll have something after lunch.

 

[dreid1011]

Give this a try:

=IF(AND(OR(A9="Account Number",A9=""),ISNUMBER(B10)),OFFSET(A9,-3,3),IF(AND(LEN(A9)=10,A9<>"",ISNUMBER(B10)),A9,""))

However, this will not work if you are inserting new rows for each new transaction. You would have to refill from the row above the new row and all the way down.