+ Reply to Thread
Results 1 to 3 of 3

Copy specific cell value on sheet1 to specific cell on sheet2 or other sheet.

  1. #1
    Registered User
    Join Date
    05-30-2014
    Location
    Lima, Peru
    Posts
    31

    Copy specific cell value on sheet1 to specific cell on sheet2 or other sheet.

    I do not want to copy a row or column on sheet1 to sheet2. I have cell values in multiple cells, different columns that need to go to sheet2, different columns-different rows. From looking at several examples, I understand the code below...somewhat.
    I understand that the Dim line tells VBA that 'Gen, WiL, VsR, and HsE' are to be recognized as worksheets and the Set-tells it which sheet to look at for the Dim setting.

    What I can't find, is an example of code to copy... example:
    The Value of cell 'gen B14' to 'VsR G8', when the 'ByFuse' command button is clicked.

    Every thing I find is about rows or columns being copied to the next empty row.

    Please Login or Register  to view this content.
    Any help would be greatly appreciated,
    GfC
    Last edited by Mr.GfCs; 05-20-2015 at 05:00 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy specific cell value on sheet1 to specific cell on sheet2 or other sheet.

    Please Login or Register  to view this content.
    Or

    Please Login or Register  to view this content.
    Last edited by xladept; 05-20-2015 at 03:38 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    05-30-2014
    Location
    Lima, Peru
    Posts
    31

    Re: Copy specific cell value on sheet1 to specific cell on sheet2 or other sheet.

    Xladept, the .copy in the formula copys the cell format. I need to copy the value in the cell, not the formatting....

    But I did get the code needed:
    Please Login or Register  to view this content.
    Last edited by Mr.GfCs; 05-20-2015 at 05:00 PM.

+ 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. Copying data returning an error in Sheet1 to next empty cell in specific column of Sheet2
    By cloudwalking in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-22-2013, 09:02 AM
  2. Replies: 0
    Last Post: 10-09-2012, 08:46 PM
  3. Copy column from sheet2 if specific cell in sheet1 is "QLD"
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2012, 04:57 PM
  4. Replies: 2
    Last Post: 04-16-2012, 10:23 PM
  5. How to copy a range of columns from sheet1 to sheet2 if the cell show a specific text
    By chermaine123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2011, 02:39 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