Streamlining - Advice required please

Hi All,

I have a large spreadsheet that I am looking to streamline and remove two sheets and would like some input, but before I do it will probably be easier to explain he sheet and how it works.

The purpose of the sheet is to find a persons preferred postcode and whether they are working and match the two without duplicating names, but matching different names if more than one of the same postcode is present

So Here how it works sheet by sheet, starting with
Any data in green is user editable

DA Schedule

Is the Rota for each persons availability indicated by an X under each day of the week, Column M has a formula to list an X for each person based on todays DAY

Currently Columns I:L are blank for postcodes
This is how I think the sheet can be streamlined

Postcode By DA
Persons Name is listed in Column B, postcode in column C. the name is repeated upto four times if a person has more than one different postcode.

Column A lists whether the person is available from finding the X in DA Schedule Column M via a lookup query

Column D is related to the index
This sheet is one of the ones I would like to remove and instead of preferred postcodes on this page have them listed in DA Schedule Column I:L. But I can not seem to make this happen without stopping the integerity of Route Allocation

DA Available Coverage
Is the information of all Names with an X in Postcode by DA

Another sheet I'd like to remove - but again I cannot without stopping the integerity of Route Allocation

Route Allocation
This is the Main Page,

Column A - is the Route No (User editable)

Column B - is the postcode that copied in

Column C - Co Name (Not relevant to this task)

Column D - is the matched name from columns E:H, without duplicating the name and matching another name of the postcode is listed a second, third or fourth time

Column E:H is where it looks at DA Available coverage and over the four columns will list each person that want the postcode listed in column B

- - - - - - - - - - -
So here in lies the streamline attempt I am trying to remove sheets DA Available Coverage and Postcodes by DA to reduce the user input and make the sheet smaller. to do this I need sheet Route Allocation to find the data direct from DA Schedule and not Postcodes by DA.

In doing this I can not loose the integrity of the current formula that matches a person against each postcode without duplicating the name but finding other names if the postcode IS duplicated.

Any help will be appreciated.

Hi,

There is a contradiction here. You say:

I am trying to remove sheets ...and Postcodes by DA

but also

I need sheet Route Allocation to find the data direct from Postcode by DA.

Please clarify. You can't both remove a sheet and also use the data therein.

Please confirm which is original data and which are the results and explain with an example or two how you get from one to the other.
You also imply there are duplicate names although I can't see any. Make sure that any examples you offer cover the situations where duplicate values are a factor.

Sorry, I have rectified the typo, currently Route Allocation takes filtered data from Postcodes by DA and I am trying to streamline down so that the data is filtered from DA Schedule and not Postcodes by DA

Duplicate names as multiple rows can appear currently in Postcodes by DA, if however the data is looked at directly from DA Schedule their wont be any duplicated names instead it would be one name and 4 columns