General discussion

  • Creator
    Topic
  • #2210851

    Excel Help – copy formula but incrementing column rather than row

    Locked

    by alainforbes ·

    I have a standard spreadsheet with 3 tabs which is to be used by several users (not particularly IT savvy ??? so needs to be simple & automatic as possible) as a template to record weekly timesheets.

    The 1st tab is where they record hours against each staff/client spent as follows

    Client1 Client2 Cleint3 Cleint4???. Total
    Staff1
    Staff2
    Staff3
    Etc
    Total

    Tab2 summaries the each staff member and their total hours spent ??? easy =A2 & total say J2
    Can then copy down using Fill handle ??? easy

    Tab3 summarises by Client so want it to look like

    Client1 Total_hrs-Cleint1
    Cleint2 Total_hrs_Client2

    So 1st row is B1, then say B10
    Next row needs to be C1 & C10
    Then D1, D10

    How can I achieve this?? Any help would be much appreciated!

    Many thanks in anticipation!

    Alain

All Comments