Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Added line in spreadsheet (2003)

    A follow on to the Macro problem I had with a spreadsheet <post#=574646>post 574646</post#> I have another totally different problem, which I need advice on. The spreadsheet contains 3 work sheets (see attached). Statistics total has the fixed formulas in it. Week1 and Week2 are imported from an Access report. Fortnightly Week 1 is deleted, and Week2 is renamed Week1. A new sheet is imported into the spreadsheet, and this becomes the new Week2. The Macro is then run to do all the calculations on Week 1 and Week 2, to allow Statistic Totals to do its calculations.

    The problem I have is that I don't run the spreadsheet, or the report that creates the stats. As you will see, there are more names on Week 2 than Week 1, or the Statistics Total. This is because of new starters. The same goes for ones that leave. I only get informed about this when the user runs the Macro and it doesn't work. So I have to get the spreadsheet and re-create the Macro. Any suggestions to make this idiot proof would be welcome.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Added line in spreadsheet (2003)

    It would seem to be easier to do this using a set of queries in Access.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Added line in spreadsheet (2003)

    Seems complicated to me. I'll have to mess with the database again. The stats are already done, it's the comparison from one week to the next I'll have to work on.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Added line in spreadsheet (2003)

    You might use MATCH and INDEX to look up data for the corresponding person.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Added line in spreadsheet (2003)

    Thanks Hans. Will the Microsoft help give me sufficient knowledge on this?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Added line in spreadsheet (2003)

    The help file does contain an explanation of MATCH and INDEX, with examples, but whether it is sufficient depends on you. There are also numerous examples in this forum.

Posting Permissions

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