+ Reply to Thread
Results 1 to 1 of 1

Need macro to search multiple data points from multiple entries and return single value

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    East Bangor, Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    25

    Need macro to search multiple data points from multiple entries and return single value

    I currently have a macro in the attached file that populates cell A23 in the Data Finder worksheet based on column A in the Employees worksheet and prints them out (the graphs from each valid entry Data Finder sheet). Rather than print them out, I want to place the data that would be found in column AI in the Data Finder sheet and match it up with the corresponding number in column A of the Employees sheet placing the values in columns E, F and so on....The way the file is currently setup (this is the smaller file, copied from larger ones), it calculates the data based on the 'clock number' input from the employee sheet. I'm not sure how to simplify it, but I believe a change to the macro that already functions may be the way to go. I add each month into this file so the macro may need to be tweaked so that i could add onto the data in the employee sheet (additional columns for subsequent months).

    Any suggestions?

    Thank You
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Data Points for a Single Day
    By SheilaV in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 08-20-2019, 02:51 AM
  2. Return Multiple Values For a Single search
    By Darkonius in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-19-2013, 05:21 PM
  3. Lookup then Search for text string and return multiple entries
    By tnewell2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-24-2012, 12:11 PM
  4. [SOLVED] Search Column - Find Multiple Entries - Sum Then Delete to Single Entry
    By Ledge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2006, 03:30 PM
  5. [SOLVED] Search multiple values & return single value - seperate worksheets
    By JANA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2005, 04:05 PM

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