Spreadsheet: 377033d1423773430-several-issues-at-once-helpmeexcel
Sheet: All-Best

Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
5432-4 | v4 | 55 gallon thick | roll | 25 | 10 |  |  | 23.56 | [NAME] | Expendable | 1
4 | v3 | 55 gallon thick | roll | 25 | 10 |  |  | 34.75 | [NAME] | Expendable | 1
104 | v1 | 55 gallon thick | roll | 25 | 10 |  |  | 35 | [NAME] | Expendable | 1
tj008 | v2 | 55 gallon thick | roll | 25 | 10 |  |  | 40 | [NAME] | Expendable | 1
5432-5 | v4 | Lobby broom plastic | ea | 1 | 1 |  |  | 4.34 | Broom | Non-Expendable | 0
105 | v1 | Lobby broom plastic | ea | 1 | 1 |  |  | 5 | Broom | Non-Expendable | 0
tj010 | v2 | Lobby broom plastic | ea | 1 | 1 |  |  | 5.68 | Broom | Non-Expendable | 0
5 | v3 | Lobby broom plastic | ea | 1 | 1 |  |  | 5.68 | Broom | Non-Expendable | 0
tj005 | v2 | Cleaner 8 oz Can | can | 8 | 24 |  |  | 300 | [NAME] | Expendable | 2
101 | v1 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200 | [NAME] | Expendable | 2
5432-1 | v4 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200.18 | [NAME] | Expendable | 2
1 | v3 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200.19 | [NAME] | Expendable | 2
102 | v1 | Nitrile Glove | box | 100 | 10 |  |  | 50 | Glove | Expendable | 1
tj006 | v2 | Nitrile Glove | box | 100 | 10 |  |  | 50 | Glove | Expendable | 1
2 | v3 | Nitrile Glove | box | 100 | 10 |  |  | 50.87 | Glove | Expendable | 1
5432-2 | v4 | Nitrile Glove | box | 100 | 10 |  |  | 59.12 | Glove | Expendable | 1
5432-3 | v4 | Paper 800ft | roll | 800 | 6 |  |  | 40.59 | Towel | Expendable | 3
103 | v1 | Paper 800ft | roll | 800 | 4 |  |  | 40 | Towel | Expendable | 3
3 | v3 | Paper 800ft | roll | 800 | 4 |  |  | 40.01 | Towel | Expendable | 3
tj007 | v2 | Paper 800ft | roll | 800 | 4 |  |  | 60 | Towel | Expendable | 3
So above is a sample of a merge but it is just copy and paste….  Then filtered to "type" with a sub of "cost/ea."   So i want the above to auto update when i get a new product or prices change.  (See: vendor 3 as i put a  6th item but only 5 are on this sheet)Below here is everything broken down to the types again just copied and pasted but want that to auot update just as the above but if I get a new product say i now get nitrile gloves and vinyl gloves id have two gloves but different types and maybe sizes.  or even trash bags if i get small cans and need smaller bags ill go to my vendors and get prices for smaller bags and have a different type for them. I dont think i can auto update if i create something new below but need to know how i would continue it on as it is.  maybe I am looking at it wrong or searching under the wrong verbage.
[NAME]
Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
5432-4 | v4 | 55 gallon thick | roll | 25 | 10 |  |  | 23.56 | [NAME] | Expendable | 1
4 | v3 | 55 gallon thick | roll | 25 | 10 |  |  | 34.75 | [NAME] | Expendable | 1
104 | v1 | 55 gallon thick | roll | 25 | 10 |  |  | 35 | [NAME] | Expendable | 1
tj008 | v2 | 55 gallon thick | roll | 25 | 10 |  |  | 40 | [NAME] | Expendable | 1
Broom
Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
5432-5 | v4 | Lobby broom plastic | ea | 1 | 1 | 4.34 | 4.34 | 4.34 | Broom | Non-Expendable | 0
105 | v1 | Lobby broom plastic | ea | 1 | 1 | 5 | 5 | 5 | Broom | Non-Expendable | 0
tj010 | v2 | Lobby broom plastic | ea | 1 | 1 | 5.68 | 5.68 | 5.68 | Broom | Non-Expendable | 0
5 | v3 | Lobby broom plastic | ea | 1 | 1 | 5.68 | 5.68 | 5.68 | Broom | Non-Expendable | 0
[NAME]
Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
tj005 | v2 | Cleaner 8 oz Can | can | 8 | 24 | 1.5625 | 12.5 | 300 | [NAME] | Expendable | 2
101 | v1 | Cleaner 8 oz Can | can | 8 | 12 | 2.083333333333333 | 16.66666666666667 | 200 | [NAME] | Expendable | 2
5432-1 | v4 | Cleaner 8 oz Can | can | 8 | 12 | 2.085208333333334 | 16.68166666666667 | 200.18 | [NAME] | Expendable | 2
1 | v3 | Cleaner 8 oz Can | can | 8 | 12 | 2.0853125 | 16.6825 | 200.19 | [NAME] | Expendable | 2
Glove
Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
102 | v1 | Nitrile Glove | box | 100 | 10 | 0.05 | 5 | 50 | Glove | Expendable | 1
tj006 | v2 | Nitrile Glove | box | 100 | 10 | 0.05 | 5 | 50 | Glove | Expendable | 1
2 | v3 | Nitrile Glove | box | 100 | 10 | 0.05087 | 5.087 | 50.87 | Glove | Expendable | 1
5432-2 | v4 | Nitrile Glove | box | 100 | 10 | 0.05912 | 5.912 | 59.12 | Glove | Expendable | 1
Towel
Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
5432-3 | v4 | Paper 800ft | roll | 800 | 6 | 0.00845625 | 6.765000000000001 | 40.59 | Towel | Expendable | 3
103 | v1 | Paper 800ft | roll | 800 | 4 | 0.0125 | 10 | 40 | Towel | Expendable | 3
3 | v3 | Paper 800ft | roll | 800 | 4 | 0.012503125 | 10.0025 | 40.01 | Towel | Expendable | 3
tj007 | v2 | Paper 800ft | roll | 800 | 4 | 0.01875 | 15 | 60 | Towel | Expendable | 3