Im trying to create a quote builder using formulas or VBA, my workbook has 3 sheets:
Sheet 1 - Label Quote Builder
Sheet 2- Quote
Sheet 3 - Data
When Cell I6 in Label Quote builder is selected, is there a way that Sheet2 - Quote, will look at quantity and prices from the table in sheet 3 relating to Cell I6 in sheet 1?
I've tried different formulas with v lookup,match,index etc,. I can't find anything that will do what I want. (i might not be programming it right!)
I was thinking that maybe VBA is the way forward, but i'm new to creating VBA's.
I have uploaded my spreadsheet.
Bookmarks