Data population on worksheets

wmtsub

Active Member
Joined
Jun 20, 2018
Messages
322
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
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

Active Member
Joined
Jun 20, 2018
Messages
322
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

Well-known Member
Joined
Nov 15, 2005
Messages
1,202
Without seeing your setup, I would think either Pivot Tables are the way to go for the specific information sheets, or using Power Query.
 

Forum statistics

Threads
1,085,586
Messages
5,384,598
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top