worksheets that will load data from another worksheet

foreverandcounting

New Member
Joined
Jul 10, 2007
Messages
3
I want to be able to create a data base that will be set up to automatically load a worksheet depending on how I catagorized something.
In short. I want to create a master list that will contain information in one column. another colum on that master list will contain a number that I will use to catagorize the information. then I want to set up a work sheet for each catagory. What I ultimately want is these individual worksheest to automatically load the information on to them depending on their category. So, If the phrase "it's a horse a piece" was on the master worksheet and categorized as company #1, I want it (and howerver many others are categorized as company #1) to automatically load on to the company #1 worksheet that i have set up. I know this is a complicated formula but I really need some help figuring it out. Can anyone help?
foreverandcounting@hotmail.com
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,181,658
Messages
5,931,271
Members
436,785
Latest member
KingGideon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top