Excel 2007 : Changing Data on one sheet to reflect changes on another.

[sbman2010]

I have a list of names in column A of Worksheet 1 that I would like to appear on other worksheets. This is a running data base of who is in the company and gets changed almost weekly. When a person is added or deleted, it needs to be added/deleted on the other worksheets the list is on. I have been working on this for a while and have a feeling there is a simple solution. Any help would be greatly appreciated. Thank you

[DGagnon]

is the data in a different work sheet (same file) or different workbook (different file)

either way you can reference it using something like this:

different sheet
=Sheet2!A1

different book
='C:\Public_Files\[Book2.xlsx]Sheet1'!$A$1

[sbman2010]

They are in the same file/workbook. Using =Sheet2!A1 does not work when a new line is inserted into first sheet. The second sheet remains the same because it change the cell it is referencing. I have tried using F4 to mitigate the issue but it does not help.

[DGagnon]

would a solution like this work: it is using indirect, and a row counter

[sbman2010]

No that does not work either. The problem is when I inset a new row inbetween two other rows it is not reflected on the second sheet.

[DGagnon]

ok, so you are adding rows to the first sheet, to have them appear on the second? can you provide an example?

[sbman2010]

Here is an example with an explanation in excel.

[DGagnon]

try this: it us still using indirect, but the indirect reference is on a different page. this one uses a helper column, but you could remove that and hardcode the references if you wish

[sbman2010]

that looks like it works thank you for the help

[sbman2010]

i thought that was the issue but another problem arose. I need to be able to use the"filter" feature to get high/low scores, alphabetical,etc on columns that are being referenced from sheet1. As you can see on sheet2 of the attached, the blank # came up first. I realize I can just delete the number and add one when another person is added but I will not be the one editing this workbook and do not trust in the ability of the ones doing it.

[rkalapureddy]

Hi,

Forum helped me in finding the solution of updating the 2nd sheet based on the updation of 1st sheet.

I am looking for 1 more solution: Is there any possibility of reflecting background cell color and font text into 2nd sheet?

Thanks,
Ram

[arlu1201]

Rkalapureddy,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.