AUTO INSERT OF DATA FROM OTHER WORKSHEETS

  • How can I have data from one worksheet or workbook automatically be inserted into another worksheet. Specifically, hours from wk 1 worksheet, wk2 worksheet etc. to go into monthly worksheet.


    thanks,
    heather

  • Hi, Heather!


    Welcome to the new board. :)


    Suppose you have worksheets named wk1 through wk52, one for each week, right?


    Suppose you have your summary sheet at the end or at the beginning of these worksheets, but not in between, for instance, wk3 and wk4...


    Then, if all those worksheets are laid out exactly the same, you can easily get a sum like this, which is an example to get the sum of all of the worksheets' cell B2:


    =SUM(wk1:wk52!B2)


    Hope this helps!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!