+ Reply to Thread
Results 1 to 2 of 2

updating multiple tabs with a workbook

  1. #1
    Registered User
    Join Date
    05-20-2016
    Location
    London, england
    MS-Off Ver
    2007
    Posts
    1

    updating multiple tabs with a workbook

    Hi there

    We run a master spreadsheet tab containing details of a number of events that we produce, I then use some of the same information on two different tabs within the same workbook with more specific event and compliance information.

    The master sheet runs in ascending date order, newly confirmed events are added into the time line by inserting a new row then the appropriate info, I'm looking for a macro/vba to enable me to up date the update the additional tabs following an update to the master while maintaining the timeline...

    Any help would be greatly appreciated.

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: updating multiple tabs with a workbook

    It seems you would have to have a macro to determine what is new, then have that new data jammed into the other sheets. OR even easier, you can clear the other sheets each time you run the macro, and have the macro bring over all relevant data, assuming history never changes.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-06-2015, 07:42 AM
  2. Linking One Workbook with Multiple Tabs to Master Workbook Formula
    By Scholzie220 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2015, 09:13 AM
  3. Pulling data from one workbook with multiple tabs to another workbook.
    By manzier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2014, 03:41 PM
  4. [SOLVED] Importing Data from Multiple Excel Forms into Multiple Tabs in New Workbook
    By hollybo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2014, 03:42 PM
  5. Replies: 1
    Last Post: 11-30-2013, 08:18 PM
  6. [SOLVED] Extract data from a workbook with multiple tabs, into a workbook with corresponding tabs
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 11:54 AM
  7. Replies: 4
    Last Post: 05-20-2010, 07:52 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