+ Reply to Thread
Results 1 to 4 of 4

Formula to move multiple cells or information across different sheets?

  1. #1
    Registered User
    Join Date
    10-07-2016
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula to move multiple cells or information across different sheets?

    Hello all -

    I have a master client list I am putting together. The Master List will have names, addresses, emails, etc. for different clients. I also want to note each client as either "A", "B", or "C" based on how much business they are doing with us. Is it possible for the info on my Master List to be distributed to separate spreadsheets for the "A", "B", and "C" groups? Since their status can change frequently, I don't want to have to copy and paste every time I update the list. The only idea I had was using IF THEN formulas, but I didn't look like that was possible to move multiple cells of information across different spreadsheets. Any ideas?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,600

    Re: Formula to move multiple cells or information across different sheets?

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-07-2016
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Formula to move multiple cells or information across different sheets?

    So the first tab has the beginning of the list. I am trying to make it so that if I put a person under the "A" category in the master list, their information would transfer over into the "A Group" tab.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,600

    Re: Formula to move multiple cells or information across different sheets?

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Macro to find and update information across multiple sheets and multiple workbooks
    By maxhecht2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2016, 11:35 AM
  2. [SOLVED] Taking information from multiple cells to return a value. Not sure witch formula to use.
    By tomigentec in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2016, 09:13 AM
  3. [SOLVED] How to auto populate cells on multiple sheets dependant on the information from another
    By MIKETALEA in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-03-2014, 05:51 PM
  4. Compare multiple data points in row _ multiple sheets _ output different information
    By floydian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 08:52 AM
  5. Replies: 2
    Last Post: 07-10-2012, 05:00 PM
  6. Replies: 8
    Last Post: 06-30-2006, 11:20 AM
  7. Replies: 0
    Last Post: 02-22-2006, 12:10 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