Appending columns
I have an application that exports a stream of data to Excel. Each time the
program runs it append to the previous run in column A. The data for each
subset takes up the same amount of rows as the previous. Example; the first
group of data will occupy cells A1 thru 10 and the second group A11 thru A20.
I want the second group to occupy B1 thru B10. In stead of cutting and
pasting is there a macro or function that will do this with only changing a
few parameters? Thanks for your help.
|