Results 1 to 18 of 18

Date range look up and copy/paste coding

Threaded View

mungel Date range look up and... 02-21-2012, 04:58 PM
tigeravatar Re: Date range look up and... 02-21-2012, 07:08 PM
mungel Re: Date range look up and... 02-21-2012, 10:02 PM
mungel Re: Date range look up and... 02-22-2012, 03:02 AM
tigeravatar Re: Date range look up and... 02-22-2012, 12:16 PM
mungel Re: Date range look up and... 02-22-2012, 04:06 PM
tigeravatar Re: Date range look up and... 02-22-2012, 05:16 PM
mungel Re: Date range look up and... 02-23-2012, 04:31 AM
tigeravatar Re: Date range look up and... 02-23-2012, 11:44 AM
mungel Re: Date range look up and... 02-24-2012, 04:21 AM
tigeravatar Re: Date range look up and... 02-24-2012, 11:52 AM
mungel Re: Date range look up and... 02-24-2012, 02:41 PM
OnErrorGoto0 Re: Date range look up and... 02-24-2012, 03:45 PM
mungel Re: Date range look up and... 02-24-2012, 07:27 PM
OnErrorGoto0 Re: Date range look up and... 02-24-2012, 07:42 PM
mungel Re: Date range look up and... 02-24-2012, 09:46 PM
mungel Re: Date range look up and... 07-23-2012, 09:23 AM
mungel Re: Date range look up and... 02-27-2012, 02:40 PM
  1. #1
    Registered User
    Join Date
    05-20-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    33

    Date range look up and copy/paste coding

    Hi,

    I have a little problem with some coding that I am working on.
    I need some code I can assign to a button that, once clicked will prompt the user for a date range (dd/mm/yyyy to dd/mm/yyyy).
    The code will then use this date range to search through upwards of 200 worksheets for any matches.
    If found, it will copy certain data from those sheets, to a weekly summary sheet.

    I have the code that gets the date range in the form of variables, but I don't know enough to write the code that will search the sheets and copy the required data.

    Here is an example spreadsheet.

    Any help on this would be greatly appreciated.

    Ed

    date range look up and copy.xlsx
    Last edited by mungel; 02-27-2012 at 02:36 PM. Reason: adding prefix

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