1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Discussion in 'Business Applications' started by macrozealous, Jun 16, 2011.

Thread Status:
Not open for further replies.
  1. macrozealous

    macrozealous Thread Starter

    Jun 16, 2011

    I need help to create an Excel macro that would

    1. ask users to select x number of rows to be copied from one worksheet of one Excel file
    2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

    the target Excel files are all based on the same template
    there is one worksheet in each of the target Excel files

    in the target files, the rows should be copied from the first available empty row, going down

    Looking forward to your help!

    Thanks a lot.

  2. Keebellah

    Keebellah Trusted Advisor

    Mar 27, 2008
    First Name:
    Hi, welcome to the board.
    Not much info there to get the correct picture.
    Sample? Of source and template please
    And not to forget, what version of Excel are you and the users using?
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1002554

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice