Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Windows XP/Excel 2003.

    I have attached the spreadsheet in question (which will actually have ten tabs similer to these)..
    What I want to do, is be able to type in the Date (manually) for each day, and have it fill in across all spreadsheets.

    I have tried it with the first 2 tabs. The first Monday works fine. (2/1) But then, using the same formula, I cannot
    get any other day to work.

    I thought it may have to do with the cells being merged and not having the same # of cells merged, but
    the Monday works and it has different cell counts.

    Is there a way to do this?

    Thank you for your help.

    Michael Abrams
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Since you have merged the cells - you only need to note the beginning cell and not through the ending merged.

    Such as =('ABC(WEEKLY)'!M1) not =('ABC(WEEKLY)'!M1:U1)

    Once you merge...n1, o1, p1 etc...do not exist.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you so much Deborah - it works perfectly now !! Much appreciated.

    Michael

Posting Permissions

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