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!
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!