Results 1 to 1 of 1

filter access data and copy to worksheet

Threaded View

justlearning123 filter access data and copy... 06-26-2015, 06:24 PM
  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    Vermont
    MS-Off Ver
    2010
    Posts
    50

    filter access data and copy to worksheet

    i have a workbook and in my worksheet I have a command button.. when the command button is pressed there is a field to select a date and another to select a shift.. I want to have it so when I press enter on the userform I filters the data from the access file and only copy those records in my excel worksheet

    in my access file I have a table named "data1" and the first field header is named "Date" and the second is "Shift"... how could this be done? thank you
    Last edited by justlearning123; 06-26-2015 at 06:37 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel VBA Filter data and copy it to a different worksheet
    By ralucat23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2014, 05:28 PM
  2. filter data in one worksheet and copy into another
    By liv.waddington in forum Excel General
    Replies: 1
    Last Post: 10-06-2011, 02:55 PM
  3. Filter data and copy to another worksheet
    By electriceaze in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2011, 11:11 AM
  4. Macro code to copy data other worksheet taken from access
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2010, 10:50 PM
  5. Replies: 5
    Last Post: 03-18-2006, 08:45 AM

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