+ Reply to Thread
Results 1 to 5 of 5

Date/Month/ Year ?

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    Central Missouri
    MS-Off Ver
    2007
    Posts
    5

    Date/Month/ Year ?

    I have a excel worksheet made for the wifes business and have I hope is a simple question to ask?

    I have a worksheet that has 31 tabs it represents the 31 days of the months, I have the worksheet saved for each month Jan - Dec. It is a sheet we use to keep track of her daily totals for sales at her consignment store.

    The ? and problem is,is there anyway to make it auto fill the year, month, and day thru all 31 tabs on each months document without having to manually enter them in each tab?

    Included is a pic to give you a better idea of what im saying and sorry had to cut it down to stay within size limits. I am using exel 2007. Thanks any help appreciated.

    Bryan
    Attached Images Attached Images

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Date/Month/ Year ?

    Unless she exceeds 64K (Excel 2003 & prior) or 1M Excel (2007) transactions per year, it would be much better design to put all the data on a single sheet. Then you can use all sorts of Excel tools to analyze the data by day, week, month, quarter, year, ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-20-2009
    Location
    Prineville, OR
    MS-Off Ver
    Office 2010
    Posts
    33

    Re: Date/Month/ Year ?

    Quote Originally Posted by shg View Post
    Unless she exceeds 64K (Excel 2003 & prior) or 1M Excel (2007) transactions per year, it would be much better design to put all the data on a single sheet. Then you can use all sorts of Excel tools to analyze the data by day, week, month, quarter, year, ...
    +1 on this

    I would actually leave the sheet exactly as it is and use it for the whole year. Put a filter at the top and then have a report sheet that spits out a summary of sales

    Sumifs and countifs are great tools in these instances.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Date/Month/ Year ?

    Quote Originally Posted by table83 View Post
    Sumifs and countifs are great tools in these instances.
    Even better would be a PivotTable
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    09-28-2008
    Location
    Central Missouri
    MS-Off Ver
    2007
    Posts
    5

    Re: Date/Month/ Year ?

    Im sorry but im new to excel and have multiple sheet because a few of my friends helped me get this far. My friends or I cant figure out how to do what i am asking so was wondering if someone here can point me in the right direction? I am taking online courses to try to learn excel but is going slow with full time ems jobs. Thanks to all that answered so far.

+ Reply to Thread

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