+ Reply to Thread
Results 1 to 3 of 3

Auto filling formulas?

  1. #1
    Registered User
    Join Date
    09-29-2006
    Posts
    2

    Auto filling formulas?

    I'm making a sheet where each cell has a formula that brings a total from another sheet in the workbook like this =JAN!$AH$4 the sheet is JAN and its getting the number from cell AH4 . I need to fill this formula all the way down to like 41 cells. so the last one will be =JAN!$AH$41 however every time I select a few cells with the formula and drag it just wants to try to make the pattern with the actual numbers that come from the formula. How can I get it to drag the formula so that I don't have to enter the formula into every cell of this sheet? Cause I know if you have like 1, 2, 3, 4 and you select and drag it'll keep going in order, well I want it to do that with the formula like =JAN!$AH$4, =JAN!$AH$5, =JAN!$AH$6, and so on.

  2. #2
    Registered User
    Join Date
    09-29-2006
    Posts
    18
    try removing the $, then drag. Also you can grab the small box on a selected cell and RIGHT click and drag to get a menu.

  3. #3
    Registered User
    Join Date
    09-29-2006
    Posts
    2
    Oh the removing the $ thing worked! Thanks a ton!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1