Find matches
Find matches
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Find matches

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a workbook that tracks time punches. They are separated into 3 columns; total time in, total time on job, total time out of job code. I run a report every day that shows all punches. How easy would it be to have excel search the daily report, find a name, then look for a specific text string, and take the total number from a cell. In other words, the report would show the name, and a series of time punches. At the bottom would be a text string called series hours, then an identical number of blank cells for each name, and a total. Is it going to be very complicated to do this? Thanks.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    I cannot get a grasp on exactly what your in need of???
    You can do just about anything as far as searching is concerned with Excel. If not Excel alone, than with Visual Basic for App-lications. If you are unable to get help, E-Mail the Workbook or Sheet in question and I'll take a look at it. I'm going to be off work for quite a while and would enjoy helping if I can. tstom@hotmail.com

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I thank you for the kind offer, and will put something together that I can ship out.

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
  •  

 

 
DMCA.com