How do I call individual cell data from an Excel sheet into Powerpoint or Word?

[samccune]

Ok, I have an Excel work sheet done up to calculate discounts given to
employees based on their employer.

I now need to make a flyer in either Word or PowerPoint (or another
program if needed) but I'd like for it to pull the data from individual
cells in the Excel sheet. For instance

in the midst of the graphics and flyer text that will remain the same
for every flyer I'd like to be able to tell it to refer to Excel
document, and then pull all the information for say, the company in row
7 (since 7 is the first company listed) It would need to pull the text
(co. name) from A7, sug. retail price from D3(always D3) discount %
from B7, results from the formula written in cell C7, etc. etc. Then in
the next flyer it would be the info from row 8. (company name in A8)
retail price from D3, discount % from B8, results from formula in C8,
etc etc.

this would really help since i wouldnt have to go through and manually
change 150 flyers everytime one cell in the

I already know how to insert an excel worksheet as an object into
Powerpoint, but it displays the ENTIRE worksheet. I need to be able to
reference to an external one and only pull the information i want.

is this possible? or is there another method i should use to accomplish
this?

 

[Guest]

Sounds like a job for Mail Merge into Word. A good place to start is here:
http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

With regard to the static price reference to cell D3, you could put this
into your main document as a link by copying it from Excel, and in the Word
flyer using Edit|Paste Special to paste in a link. You also might simply find
it expedient to type it in manually before running the merge for the
remaining row data.

Good luck!