+ Reply to Thread
Results 1 to 3 of 3

copy and paste to different sheet

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Logan, Utah
    MS-Off Ver
    Excel 2007
    Posts
    15

    copy and paste to different sheet

    After searching here as well as doing several google searches I have found some that closely match what I'm trying to do but not exactly. I hope you guys can help me out. attached is a workbook to hopefully identify what i'm trying to accomplish.

    I have a dropdown list cell A1 with "Sheet1,Sheet2,Sheet3,etc" located on an irrelevant sheet "SheetHome" I would like to copy data from "SheetHome" and then have it look to Cell A1 (where it says Sheet1...), then go to that corresponding sheet and paste the data.

    Is this possible?
    Attached Files Attached Files
    Last edited by plague5050; 05-06-2013 at 04:03 PM.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: copy and paste to different sheet

    Please find the file attached.. Please revert if this is not what you were looking for..

    Cheers!!

    Deep
    Attached Files Attached Files
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    Logan, Utah
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: copy and paste to different sheet

    works perfectly. thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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