T
Tim Nealon
I get two downloads from my bank - one with credit information the other with
debits. Both tables contain columns that include the date, description, and
dollar amount. The number of rows differs each day, for example one day may
have 3 deposits while another day only has 1. Also the number of rows on the
debit table also varies each day and may have more or less rows than the
corresponding day on the credit table.
I would like to combine the two tables into one based on date. All the data
can be on different rows and in different columns if that is easier. For
example if the credit table for 8/29/06 looks like this:
A B C
8/29/06 Lockbox 100.00
8/29/06 Brnch Dep 150.00
8/29/06 Lockbox 200.00
8/30/06 Lockbox 175.00
and the debit table looks like this:
A B C
8/29/06 check cleared 95.00
8/30/06 check cleared 75.00
8/30/06 misc withdrawal 200.00
The combined table can look like this:
A B C D
8/29/06 Lockbox 100.00
8/29/06 Brnch Dep 150.00
8/29/06 Lockbox 200.00
8/29/06 check cleared 95.00
8/30/06 Lockbox 175.00
8/30/06 check cleared 75.00
8/30/06 misc withdrawal 200.00
Or All the amounts can be in column C - whatever is easier.
Does anyone have any ideas?
Thanks in advance
debits. Both tables contain columns that include the date, description, and
dollar amount. The number of rows differs each day, for example one day may
have 3 deposits while another day only has 1. Also the number of rows on the
debit table also varies each day and may have more or less rows than the
corresponding day on the credit table.
I would like to combine the two tables into one based on date. All the data
can be on different rows and in different columns if that is easier. For
example if the credit table for 8/29/06 looks like this:
A B C
8/29/06 Lockbox 100.00
8/29/06 Brnch Dep 150.00
8/29/06 Lockbox 200.00
8/30/06 Lockbox 175.00
and the debit table looks like this:
A B C
8/29/06 check cleared 95.00
8/30/06 check cleared 75.00
8/30/06 misc withdrawal 200.00
The combined table can look like this:
A B C D
8/29/06 Lockbox 100.00
8/29/06 Brnch Dep 150.00
8/29/06 Lockbox 200.00
8/29/06 check cleared 95.00
8/30/06 Lockbox 175.00
8/30/06 check cleared 75.00
8/30/06 misc withdrawal 200.00
Or All the amounts can be in column C - whatever is easier.
Does anyone have any ideas?
Thanks in advance