+ Reply to Thread
Results 1 to 4 of 4

Need a formula to carry over text from tab to tab

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Roswell, GA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Need a formula to carry over text from tab to tab

    I have an excel document used for our customers, where data is entered in several tabs. Many of the data elements (i.e. "Name of Reseller" row 11, "Name of EUC" row 15, etc...) are the same across all tabs. Is there a formula to utilize where data entered for these duplicate fields would transfer across all tabs of the excel document? Example would be entering "ABC company" on cell B11 and having that name copied to B11 on all other tabs. Then the name of EUC is entered on cell B15 and it's transferred as well. I've attached the sample excel for testing. Any help is much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Need a formula to carry over text from tab to tab

    .
    Paste this in the Trial Extension EUC sheet module :

    Please Login or Register  to view this content.
    You can add additional cells by enclosing them in quotes and placing a comma after, except for the last entry just before the 'close parenthesis' .

  3. #3
    Registered User
    Join Date
    04-10-2013
    Location
    Roswell, GA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Need a formula to carry over text from tab to tab

    Nevermind my previous response. This works. Thank you!
    Last edited by weaverswonders6; 05-15-2019 at 08:31 AM.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Need a formula to carry over text from tab to tab

    You are welcome. Glad to help.

+ 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. Need formula for CARRY FORWARD LEAVES
    By kreesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-14-2019, 10:28 AM
  2. [SOLVED] Sum cells that carry a formula
    By Noah101 in forum Excel General
    Replies: 6
    Last Post: 09-09-2017, 01:48 PM
  3. Formula carry over
    By Niftyix in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-22-2015, 11:49 AM
  4. [SOLVED] How to get Merge cells with wrap text to carry over with HTML to outlook
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2014, 09:35 PM
  5. formula to take text relating to cell and carry into another cell
    By tswift01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2012, 03:28 PM
  6. Formula calculate no carry over
    By pet_pas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2008, 10:43 AM
  7. how do i carry a formula
    By Xhawk57 in forum Excel General
    Replies: 6
    Last Post: 03-11-2006, 11:45 AM

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