Macro to pull data from workbooks and return double sided accounting entry

Ok, this almost worked completly just a few issues.

Attached is the result of running this data on the actually workbook. Please note that I I removed all the actual information, but the macro was run before removing it.

It works great on the file you gave me.

When I run this on the real template it does pull the correct information with date and fund, however the first few rows have formating issues that have to deal with merged cells please see attachment. Unmerging all the cells before running the macro fixes.

When I run the macro no dollar amount is shown. So I can see the date and the GL# but not the number for the actual numbers pulled from the cells. It actually vuts of after Department#. So in the template file you have columns for

Date GL# FUND# Department# Project# $amount

In the actual workbook and even after unmerging the columns that the macro creates are:

Date GL# FUND# Department#



When I run the code I get this error: Run Time error "13": Type Mismatch

and then debugger highlights this

If cl.Value <> 0 Then