deepblue74us
New Member
I have been tasked with creating a quotation tool. I am pretty sure that excel + VBA is the way to go, but do not have any experience with VBA. Hoping someone can help, here goes...
I have created a simple list of attributes in column A and in column B I have lists for selecting variable options. For example column A might have Color: and column B list might have in a drop down list: (Empty cell), Red, Blue, Green - I have successfully used the Data Validation tool to create the lists.
Once a selection is made (and only if a selection is made) I need the text to be concatenated and inserted as a new row, in a particular location, into the quote form which is on a subsequent worksheet. The goal is to be able to quickly select multiple attributes (say color, size, weight, etc) and have them listed for each item on the quote. But, if no selection is made for the attribute then it will not appear on the quote.
Example:
Sheet 1
A B
1 Color: Red
2 Size:
3 Weight: 100 lbs
Sheet 2 (maybe?? - one attribute per row)
A B
1
2
3 Item 1 Color: Red
4 Weight: 100 lbs
Sheet 2 (Ideal! - all attributed in on cell listed vertically)
A B
1
2
3 Item 1 Color: Red
Weight: 100 lbs
4
Note that since no size was selected by the user on Sheet 1 it does not appear on Sheet 2 and does not increase the number of rows.
Finally, on Sheet 2 there will be borders around the field where each Item description goes, would be important to keep the formatting on the newly inserted row.
Many thanks you's in advance for any assistance you can offer!
I have created a simple list of attributes in column A and in column B I have lists for selecting variable options. For example column A might have Color: and column B list might have in a drop down list: (Empty cell), Red, Blue, Green - I have successfully used the Data Validation tool to create the lists.
Once a selection is made (and only if a selection is made) I need the text to be concatenated and inserted as a new row, in a particular location, into the quote form which is on a subsequent worksheet. The goal is to be able to quickly select multiple attributes (say color, size, weight, etc) and have them listed for each item on the quote. But, if no selection is made for the attribute then it will not appear on the quote.
Example:
Sheet 1
A B
1 Color: Red
2 Size:
3 Weight: 100 lbs
Sheet 2 (maybe?? - one attribute per row)
A B
1
2
3 Item 1 Color: Red
4 Weight: 100 lbs
Sheet 2 (Ideal! - all attributed in on cell listed vertically)
A B
1
2
3 Item 1 Color: Red
Weight: 100 lbs
4
Note that since no size was selected by the user on Sheet 1 it does not appear on Sheet 2 and does not increase the number of rows.
Finally, on Sheet 2 there will be borders around the field where each Item description goes, would be important to keep the formatting on the newly inserted row.
Many thanks you's in advance for any assistance you can offer!