+ Reply to Thread
Results 1 to 6 of 6

how can i link this code to another sheet?

  1. 11-10-2018, 10:46 AM #1
    lee111
    lee111 is offline
    Registered User
    Join Date
    11-09-2018
    Location
    london
    MS-Off Ver
    2013
    Posts
    4

    how can i link this code to another sheet?

    hello i'm new here,
    i do apologize, if i have posted incorrectly.

    i use the code below to log the changes of cell A1 on sheet1, each time the cell is updated the value is put into cellA2 then cell A3 ect. what i need to do is make the log on Sheet2 column A. i have tried to adjust the code to allow for this but cant get it to work.
    thanks for any help.

    Please Login or Register  to view this content.
    Last edited by AliGW; 11-10-2018 at 11:19 AM.
    Reply With QuoteRegister To Reply
  2. 11-10-2018, 10:52 AM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: how can i link this code to another sheet?

    Please wrap your code with code tags. Like:
    Please Login or Register  to view this content.
    All you have to do is move over the code from sheet1 to sheet2
    Reply With QuoteRegister To Reply
  3. 11-10-2018, 11:07 AM #3
    lee111
    lee111 is offline
    Registered User
    Join Date
    11-09-2018
    Location
    london
    MS-Off Ver
    2013
    Posts
    4

    Re: how can i link this code to another sheet?

    i cant just move it, the cell i want to log is on sheet 1. i need the result on sheet 2.
    thanks
    Reply With QuoteRegister To Reply
  4. 11-10-2018, 11:18 AM #4
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: how can i link this code to another sheet? 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 11-10-2018, 11:30 AM #5
    lee111
    lee111 is offline
    Registered User
    Join Date
    11-09-2018
    Location
    london
    MS-Off Ver
    2013
    Posts
    4

    Re: how can i link this code to another sheet?

    thanks AB33. that works great. nice one
    Reply With QuoteRegister To Reply
  6. 11-10-2018, 11:34 AM #6
    lee111
    lee111 is offline
    Registered User
    Join Date
    11-09-2018
    Location
    london
    MS-Off Ver
    2013
    Posts
    4

    Thumbs up Re: how can i link this code to another sheet?

    "solved"solved"
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] LINK to specific sheet once logon successfully: HOW TO CODE IT?
    By poizones in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2018, 05:08 AM
  2. [SOLVED] VBA - Link in code to get data from one sheet paste in another sheet.
    By KSveigaard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2017, 11:44 AM
  3. how to click any link in a website and extracting the new link and text in our excel sheet
    By prahladsingh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2016, 11:55 AM
  4. Links to cells within worksheet carry over when sheet copied and do not link to old sheet
    By Jamidd1 in forum Excel General
    Replies: 0
    Last Post: 02-18-2016, 07:26 AM
  5. [SOLVED] How to use a hyperlink within the code, when the link is written in a sheet?
    By birbjo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2014, 05:58 PM
  6. Link cells with workbook change sheet code to link cells on six tabs in same workbook...
    By Noextent in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 02:45 PM
  7. VBA Code to link to external sheet
    By excelnovice83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2008, 03:02 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1