Mirror data between worksheets in same workbook

Hello all.

First post, so go easy on me.

Using Office 2011 for mac, but felt this question was best suited for general.

Here is the situation.

I have a workbook with three sheets. It's a price/invoice/labor workbook.

Sheet 1 has all the data, including my cost and loss/gain fields
Sheet 2 has labor costs and the totals are linked to Sheet1
Sheet 3 is the customer copy of the first sheet. It does not include wholesale and profit info.

I'm trying to link the cells so that when info changes in Sheet 1, it's reflected, in real time on Sheet3

Right now I'm using a formula per cell ='Sheet1'!XXX (where XXX = the cell/column location, ie D15). The first column I started has this formula in every cell, about 100 in all, copied by hand and changed to reflect. It works, but it seems like there has to be an easier way to mirror or link the data. I tried pasting special with links, but continue to get errors as the link pather includes the entire file data path from the local machine.

I still have about 200 cells left and I'm dreading doing this all by hand. Also, If I add a new row to sheet1, this will not reflect in sheet 3. Any help here would be great.

Thanks and thanks for having me!

Sean

I'm not sure I understand but if the formula remains the same in all the cells once you write it you can just grab the bottom right corner of the cell and click and drag it down and it will auto populate the rest of the cells so you don't have to write it repeatedly.

Sorry, I don't mean to be vague. Here are some screen shots. I've left out sheet 2 as it really has nothing to do with the issue.

bldxls1.jpg "My Sheet"

bldxls3.jpg "Customer Sheet"

Very minor differences.

The first sheet is "my sheet" that includes wholesale costs and profit/loss

The second sheet is for the customer and it has the wholesale column and profit/loss cells deleted.

What I need is to have specific data from "My Sheet" to be mirrored to the "Customer Sheet".

for the prices column, I did it by hand, cell by cell by creating an "if reference" as mentioned above, ='Sheet1'!D5, etc. These are condensed forms pictured, but the actual sheets have 100+ cells per column.

To wrap up I either need a way to mirror the other cells- description, notes, part name with the customer sheet or an easy way to generate a sheet that leaves out the stuff for my eyes only.

Hope that helps.

Naw, I should have just uploaded it. Not really anything to hide. It's just a bare worksheet right now.

Can be found here:

Please Login or Register  to view this content.

Wrapped in code text so it's not visible to non members of the site.

Can anyone help with this?