+ Reply to Thread
Results 1 to 3 of 3

code change data from sheet 1 will be automatically copied to sheet 2 with conditions

  1. 01-01-2015, 04:07 AM #1
    hacke.r
    hacke.r is offline
    Registered User
    Join Date
    12-31-2014
    Location
    HCM
    MS-Off Ver
    2007
    Posts
    8

    Red face code change data from sheet 1 will be automatically copied to sheet 2 with conditions

    Hi everyone,
    please everyone for help. I have the data E20: AB24 and E29: AG33 (yellow line) of sheet "Knowledge".
    When I import the data from sheet "Knowledge". I want to click "update button" in sheet "A" that will automatically copy and insert the line.
    Happy new year 2015 and successful everyone!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-01-2015, 07:16 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: code change data from sheet 1 will be automatically copied to sheet 2 with conditions

    Hi,

    You should avoid merged cells as much as possible. They are far too much trouble and cause all sorts of problems which we need not go into now. Suffice to say that this rather inelegant code could be reduced to a single line without the merged cells

    Please Login or Register  to view this content.
    ActiveSheet.Paste
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 01-01-2015, 09:38 PM #3
    hacke.r
    hacke.r is offline
    Registered User
    Join Date
    12-31-2014
    Location
    HCM
    MS-Off Ver
    2007
    Posts
    8

    Re: code change data from sheet 1 will be automatically copied to sheet 2 with conditions

    Thank you! Richard Buttrey
    Can you give me examples attach?
    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. Automatically execute when sheet is copied.
    By kadeo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2015, 10:16 AM
  2. Chart Sheet Source data does not change when sheets are copied to new workbook
    By Henk Stander in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2014, 03:01 AM
  3. change data automatically from one sheet to another
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2011, 03:39 PM
  4. Code not working on new sheet copied from a sheet that works
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-20-2010, 08:54 AM
  5. [SOLVED] Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2005, 10:05 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