Another Newbie

  • Thread starter Thread starter sidheaberlin
  • Start date Start date
S

sidheaberlin

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






- Show quoted text -
Click to expand...

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!
 
Back
Top