Computer Guy
asked on
Some Excel Help
How can I do something like this in Excel, I can't give my project away, but will tell you it will mainly be words and not numbers, but you get the idea
Field1 Value: 4
Field2 (Dropdown with pre loaded values / words + - * /) also where would I store those values?) Value: +
Field3 Value: 4
Filed4 Value: 8 (the answer)
Then mail merge it to Word, so it would read: "4 + 4 = 8"
Field1 Value: 4
Field2 (Dropdown with pre loaded values / words + - * /) also where would I store those values?) Value: +
Field3 Value: 4
Filed4 Value: 8 (the answer)
Then mail merge it to Word, so it would read: "4 + 4 = 8"
ASKER
Cool,
1. How do I go about making the dropdown box?
2. I plan on having several dropdowns, with all different wordings (different kind every column) would it be better I just have a sheet designated for all of the content?
1. How do I go about making the dropdown box?
2. I plan on having several dropdowns, with all different wordings (different kind every column) would it be better I just have a sheet designated for all of the content?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Cool!! Last question, how do I merge that to word, so for instance, I have in my Spreadsheet a color, and where that color should go is on page 4 of a word document, is there an easy way to put a token or tag to make it populate?
Standard mail merge from this point on should work fine.
ASKER
Ok,
Just a couple of quick things:
I tried the mail merge (envelope) just to make the connection. I have a ton of fields that are populated, and they didn't show up in the dropdown of merge fields.
Also, is there way to use a few sheets with mail merge compared to 1 at a time?
Just a couple of quick things:
I tried the mail merge (envelope) just to make the connection. I have a ton of fields that are populated, and they didn't show up in the dropdown of merge fields.
Also, is there way to use a few sheets with mail merge compared to 1 at a time?
ASKER
Anything on this?
ASKER
Hello?
If you just type the answer into field 4 then a concatenate will probably do what you need.
See the attached for an example.
I've done it with the spaces you have in your example output but they aren't required really and can be turned off if you prefer. Also it's a little bit easier to build if you are using numeric values and calculating field 4.
Sample.xlsx