I have 2 price lists, from different industries
##################
FIRST PRICE LIST:
##################
In "tab_2015" plan, I have a table starting in Line 21.
I have a picture for each item and some calc setup options between lines 1 and 14
I can change this cells:
I3,4,5,6,7 until I8
L3, L5, L7, L9
K11, K13
H11, H13
Then, I click in CONFIG BUTTON to apply the Prices Configurations and have a customized price list.
What I need you to do:
1 - In the end, I want you to vlean the layout, making the Sheet more beauty
2 - Implement search fields in Text Box near Cols B and C.
The FILTER TYPE is in the file called --> [login to view URL]
3 - Once Filtered an Item, I need to Generate an PROPOSAL.
Each Item has 1, 2 or 3 diferent price options (it depends on the color of the product).
I need to create a proposal, double clicking in the price I choose.
For Exemple: 2-click in cell E23 will
copy E23 content to E7 Cell in "BD1-Proposal" (the price I 2-clicked)
copy B23 content to C7 Cell in "BD1-Proposal"
copy C23 content to D7 Cell in "BD1-Proposal"
copy A23 picture in B7 Cell in "BD1-Proposal"
Pop-up a BOX to insert QUANTITY to A7 Cell in "BD1-Proposal"
F7 must receive a Formula =A7*E7
Then, create a total for COL F in "BD1-Proposal"
##################
SECOND PRICE LIST:
##################
It´s in "BD2" Plan, and I need to put the pictures.
It´s a need to give me a key to make it work with Images.
I need the same filter in the top of the list (one filter for each column)
and the automation to create a Proposal, as we saw.
When 2-click:
Image in Col A to Col D in "BD2-Proposal"
Copy Col C data to Col C in "BD2-Proposal"
Copy Col D data to Col E in "BD2-Proposal"
Copy Col E data to Col F in "BD2-Proposal"
Copy Col F data to Col G in "BD2-Proposal"
Copy Col G data to Col H in "BD2-Proposal"
Copy Col H data to Col I in "BD2-Proposal"
Copy Col I data to Col M in "BD2-Proposal"