+ Reply to Thread
Results 1 to 4 of 4

Copying results to the master sheet from the tabs

  1. 07-08-2019, 09:47 AM #1
    Inathr
    Inathr is offline
    Registered User
    Join Date
    07-08-2019
    Location
    england
    MS-Off Ver
    microsoft office 2019
    Posts
    6

    Copying results to the master sheet from the tabs

    I have two of the same sheets which is used to track and process orders in steps. when i fill in the information on the first sheet - i want it to copy the results onto the masters . all the results will end with "Y" , "NO" OR N/A


    The formula is =IF(Scaffolding!E8="Y","NO","N/A")

    when a box is N/A this will transfer onto the masters as N/A . when the cell is NO, the masters will show N/A . as you can see its not copying right :-(

    can anyone help please ? also when their is no data in the cell box how can i keep this blank until the relevant data is inputting into the cell
    Reply With QuoteRegister To Reply
  2. 07-08-2019, 10:01 AM #2
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Copying results to the master sheet from the tabs

    Welcome to the forum.

    If all you want is a direct copy of the cell data, then just refer directly to it:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    To add a check if it is blank, use this:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
  3. 07-09-2019, 05:49 AM #3
    Inathr
    Inathr is offline
    Registered User
    Join Date
    07-08-2019
    Location
    england
    MS-Off Ver
    microsoft office 2019
    Posts
    6

    Re: Copying results to the master sheet from the tabs

    thanks :-)
    Reply With QuoteRegister To Reply
  4. 07-09-2019, 05:53 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,902

    Re: Copying results to the master sheet from the tabs

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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] Pulling data from various tabs into master sheet - Is this possible?
    By bdpate09 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2019, 10:35 PM
  2. Linking Master Tab to others tabs (sheet)
    By rr1050 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2017, 03:23 PM
  3. [SOLVED] Need help breaking master sheet into tabs
    By Longhrn77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2015, 12:10 AM
  4. Apply a macro across a hundred workbooks, and then copying the results into a master Excel
    By icomefromchaos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2014, 12:21 PM
  5. How to copy data from 4 sheet tabs to another master one?
    By Intellectual in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2012, 11:08 AM
  6. Copying sheet 1 from multiple books into tabs on master
    By jaikin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2009, 08:49 AM
  7. Linking tabs to Master sheet
    By greengrass in forum Excel General
    Replies: 0
    Last Post: 05-07-2005, 09:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1