+ Reply to Thread
Results 1 to 6 of 6

Copying different values from different cells, and pasting into different worksheets

  1. #1
    Registered User
    Join Date
    08-04-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    10

    Copying different values from different cells, and pasting into different worksheets

    Hi All,

    I know that the title sounds a bit complicated, so here's the codes so far.

    I've used macro recorder to achieve this.

    Sub Macro1()

    Please Login or Register  to view this content.

    From here, all of you can see that the steps are repetitive. Sheet "EGT ID" contains a long column of values and you can see it in the range C3, C4, C5 and the list goes on. Its a total of 500 values.

    Sheet "Sheet1 (2)", "Sheet1 (3)", "Sheet1 (4)" and so on are the the destinations of where the different cells from sheet "EGT ID" should go to.

    This macro recorded works perfectly fine, but just one small issue: there's 500 sheets that i need to copy to ("Sheet1" to "Sheet1 (500)".

    Basically, there is 500 values/cells (C2 to C501) in sheet "EGT ID" to be inserted individually in the 500 sheets ("Sheet1" to "Sheet1 (500)") in cell B2 of each sheet.

    So is there a way to automate/fine-tune the codes above for it to work?

    Many thanks in advance to any VBA experts and gurus out there who are willing to help
    Last edited by farhan13; 12-02-2014 at 02:57 AM.

  2. #2
    Registered User
    Join Date
    02-20-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Copying different values from different cells, and pasting into different worksheets

    Can you send an example file for us to use?

  3. #3
    Registered User
    Join Date
    08-04-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    10

    Re: Copying different values from different cells, and pasting into different worksheets

    Hi estratosphere,

    Yes surely will. Sorry I got to zip it as the actual excel file exceeds 1 MB. Thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-20-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Copying different values from different cells, and pasting into different worksheets

    Farhan13,

    I have completed this task for you - the workbook is enclosed.
    Simple piece of code really - just click the Run button on the EGT ID sheetMYuserEGTupdate - forum.zip

    Please Login or Register  to view this content.
    MYuserEGTupdate - forum.zip

  5. #5
    Registered User
    Join Date
    08-04-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    10

    Re: Copying different values from different cells, and pasting into different worksheets

    Thank you very much estratosphere! Works like magic!

  6. #6
    Registered User
    Join Date
    02-20-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Copying different values from different cells, and pasting into different worksheets

    Glad I could help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Converting formulas to values while copying/pasting columns between worksheets (vba)
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2014, 11:55 AM
  2. Replies: 0
    Last Post: 05-15-2013, 03:22 AM
  3. Copying and pasting cells between worksheets with links fast in 2010
    By wjw123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 06:45 PM
  4. Copying and pasting worksheets into new worksheet as values
    By MikeFranz123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2012, 05:42 AM
  5. Replies: 3
    Last Post: 08-22-2007, 06:07 AM

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