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!
Bookmarks