Newbie can't think of search terms. IF/Then, only easier.

type88

New Member
Joined
Sep 30, 2005
Messages
33
Ok, here we go again. Time for the mrexcel forum members to help me play the hero. Alot of time usually passes between each time I need to use excel, but I am fairly quick to catch on to most tough topics.

So, here we go. Let me start with a synopsis of what I am doing. I am ultimately going to be using a word merge document which will be cut and paste into a shiny InDesign layout. Getting it ready for the merge to word is proving to be the tough point. I have the following items to juggle:

Styles: Ordered by number, they have a list of 2-10 attributes. Any given style number is unique to a particular product, regardless of what material is is made of.

Materials: Also ordered by a unique number, they have a list of 1-3 attributes.

Collection: A collection is a pairing of a material(s) and a style.

I have created 2 different masters spreadsheets, one each for the attributes given to Styles and Materials. I also have a spreadsheet for each Collection.

What I am ultimately looking to do with each Collection spreadsheet is to look at 2 columns (style and material) and then populate a range of columns with the corresponding attributes pulled from the style and material spreadsheets. Now that I type this out, it seems like it should be fairly obvious, but it is giving me grief.

So, a collection spreadsheet (the centerpoint of all of this work) has columns which include:

Style
Material
Description
misc columns for internal use
and then,
[BLANK]
[BLANK]
...
[BLANK]

It is those [BLANK] columns that I want to see change to match the attributes of the chosen style and material.

I have gotten as far as making sure that the style and material columns are a validated list (drop down) based off of the appropriate spreadsheet. Right start?

It is this Collection spreadsheet that will be merged into Word, and then sent to InDesign. This means one more question: when merging to word, since each style and material has a different number of attributes, is there a way to get word to ignore blank fields? Or would it be easier to do a find and replace to quickly get rid of all the empty places once it is in Word?

Again, thanks for your kind help.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,136,269
Messages
5,674,741
Members
419,525
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top