dmbodine41
New Member
- Joined
- Aug 24, 2016
- Messages
- 4
I want to create a pricing sheet that will automatically search my takeoff for duplicates then create a line item on another sheet for each different type (by size i.e. 8'-0" x 4'-0").
So here's what I want it to do:
Search all rows, columns A:W and if all cells in a specific row are an exact match to one or more rows, it will populate a line item based on cells F3 (width) & G3 (depth) (CONCATENATE(F3,"x",G3)) onto sheet 2, with the total quantity of that particular occurrence.
This would have to be written so ALL different types are accounted for - so if there are X 8'x4', that would show on sheet 2. The next line item would be X 12'x3', and so on until all instances on my take off are accounted for.
Thanks for your help!
So here's what I want it to do:
Search all rows, columns A:W and if all cells in a specific row are an exact match to one or more rows, it will populate a line item based on cells F3 (width) & G3 (depth) (CONCATENATE(F3,"x",G3)) onto sheet 2, with the total quantity of that particular occurrence.
This would have to be written so ALL different types are accounted for - so if there are X 8'x4', that would show on sheet 2. The next line item would be X 12'x3', and so on until all instances on my take off are accounted for.
Thanks for your help!