Data population on worksheets

[wmtsub]

I have a worksheet that is a master list of all my accounts. I have several aditional sheets that pull specific data ranges to them so I can send only the pertinent information to specific people. The problem I have is if a row is deleted or inserted into the main sheet it populates errors on the secondary sheets So I manually need to copy the links from row one to the end of the page every time I open them. How can I prevent this issue?

 

[Joe4]

This may not be an option for you, but this sounds more like a relational database situation, in which something like Microsoft Access handles MUCH better than Excel (because that is what Access is designed to do!).

 

[wmtsub]

yea, that wont work. I have never used Acess and there are several ppl contribuiting to the excel project. Think retraining us all is to much.
Thanks for teh resourse though.

 

[Joyner]

Without seeing your setup, I would think either Pivot Tables are the way to go for the specific information sheets, or using Power Query.