I do a lot of construction pricing work which tends to have a lot of repetitive item in the list to be priced.
I was wondering is there a way to temporarily group the items together so it easy to enter the rate and then restore the list to how it should be.
So in the enclosed example I have highlighted the dispose on site, could I for example select this cell and then have a macro to bring all the same rows together so I can enter the price and then put the rows back in the correct place. Then move on to another cell that has repeated items and do the same?
Bookmarks