I know how to mail merge in MSWord..not a problem. What I don't know is
how to do this in Excel.

I have approx. 400 employees, I want to make a "report" for each one of
them with numerous pieces of data, calculations and charts. "Total
Compensation Information". I use to do this in Access, but my current
company HATES Access...... Any ideas would be appreciated.


--
clrauch3
------------------------------------------------------------------------
clrauch3's Profile: http://www.excelforum.com/member.php...o&userid=32631
View this thread: http://www.excelforum.com/showthread...hreadid=524408

Put your data on one sheet (sheet name "Data", and your report on another
sheet

You would then use formulas in your report like

=Indirect("Data!A" & b1)
=Sum(indirect("Data!E" & b1 & "K" & b1))

You report would have formulas to provide the information based on the
values in Data.

then when you enter a row number in b1 of the report sheet, the report would
update to refer to the data in row1.

You could then write a macro that would increment the value in B1 and print
out the sheet, or copy it to another workbook and replace the formulas with
values.

--
Regards,
Tom Ogilvy






"clrauch3" wrote:


I know how to mail merge in MSWord..not a problem. What I don't know is
how to do this in Excel.

I have approx. 400 employees, I want to make a "report" for each one of
them with numerous pieces of data, calculations and charts. "Total
Compensation Information". I use to do this in Access, but my current
company HATES Access...... Any ideas would be appreciated.


--
clrauch3
------------------------------------------------------------------------
clrauch3's Profile: http://www.excelforum.com/member.php...o&userid=32631
View this thread: http://www.excelforum.com/showthread...hreadid=524408

I will try this.


--
clrauch3
------------------------------------------------------------------------
clrauch3's Profile: http://www.excelforum.com/member.php...o&userid=32631
View this thread: http://www.excelforum.com/showthread...hreadid=524408