Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy data to other workbook (Excel2000/VB6)

    Subject edited by HansV to make it more descriptive than just 'Excel'.

    Novis in VB needs help!
    Within an excel spreadsheet, I need a code to undertake the following task.
    From Wookbook A, I want to filter on a particular column (non blanks). From the list greated, I then want to copy and paste specific data (Eg from differently headed columns) into a new Workbook ([img]/forums/images/smilies/cool.gif[/img]. I need to be able to run this macro as and when required, but subsequent paste's into Wookbook B needs to be on the next unused row.
    Alternatively, when a date is entered on a particular col in Wookbook A, a code that would automatically transfer selected data to Wookbook B without the neeed for a macro button.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy data to other workbook (Excel2000/VB6)

    Can you upload a workbook that shows what you want to do. Macros can't work on non-specific information like "a particular column," the macro needs to know the specific column or some rule that will identify the column. We would also need to know other information, like what workbook you want to copy to and where to find it, or if you want an open file dialog box to navigate to the file, or will the file always be open. What sheet in the workbook do you want copy to and what column in that sheet.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy data to other workbook (Excel2000/VB6)

    Thanks for your promt response. Having a bit of a re-think at the moment as to the implications of removing data from the entry workbook.
    Will get back to you when head clears!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •