Appending columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.
.

Relevant Pages

  • Re: Parsing / " characters
    ... >The mainframe dump exports all the code in the exact order of ... so if my statement seeks the first unqiue record ... >have the rest of the code to append the ... >>>dim strCode as string ...
    (microsoft.public.access.externaldata)
  • RE: Replace existing records in a table
    ... When you create an update query, ... "Pani" wrote: ... > request sent to me by the customers in an excel format. ... >>> table and delete and append query to update my center table in Access. ...
    (microsoft.public.access.externaldata)
  • Re: Inconsistant text length export to Excel 2003
    ... Thanks for the feedback, but I am now doing as you first suggested, (hard coding using automation) to get around the fact that Access exports to an early version of Excel, even if one explicitly calls for a more capable version. ... Open your spreadsheet (I actually created a master spreadsheet that ...
    (microsoft.public.access.externaldata)
  • Re: Importing Data from Excel, but...
    ... I thought you were trying to import the data from Excel into Access. ... Sub ImportPipeline() ... All I want to do is append the data to the existing 'tblStaticData' ...
    (microsoft.public.access.externaldata)
  • Re: PowerPoint makes changes to All files with in an HTML Support Folder
    ... there's no way to track changes as exported to HTML in Word or Excel. ... > human in charge tell the app to export just the slides that've changed. ... > generating random filenames for some of the misc image and other files it exports, ...
    (microsoft.public.mac.office.powerpoint)