+ Reply to Thread
Results 1 to 2 of 2

auto copy from master sheet to sub sheet in same work book

  1. #1
    Registered User
    Join Date
    02-23-2024
    Location
    UK
    MS-Off Ver
    365
    Posts
    1

    auto copy from master sheet to sub sheet in same work book

    Good evening, new to excel and forum.

    I'm managing a spread sheet with 360ish individuals info on with C.40 data points per person. I have a master list with all the information and regularly have deploy teams from the master list (named nominal roll). In the past I've just been copy and pasting the relevant info. This takes alot of time, and is mind numbing.

    Each person is identified by a staff number in column A on the master sheet. Is there a way to input an individuals staff number in column A on one of the teams sheets and to copy all the data points from the master(its all sheets are all set up in the same same order so should copy across directly)



    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: auto copy from master sheet to sub sheet in same work book

    Little point posting a single empty worksheet


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

    You need to include several data sheets with relevant data, together with a sheet that demonstrates your expected results.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Replies: 1
    Last Post: 04-18-2016, 03:41 PM
  2. [SOLVED] copy work sheet from another work book into already exits sheet
    By Baskar5353 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2015, 03:18 AM
  3. Replies: 8
    Last Post: 05-21-2013, 10:07 AM
  4. [SOLVED] macro to auto copy data from multiple sheet to one master sheet
    By roger556 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2012, 01:52 AM
  5. Creating auto populating Summary sheet as new sheets are added to work book
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2012, 05:01 PM
  6. Macro to copy sheet from closed work book and overwrite if sheet already exists
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-23-2009, 06:36 PM
  7. [SOLVED] auto numbering an exel work book sheet everytime it opens or print
    By Rugby Al in forum Excel General
    Replies: 1
    Last Post: 07-19-2005, 02:05 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