Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Conditional Formatting

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-12 16:35, Chris Davison wrote:
    sorry, so was I...

    yours is obviously better, but the year increases when January is reached...(financial years) is this possible ?
    =TEXT(MOD(A1+2,12)+1&"/"&YEAR(TODAY())+(A1>9),"mmmm yyyy")

    [ This Message was edited by: Mark W. on 2002-05-12 16:59 ]

  2. #12
    New Member
    Join Date
    May 2002
    Location
    England
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for all your help guys. I've cracked the first problem thanks to Sam.

    It might be easier to conceptualise if I explain the second part as a kind of form/database structure. The first sheet acts as the form, initially capturing the data and also displaying any existing data with various subtotals and calculations.

    The second sheet will be hidden from view and will contain the entered data, each month having its own named table.

    Each input field on the first sheet needs to check the month and then the data can be correctly referenced to the named table on second sheet....

    How do I do that?




  3. #13
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Lee - have returned your spreadsheet with changes.

    Mark/Chris - I didn't know you could do that with a vlookup but I also liked the CHOOSE function. I keep learning every day from this site.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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