Across Worksheets Again

  • Thread starter Thread starter Triptanes
  • Start date Start date
T

Triptanes

How would I make my name appear in cell D9 on every worksheet in th
workbook with out manually inputting my name into every workshee
(there are 240!)
 
O nm I figured it out, select first worksheet hold down shift click last
worksheet, enter my name in D9, voila!
 
Type your name in once.
Name that cell <insert><Name><Define>
Type in name for cell (say 3 characters to keep it short)<OK>

In each of the worksheets-
Highlight the cell to contain your name
Click on "="
Highlight the cell containing your name
Hit enter

This puts in a reference to that cell.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top