+ Reply to Thread
Results 1 to 1 of 1

Macro to search worksheet, compile/sort array, use array to populate a second worksheet.

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy Macro to search worksheet, compile/sort array, use array to populate a second worksheet.

    Hi folks.

    I'm trying my best and failing horrifically with VB! I'm a PHP/HTML/Java man myself... and feel a bit out of my depth with this one.
    Would anyone be able to offer some wise words?

    Thanks in advance! I've attached the spreadsheet to help with my description.

    The background is this:
    I have a data set on worksheet 2. It includes the following: staff IDs; a date stamp; a time stamp.
    On worksheet 1 I have columns for the staff names with their corresponding unique staff IDs. Next, I have created 4 columns for each day in the month, to allow for upto 4 time stamps.

    To put simply, I'm trying to write a VB code to attach to a button on worksheet 1 that will take each staff ID in turn (for loop?), look for it in Worksheet 2 (find?), then place the time stamps in the correct days column (some kind of array sorting?).

    It sounds simple enough, and if it were in PHP I'd probably have it done in 30 mins or less... but my knowledge of VB is pretty poor at best.

    Regards
    Alex
    Attached Files Attached Files
    Last edited by AjStev87; 02-04-2013 at 03:28 PM. Reason: Non-Descriptive Title

+ 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