CreateJournal.xlsm

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an external table that I would like to download to excel each month and then create journal entries. &nbsp;The rows on the external file vary per month. &nbsp;I would like to set this up so I'm not having to copy/paste or creating new formulas each month. &nbsp;Below is an example of the external table and what I would like the end result to look like. &nbsp;. &nbsp;Please let me know if this is possible.<br />
<br />
'Before'<br />
Batch &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amount &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date<br />
11568 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016<br />
11475 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50 &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016<br />
11837 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;300 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 6/30/2016<br />
<br />
'After'<br />
Batch &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amount &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Type<br />
11568 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Debit<br />
11475 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Debit<br />
11837 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;300 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Debit<br />
11568 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Credit <br />
11475 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Credit <br />
11837 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;300 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/30/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Credit
</div>
</div>


Hi,

I have an external table that I would like to download to excel each month and then create journal entries.  The rows on the external file vary per month.  I would like to set this up so I'm not having to copy/paste or creating new formulas each month.  Below is an example of the external table and what I would like the end result to look like.  .  Please let me know if this is possible.

'Before'
Batch	Amount	Date
11568	100   	6/30/2016
11475	50    	6/30/2016
11837	300	        6/30/2016

'After'
Batch	Amount	Date	Type
11568	100	6/30/2016	Debit
11475	50	6/30/2016	Debit
11837	300	6/30/2016	Debit
11568	100	6/30/2016	Credit 
11475	50	6/30/2016	Credit 
11837	300	6/30/2016	Credit

Excel - Auto-Create Journal Entries

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.