Oh, PLEASE help...how to merge data into Excel

[Starkman]

Ok, here's what I have going on...

This all started because I could not get a Wordperfect doc, which contains a table and simple formulas, to convert to a Word 2000 doc without loosing the formulas. So I decided to go the Excel route. (And what the hek is it with Word that it doesn't like relative formulas in tables? For pete's sake!)

I have managed to convert into Excel the Corel Spreadsheet that was used for merging the old (and obsolete!) WordPerfect doc. It's a list of 70 people's names and contact information. Further, I have managed to create a billing form in Excel into which I want to merge the data for those 70 people.

This is just like doing a mail merge; merging data from Excel into a Word doc, but in this case I'm wanting to take data from Excel and merge it into an Excel form. I don't know how to create "merge fields" (or whatever it takes) in Excel in order to do this.

My workbook for all this is composed of the billing form (one worksheet) and the data on the 70 people (the other worksheet). Is there a way to do this kind of merge, preferably without VBA (about which I know nothing)? Oh, and obviously, I'll be printing out this billing form for all 70 people to receive.

Thanks very, very much,

Starkman

 

[Norie]

Starkman

Why can't you just use Word mail merge?

 

[erik.van.geit]

Hi,

do I understand correctly:
you have some fields which need to get items from a list
when changing the name, all fields should change accordingly ?

you could use VLOOKUP or INDEX combined with MATCH for this

1. you can do a search on this board (see link on top of this page)
examples
http://www.mrexcel.com/board2/viewtopic.php?t=175120&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=174839&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=170977&highlight=vlookup
http://www.mrexcel.com/board2/viewtopic.php?t=170377&highlight=vlookup
2. you can type in any cell the equal sign: the "name box" (where normally the cellreference is displayed) will turn in a dropdown-menu where you will get some choises ...
3. you can click the helpmenu and type VLOOKUP, there are some good examples in the helpfiles

you may ask your specific question here if you want ...
what would you like to do specifically ?

Map3
	A	B	C	D	E	F	G
1					article	number	price
2	article4	price4	number4		article1	number1	price1
3					article2	number2	price2
4					article3	number3	price3
5					article4	number4	price4
6					article5	number5	price5
7					article6	number6	price6
8					article7	number7	price7
9					article8	number8	price8
10					article9	number9	price9
11
12					DATA
Blad1

kind regards,
Erik

 

[Starkman]

Starkman

Why can't you just use Word mail merge?

Actually, I have a Word doc ready to go. It has the formulas and all, but the problem is that I don't like having to press Ctrl+A and then press F9 to recalculate the formula results every single time I change one of the figures in the table. (Why on earth WordPerfect calculates formulas in tables on the fly and Word doesn't is beyong me.)

Otherwise, I don't think there'd be a problem.

Starkman