Extract data from one tab to populate table on another.

billio75

New Member
Joined
Aug 8, 2014
Messages
5
Sorry for the bad description - struggling how best to phrase it. Upshot is, I'm logging data that comes from different sites across the country, each one having it's own cost centre. So let's say cost centres 1111, 2222, 3333 and so on.

The first tab will contain all the data from all the cost centres. This is the only area which will be manually input and any cost centre could be input against at any time.

However, on another tab, I need to create a table that has a row for each cost centre that pulls all data applicable to it from the first. So if someone enters "1111" into the cost centre column on the first tab, all subsequent data put in the same row is picked up and populated in the "1111" section of the table on the second tab, and the same for cost centres 2222, 3333 and so on.

The table on the first tab will have at least 50 rows so any formula needs to be able to pick this data up from anywhere in those rows, and for multiple cost centres. I have tried to screen dump without success, hence lack of illustration.

Any help appreciated!
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

godsaaint

Active Member
Joined
Sep 16, 2016
Messages
285
Are you familiar with pivot tables? In case not, a quick google search would provide you with enough help. Unless you specifically need it done with formulas (or vba), pivot tables would be excellent for this. Only thing it doesn't refresh automatically, it would have to be refreshed to show new inputted data.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,554
Messages
5,596,814
Members
414,104
Latest member
imamalidadashzada

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