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
Bookmarks