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

Starkman

Board Regular
Joined
Aug 8, 2006
Messages
88
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Starkman

Why can't you just use Word mail merge?
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
ABCDEFG
1articlenumberprice
2article4price4number4article1number1price1
3article2number2price2
4article3number3price3
5article4number4price4
6article5number5price5
7article6number6price6
8article7number7price7
9article8number8price8
10article9number9price9
11
12DATA
Blad1


kind regards,
Erik
 

Starkman

Board Regular
Joined
Aug 8, 2006
Messages
88
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
 

Forum statistics

Threads
1,136,702
Messages
5,677,290
Members
419,684
Latest member
BOB101

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