+ Reply to Thread
Results 1 to 1 of 1

Copy excel rows from one file to another with extra lines

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    1

    Copy excel rows from one file to another with extra lines

    Hi Excel experts,

    It has been more then 10 years that i didn't make any macro's. and i lost it all(dat memory)

    I have been trying but are unable to do a simple vba task.

    I need to copy one row at a time from one excel file to another, but i do it manually at the time. it's time consuming as hell and I make constantly mistakes due of dyslexia.

    I have tried to do recordings of macro, but it doesn't work well.

    Can you guys help me out?
    If I have code for one line, I'll manage to do the rest myself I think.

    Here's one excel file(origin.xls) from which it I have to copy from.

    and the other( destination.xls ) is where it has to be copied to.

    These are all confidential data, so I changed the description in every file.


    The copy has to be made from within the destination file. So the macro should be there as the destination is the file were everything is always added to.


    I think the simplest way is to make excel ask were the file to import is.

    Copy explanation:

    Every line from the origin file contains a few rows with data.

    the row has to be copied in a specific order. for example: the ean code at the end has to be copied to another column.
    every product has to be copied several times for every store. The stores amount and name is always the same.

    I'd be happy to give more input on my problem.

    Thank you all in advance.

    I hope to be back and more involved into excel programming as my job requires multiple automations.

    actually just started in a new very, very small company. and there is no IT departement. Everyone does various copy jobs from one excel to another manually. And I think its time to evolve xD
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1