S
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?
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?