I am attempting to copy and combine two named ranges of equal size into a
blank spreadsheet. How does one copy the first named range and concurrently
seperate each copied row with a blank row into the blank spreadsheet, and
copy the second range and paste those copied records into the blank rows? I
am looking for a systematic way of doing this consolidation. There can be
hundreds of rows of data. Also the named ranges can very in size month to
month.

The end result is to combine two ranges for a journal entry upload into a
financial accounting entry. The two arrays represent the debit and credit
side.

At the moment I don't have extensive visual basic, nor macro writing skills.

Thank you.