How would I make my name appear in cell D9 on every worksheet in the workbook with out manually inputting my name into every worksheet (there are 240!).
How would I make my name appear in cell D9 on every worksheet in the workbook with out manually inputting my name into every worksheet (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
"Triptanes" <[email protected]> wrote
in message news:[email protected]...
>
> How would I make my name appear in cell D9 on every worksheet in the
> workbook with out manually inputting my name into every worksheet
> (there are 240!).
>
>
> --
> Triptanes
> ------------------------------------------------------------------------
> Triptanes's Profile:
> http://www.excelforum.com/member.php...o&userid=33849
> View this thread: http://www.excelforum.com/showthread...hreadid=536285
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks