+ Reply to Thread
Results 1 to 5 of 5

VBA update master sheet from sheet 2

  1. #1
    Registered User
    Join Date
    01-17-2016
    Location
    Alaska
    MS-Off Ver
    MS Office 13
    Posts
    23

    VBA update master sheet from sheet 2

    can somebody please help with this Vba project i need to update sheet 1 with new info from sheet 2 sheet 1 will have more info in it from column R to Z that needs to stay in place when info is copied from shee2 which is linked to another file that auto updates am having troubles getting the file to attach
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: VBA update master sheet from sheet 2

    Post removed.
    Last edited by vcoolio; 09-25-2016 at 05:17 AM.

  3. #3
    Registered User
    Join Date
    01-17-2016
    Location
    Alaska
    MS-Off Ver
    MS Office 13
    Posts
    23

    Re: VBA update master sheet from sheet 2

    Post removed ?

  4. #4
    Registered User
    Join Date
    01-17-2016
    Location
    Alaska
    MS-Off Ver
    MS Office 13
    Posts
    23

    Re: VBA update master sheet from sheet 2

    if i put a formula in A1 to figure how many rows i need to add how do i tell VBA to insert rows / shift cells down at A8 by the no. in A1
    A8 will always be highest no. counting down in both these sheets ? and thanks in advance for any help anyone can give i am new to this and trying to learn sorry if i am not wording things right

  5. #5
    Registered User
    Join Date
    01-17-2016
    Location
    Alaska
    MS-Off Ver
    MS Office 13
    Posts
    23

    Re: VBA update master sheet from sheet 2

    i think i got part of it i dont understand how it works that good at this point . i found somebody elses code and modified it i have been diggin all over trying to find some info and i may have broke some rules here and else where with posting asking questions different places and sorry for this but i have not gotten any replys except for one who said post removed and i have no idea what they meant . i will post links for now on if i ask same question in other forums

    HTML Code: 
    hope i posted this right

+ 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] Multiple Sheet Names to be update in Master Sheet
    By shyampanda in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2016, 03:52 AM
  2. Adding or deleting rows in master sheet and automatically update target sheet
    By RLR31064 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2014, 01:39 PM
  3. update target sheet with rows as they are added or deleted to master sheet
    By RLR31064 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2014, 05:41 PM
  4. Master sheet updates and sub sheet automatically update as well
    By charscribbles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2014, 09:42 PM
  5. [SOLVED] Updating master sheet from weekly update sheet
    By mckennashere in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-09-2012, 07:49 PM
  6. update macro at master sheet from other sheet but no duplicate allow
    By ahbag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2012, 09:37 PM
  7. Update corresponding cells on master sheet when data entered to filtered sheet
    By Sumatied in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-18-2011, 09:50 PM

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