Populate a letter from a spreadsheet
I have a spreadsheet that has the following list:
Seqential No., Reference No., Date, Debit, Credit.
I want to able to write a report or letter (in Excel) that has a narrative in the begining and then it would say:
The following are your Debit entries:
and the VBA code will insert all the rows ( Ref. No., Date, Debit amount) from the above sheet that have a debit value here.
Then my report/letter would say:
The follwoing are you Credit entries:
and the VBA code will insert all Credit rows ( Ref. No., Date, Credit amount) from the above sheet here.
The thing is, the number of rows with Debit or Credit change from one month to another and from one customer to another.
Can somebody please help.
ps. My knowledge of VBA is zero.