I need to copy a row of formulas in a worksheet (Report), but only if there
is a value in another worksheet (Personnel). Right now I'm stuck at having
500 rows containing formulas like the following:

Report Last Name: 'Report'!F2 = IF('Personnel'!$A2<"",'Personnel'!$A2,"")

and so on for first name (B2), Bldg. (C2), Room (D2), etc.

Worksheet: "Personnel" contains
A:A = Last Name
B:B = First Name
C:C = Bldg. (and so on)

Worksheet: "Report" contains
F2 = Last Name
G2 = First Name
H2 = Bldg. (and so on)

(plus 20 other columns of data, many of which have data validation drop-down
menus)

I also need to be able to add, delete, copy, paste records in 'Report'
(after all the Personnel data is there... I'm thinking this can get resolved
by coverting the formulas into values)

Once the 'Report' data is finished, the information must then go to
'ReportMerge' (a sorted, locked worksheet that Word will use for merge
reports); this worksheet also draws data in from yet another worksheet that
is only needed for the Word merge (and therefore not needed on 'Personnel'
and 'Report')

I've tried several solutions in this DG, but have not been able to get them
to work.

Suzanne