Merge data to form w/charts HELP PLEASE

C

clrauch3

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

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

Tom Ogilvy

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.
 
Top