+ Reply to Thread
Results 1 to 7 of 7

Saving data as a sheet to be searched for at a later date.

  1. #1
    Registered User
    Join Date
    12-29-2009
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2003
    Posts
    25

    Saving data as a sheet to be searched for at a later date.

    I'm trying to find a way to save the data I enter into sheet 1 so that later on, when I have a request for a job similar to one I've already recorded, I can search for it to come up with the time it took to do the job. I'm thinking that maybe each copy of sheet 2 could be filed to a seperate sheet which could be referenced in the data list I build on sheet 1.I'm trying to ultimately arrive at a spreadsheet that I can enter my work times into, then file them away for future reference that I can search for by whatever I happen to remember about that job. On some, it may be an approximate date (I need to do something about that odd-looking date in B2 on Sheet 2), on others the customer's name, on others it may be the job category.
    Thanks for your help,
    Rich

  2. #2
    GMANFG
    Guest

    Re: Saving data as a sheet to be searched for at a later date.

    Look like you forgot to include your attachement. Go to you post, scroll to bottom and click on Manage Attachment.

  3. #3
    Registered User
    Join Date
    12-29-2009
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Saving data as a sheet to be searched for at a later date.

    Sorry, I had it on a different computer.
    Rich
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-11-2010
    Location
    Greensburg, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Saving data as a sheet to be searched for at a later date.

    I think the simplest solution would be to input all data related to one job horizontally and then use the SORT option to find the information you wanted. Also, I'm sure you'll be doing more than one of the same type of job, like "Side curtain replace windows (4)". But as you get better, the time it takes will slowly become faster. So by using the SORT option you'll be able to see the range of times it took you to do the job. Best of luck.

  5. #5
    Registered User
    Join Date
    12-29-2009
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Saving data as a sheet to be searched for at a later date.

    Yes, that's my intention, but I'm trying to find a way to save each sheet (sheet2) with time records as they are so that when I sort and find the job, I can go to that saved sheet to see not only the total time, but each entered time so I can know how long each phase took to do. This is what i now do on paper. Each page gets saved so I can refer back to it later. Any ideas?
    Thanks,
    Rich

  6. #6
    Registered User
    Join Date
    01-11-2010
    Location
    Greensburg, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Saving data as a sheet to be searched for at a later date.

    Hi Rich, I think I'm not communicating this well.

    I think trying to save multiple sheets will become super time consuming versus just entering all job data including each "entered time" horizontally into one spreadsheet. If you want to see each job on its own separate sheet just for visuallization, then I would suggest setting up a prepopulated excel sheet that populates cells based on the job you enter. For an example of this, I created a tutorial for a prepulated invoice...http://blog.brackwho.com/2010/01/tut...lating-or.html. How this basically works is I tell the excel sheet which invoice I want to print by putting an "x" in a box. That "x" tells the prepulated sheet to fill with certain cell information.

    If this is seems like something your after, I'd be glad to help further. As to your "go find each sheet" desire, I'm not sure how to accomplish that. Best of luck.

  7. #7
    Registered User
    Join Date
    12-29-2009
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Saving data as a sheet to be searched for at a later date.

    Thanks, I need to sit down with that and see if I can incorporate it into what I have now. I can see what your saying about having a sheet for each record. As long as I can pull up the times that I entered for each job I did, it doesn't matter how it's stored.
    Rich

+ 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