Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

Thanks for the very clear response. Unfortunately, that is the part that I
already do understand. What I am having a problem with is ....here's the
senario....
"A" has 10 rows and 10 columns of data.
After linking formulas, "B" is an exact duplicate of "A".
I acquire a new client and need to list her data in row 5 of "A", which will
mean that "A" now has 11 rows of data....but "B" still only has 10 rows of
data.

I am trying to figure out a way to make "B" automatically insert a new row 5
and link the newly input data from "A". Sorry about not being clearer in my
original question, BUT thanks a bunch for your response. This is the first
time I have ever posted a question.

"pameluh" wrote:

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

Oh, in that case, just copy the links down to say, row 50, or however far
down you think you'll need.

"giterdun" wrote:

Thanks for the very clear response. Unfortunately, that is the part that I
already do understand. What I am having a problem with is ....here's the
senario....
"A" has 10 rows and 10 columns of data.
After linking formulas, "B" is an exact duplicate of "A".
I acquire a new client and need to list her data in row 5 of "A", which will
mean that "A" now has 11 rows of data....but "B" still only has 10 rows of
data.

I am trying to figure out a way to make "B" automatically insert a new row 5
and link the newly input data from "A". Sorry about not being clearer in my
original question, BUT thanks a bunch for your response. This is the first
time I have ever posted a question.

"pameluh" wrote:

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

You are the greatest thing since sliced bread! But if I do that I wind up
with a lot of cells, i.e., rows 12 - 50 with "0's" in them. Is there any way
to hide them so the spreadsheet looks cleaner? Thanks!

"pameluh" wrote:

Oh, in that case, just copy the links down to say, row 50, or however far
down you think you'll need.

"giterdun" wrote:

Thanks for the very clear response. Unfortunately, that is the part that I
already do understand. What I am having a problem with is ....here's the
senario....
"A" has 10 rows and 10 columns of data.
After linking formulas, "B" is an exact duplicate of "A".
I acquire a new client and need to list her data in row 5 of "A", which will
mean that "A" now has 11 rows of data....but "B" still only has 10 rows of
data.

I am trying to figure out a way to make "B" automatically insert a new row 5
and link the newly input data from "A". Sorry about not being clearer in my
original question, BUT thanks a bunch for your response. This is the first
time I have ever posted a question.

"pameluh" wrote:

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

Hide all zero values on a worksheet

On the Tools menu, click Options, and then click the View tab.

To display zero values as blank cells, clear the check box.

*mUah!*

"giterdun" wrote:

You are the greatest thing since sliced bread! But if I do that I wind up
with a lot of cells, i.e., rows 12 - 50 with "0's" in them. Is there any way
to hide them so the spreadsheet looks cleaner? Thanks!

"pameluh" wrote:

Oh, in that case, just copy the links down to say, row 50, or however far
down you think you'll need.

"giterdun" wrote:

Thanks for the very clear response. Unfortunately, that is the part that I
already do understand. What I am having a problem with is ....here's the
senario....
"A" has 10 rows and 10 columns of data.
After linking formulas, "B" is an exact duplicate of "A".
I acquire a new client and need to list her data in row 5 of "A", which will
mean that "A" now has 11 rows of data....but "B" still only has 10 rows of
data.

I am trying to figure out a way to make "B" automatically insert a new row 5
and link the newly input data from "A". Sorry about not being clearer in my
original question, BUT thanks a bunch for your response. This is the first
time I have ever posted a question.

"pameluh" wrote:

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

Hey, got rid of the zeros, thanks! But my original problem is still there.
I tried lyour suggestion of copying the links down through row 50 on "B".
Then I went back to "A" and inserted a row in the middle of the list, which
became my new row 6 in my now new set of 11 rows. I accessed "B" hoping to
see that the new client data from the new row 6 now appeared in "B"....it did
not. Any more suggestions, thanks.

"pameluh" wrote:

Oh, in that case, just copy the links down to say, row 50, or however far
down you think you'll need.

"giterdun" wrote:

Thanks for the very clear response. Unfortunately, that is the part that I
already do understand. What I am having a problem with is ....here's the
senario....
"A" has 10 rows and 10 columns of data.
After linking formulas, "B" is an exact duplicate of "A".
I acquire a new client and need to list her data in row 5 of "A", which will
mean that "A" now has 11 rows of data....but "B" still only has 10 rows of
data.

I am trying to figure out a way to make "B" automatically insert a new row 5
and link the newly input data from "A". Sorry about not being clearer in my
original question, BUT thanks a bunch for your response. This is the first
time I have ever posted a question.

"pameluh" wrote:

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".

Yes. When you open up spreadsheet B and get a message asking you if you want
to update the spreadsheet, click yes. :)

And in response to your earlier post, you're right... you could make life a
lot easier by just making and saving changes to spreadsheet A and then doing
a "save as" and save it as spreadsheet B. Then delete the info you don't
want your customers to see and be done with it.

"giterdun" wrote:

Hey, got rid of the zeros, thanks! But my original problem is still there.
I tried lyour suggestion of copying the links down through row 50 on "B".
Then I went back to "A" and inserted a row in the middle of the list, which
became my new row 6 in my now new set of 11 rows. I accessed "B" hoping to
see that the new client data from the new row 6 now appeared in "B"....it did
not. Any more suggestions, thanks.

"pameluh" wrote:

Oh, in that case, just copy the links down to say, row 50, or however far
down you think you'll need.

"giterdun" wrote:

Thanks for the very clear response. Unfortunately, that is the part that I
already do understand. What I am having a problem with is ....here's the
senario....
"A" has 10 rows and 10 columns of data.
After linking formulas, "B" is an exact duplicate of "A".
I acquire a new client and need to list her data in row 5 of "A", which will
mean that "A" now has 11 rows of data....but "B" still only has 10 rows of
data.

I am trying to figure out a way to make "B" automatically insert a new row 5
and link the newly input data from "A". Sorry about not being clearer in my
original question, BUT thanks a bunch for your response. This is the first
time I have ever posted a question.

"pameluh" wrote:

Insert links between A and B.

Start in spreadsheet B, select a cell that has a partner in A (example: A1)

In that cell type =

Open up spreadsheet A, select the partner cell in A (for this example: A1)

Press enter

Voila! You've just created a link between spreadsheet A and spreadsheet B.

To test this, go to spreadsheet A and type something in A1, like 123456.
Then open up spreadsheet B and look at A1, it should say 123456.

The formula you created in A1 can be copied down columns and across rows
until B looks exactly like A. Then just delete the links in B that you don't
want the customers to see.

Hope this is helpful!

Pamela :)

"giterdun" wrote:

Worksheet "A" is a master inventory list for company's eyes only. Worksheet
"B" is a distribution list for public view and it is all driven by formulas
from "A"
so that I do not have to reinput the same data twice. "B" will have certain
columns and sheets hidden and is password protected. From time to time I
must enhance "A" by inserting a row within the list and adding a new client's
data. I want this row insertion and new data to also copy over to "B"
automatically. Bottom line I need any changes made to "A" to automatically
copy over into "B". Original data is easy to do, but I cannot figure out how
to make adding/deleting a column or row and the new data that is input
automatically copy over into "B".