Results 1 to 1 of 1

Keep monthly running tally from a daily sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2007
    Posts
    1

    Keep monthly running tally from a daily sheet

    Here is what I have to do.

    I have a sheet that gets filled out daily, printed and sent in with paperwork. I have another sheet that gets turned in monthly that has daily totals.

    What I would like to do is this.

    When I change the date of the daily form and input my totals, those totals will copy over to the monthly form and stay put when the date gets changed to something else.

    I tried using an IF formula that checked if the date on the monthly form matched the date on the daily form. If so, it copied the correct info over. Problem is, when the date changes, the IF statement no longer holds true and wipes field.

    I have attached the forms for your viewing pleasure.

    Just FYI, I'm kind of new to Excel, but have a good understanding of logic flow. I just can't seem to figure this one out.

    Sam
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1