Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: linking sheets

  1. #1
    Guest

    Default

    sheet 1 has the 7 days of wk. sheet 2 has the whole month.how do i keep the totals from the previous wk intact when i start to work on new wk.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you really need to link Sheet1 and Sheet2. Is a little bit of a temptation to link or automate, but try to reason if there is any advantage for this. In your particular case, why not copy and paste from sheet1 to sheet2 in the relevant cells.
    I would use formulas if were for ex. twelve months in twelve sheets, and would like to input in a weekly template data that should be then placed in the right month and the relevant dates. In this case you need to have two cells on top of the weekly table with the start date and the end date of the week.

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
  •