+ Reply to Thread
Results 1 to 6 of 6

copy data from two or more worksheets specified

  1. #1
    Forum Contributor iscar_marius's Avatar
    Join Date
    12-19-2008
    Location
    germany
    MS-Off Ver
    2000 and 2003
    Posts
    221

    copy data from two or more worksheets specified

    I need to copy data from two ore more worksheets with specified name in a column.

    Input data:
    -name of the worksheets to be copied in column "H" from sheet "final"
    -diferent number in the worksheets in column "F" and "G"

    Outpt data:
    -I need to copy data from some worksheets(column F and G) in "final" worksheet (column A and B). But I need to copy data only from the worksheets with the name in column "H" of "final" worsksheet.

    Until now I have this code:
    Please Login or Register  to view this content.
    It works, but I have to type in the code of the worksheets names to be copied.
    I would like to type the name of the worksheets to be copied in worksheet "final" in column H.
    Please open attached file!
    Thanks!
    Last edited by iscar_marius; 02-12-2009 at 04:37 AM.

  2. #2
    Forum Contributor iscar_marius's Avatar
    Join Date
    12-19-2008
    Location
    germany
    MS-Off Ver
    2000 and 2003
    Posts
    221

    Re: copy data from two ore more worksheets specified

    it's possible to do something like this? can you sugest a way to something like this?
    Thanks!
    Last edited by iscar_marius; 02-11-2009 at 03:54 PM.

  3. #3
    Forum Contributor iscar_marius's Avatar
    Join Date
    12-19-2008
    Location
    germany
    MS-Off Ver
    2000 and 2003
    Posts
    221

    Re: copy data from two or more worksheets specified

    or some code that will copy data from all worksheets except some worksheets ?

  4. #4
    Forum Contributor iscar_marius's Avatar
    Join Date
    12-19-2008
    Location
    germany
    MS-Off Ver
    2000 and 2003
    Posts
    221

    Re: copy data from two or more worksheets specified

    I will try to explain why I need this.
    Please open attached file!
    I have a macro that will create new sheets and insert the name of the workksheet in column H frim "final" worksheet.
    I need to copy from all this new created worksheets data from column F and G and paste it in "final" worksheet, colum A and B.
    Thank you!
    Attached Files Attached Files

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: copy data from two or more worksheets specified

    try this

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Forum Contributor iscar_marius's Avatar
    Join Date
    12-19-2008
    Location
    germany
    MS-Off Ver
    2000 and 2003
    Posts
    221

    Re: copy data from two or more worksheets specified

    It's working, thank you very much

+ 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