How to create sheets based on cell value

or an if else statement, where if value in cell j2 equals debit then place value in column e, else f, I think that is a better explanation.

All I have is:

Please Login or Register  to view this content.

Hi !

Is it so difficult to attach a before workbook and an expected result workbook and crystal clear explain the need ?

Book 2 has that, at least I think it does. Sheet1 is the data, and the two tabs are how it should look.

In book2 your last 4 rows are not clear. The value in col J does not match cols K & M

Oh I see what you mean - okay here it goes.

Sheet1 is the data that this database generates for different customers. Basically the macro needs to create a tab for the different accounts found in column "C" which it does. From there it should create headers in those new tabs, which again the macro I have does as well. Then the data (account, date, description and amount) in sheet1 needs to be transferred to the tab under its name. The macro already transfers over the account, date and description. The only thing I would like help with here is placing the amount in the appropriate column.

For example, row 2, cell j2 says "Debit". Well then that amount should appear in in tab "123456" in column "E" under debit. As you can see, row 3, cell j3 says "Credit" so then that amount should be displayed in column "F".

Do cols K & M still exist in your file? If so why change the macro?

They do exist, there were a few changes.

Column C which previously existed had account 123456 and either column K or M had account 123456. Well now column K or M read KLM000000123456 which throws off the macro on where to place the amount. I figure a way around it is to use a column that was just added with this change that identifies that amount as a debit or credit now found in column j.

In that case can you please supply an accurate sample of what your data is like?

Should have done that from the beginning. Here it is with the adjusted ranges in the macro. Book1 is the data that is provided, the tab named "987654" is what the macro should create.

HTML Code: 

Ok, how about

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

man you are gonna hate me - lol. It removes the additional amounts but there is an issue with the debits. The credits on the new tabs created are 100% right - but the debits are not. For example, account 987654 debit dated Feb. 03, 2018 has 101, on the new tab it has 102. It does that for all tabs. All credits add up but the debits do not.

Oops, forgot to change this bit

Please Login or Register  to view this content.

Thank you very much! I do appreciate your time and patience.

Glad to help & thanks for the feedback