Dear Sir,
I can develop the Macro as required. I have 10 years of working experience in Excel Macros and Formulas. Also being ex-employee of Microsoft. I am confident to deliver a quality product.
I have gone through your video and have a quite understanding for your requirements.
As I understood :
You need a macro, that will take the selected items marked as checked from the first sheet and arrange them in a sequence in the Summary tab.
Secondly, you need calculated sheet for each and every items listed there according to the formula you have locked.
And, as per understanding for the third point, that is on clicking the Custom views - 3 options will appear . i.e Budget, Full details, and Recap.
Full Details - It will provide you the full details of each and every product including Contact details and Phone Numbers.
Recap - It will show you the history of the item you selected.
Budget - I need to clear my understanding on this point.
Please message me so that we can have a conversation over it.
Looking forward to work with you.
Thanks,
Mohit