Debit/Credit Journal Formula

Hi,

I have had help on different posts previously with auto populating a journal and needing it to determine the correct side of the journal based on a “+” and “-“.

I need the same but this time with a different data set that is in a different layout.

The data is on the sheet “Monthly Data” in the cell columns H:T. I need certain row data (highlighted in red) pulled from the Monthly Data sheet onto the monthly journal. The main compliation would be which side of the journal to post “+” is debit and “-“ is credit.

Can someone help please?

Hi,

I managed to get one formula working which pulls in three of the fields (=INDEX('Monthly Data'!$M$5:$T$199,ROWS(C$13:C13),1))

However I am truely stuck on the last bit - getting a formula to determine if its a debit or credit and then placing it in column J or K.

It would need to be something like if row 1, column R on the monthly sheet is a "+" then return it to J13 of the journal sheet, if it is a "-" then return it to K13

Hi Ace - when I apply these I have Circular references - would you know why this would be?

Strange - I was running through error checker and it showed these as errors.

The formula is cell A15 causing the error was me mucking about trying to get another problem (unqiue list from 3 data sets) so I dont need it - a simple delete and its gone!

Thanks ACE!