+ Reply to Thread
Results 1 to 3 of 3

getting data from one sheet to show up in other sheets

  1. #1
    Registered User
    Join Date
    06-23-2008
    Posts
    2

    getting data from one sheet to show up in other sheets

    I have spent the last two hours researching this and I can't seem to figure it out.

    I have a workbook with three sheets... There are several rows and columns in each sheet that contain the same amount.. For example, on sheet 1, I have a column for "Clients," a column for "Payment 1 amount," and column for "Sales tax," and so on, with each row having information for each client. On sheet two, I also have columns for clients, payment 1 amount, sales tax, etc, as well as rows for the same clients, and I need the same information to be entered into those cells. Up until now, I have just been copy/pasting the information across the sheets. However, I would like to find a way for Sheet 2 and Sheet 3 to reference the information on Sheet 1, so that when I enter the data into Sheet 1, it automatically shows up on Sheet 2 and Sheet 3. What is the easiest way to do this?

    Bonus question: If I have formulas in a cell (i.e., the cells in the Sales Tax column are actually =C3*.0825 and so on), and I want the end value of that cell to show up on the other sheets, not the formula, is there anything extra I need to do?

    Thanks in advance for your help, if I can get this working, it will save me so much time!

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Welcome to Excel Forum!, the general standard for showing the contents of a cell on another sheet is =Sheet1!A1 if you entered this in sheet 2 it will show the contents of sheet1 cell A1, so if you entered it in cell A1 then dragged (copied) for your range of cells the A1 would change accordingly. As for the showing a figure without using formula then you would have to use VBA to make this happen.
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    06-23-2008
    Posts
    2
    Edit: nevermind, I figured out my second problem.. I needed to change "Sheet 1" to the name of the sheet.. duh!

    THANK YOU SO MUCH!!!!
    Last edited by stacyreeves; 06-23-2008 at 12:42 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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