On May 28, 3:43 am, "Bob Phillips" <bob....@somewhere.com> wrote:
> If you go to the bottom right of a cell the cursor changes to a thick, black
> arrow. When this happens, you can click the mouse button and drag-and-copy
> that cell formula to other cells, and it will update as it goes.
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> <sidheaber...@comcast.net> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >I am new to using excel in a power user manner. I am trying to average
> > percentage from two cells (=B53/B54%) worksheet 1 (Day One through Day
> > 22) to a master sheet. I need the master sheet to have 22 working days
> > and the % for each day. Is there a way (Auto Fill?) to automactically
> > fill the 22 Days on the Master sheet besides entering each manuauly?
> > Thanks in advance.- Hide quoted text -
>
> - Show quoted text -
Thanks for your help Bob. I did do that and it calculates for Day 1 on
the Master. I need to do this for 22 days from 22 different sheets to
load into the Master sheet showing 22 days. Is there a simple way to
do this besides inserting the formula for each cell for the 22 days?.
Thanks again, I am new to advanced Excel and am very happy to find
such a resource of information. Thank you!
|
Similar Threads
