Yes... it is a long way down to row 1776... A few hundred would have been OK, but.
I accidentally deleted your price per kg calculations.
The two additional dropdowns haven't been constructed yet (no time now - pub time), but the INDIRECT/INDEX/MATCH combination is looking for the correct sheet, by main category, by subcategory and by city.
It's an ARRAY formula that can be copied across and down as needed. is this what you had in mind?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
It works amazing now!Originally Posted by Glenn Kennedy
added additional information in the sheets (over 4 millions cells now, almost 85 MB) and it works amazing, cut my work load with hours!
There is three sheets with a variation (a shift in the coloums) where I will need to jump rows. Guess the array formula will fix this also, just need to delete some of the merged cells. As u mentioned before merged cells are not nice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks