It appears that your application keeps track of the last row where data was
entered, and enters the next batch at Ax, where x is lastrow+1. You need
change the application to keep track of the last COLUMN where data was
entered, and enter the next batch at X1, where X is lastcolumn+1. This will
be easier to do if you switch to R1C1 referencing.

If you cannot change the application, then after running the app you would
have to manually move the new data from wherever it was written in Col. A to
the next empty column.
--
TedMi

"Ben Vann" wrote:

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.