WYLIE
09-05-2012, 05:33 AM
Hi
Please find attached a program I am working on, my aim is to identify the date range entered from the dateFilter Userform and match the person’s name entered on the StaffFilter1 Userform to the data held in the worksheet (“RawData”) and copy the date(s), Name and comments in Column (“R”) to the Report spreadsheet where I will create a bookmark to the template I have set up.
Example
You would use the date filter and specify 28/08/2012, 30/08/2012
Use the staff filter and select the name Carl Walker
This should look in worksheet(“RawData”) identify the name date matching the above and the name Carl Walker and copy the comments in column (“R”)
Then paste this is to worksheet (“Report”) and look like the following.
28/08/2012 Carl Walker Shadowing
28/08/2012 Carl Walker 1/2 day annual leave
29/08/2012 Carl Walker Meeting
30/08/2012 Carl Walker UAT testing
Any assistance would be great from the geniuses out there in VBA land; I am new to VBA and have been trying over the past week to do this.
Thanks in advance,
[] I believe i was in breach of rules with my original post and can not edit the original title line to remove 'help required'.
Attached Files http://www.vbaexpress.com/forum/images/attach/zip.gif Warehouse.zip (http://www.vbaexpress.com/forum/attachment.php?attachmentid=8717&d=1346673756) (66.2 KB, 3 views)
Please find attached a program I am working on, my aim is to identify the date range entered from the dateFilter Userform and match the person’s name entered on the StaffFilter1 Userform to the data held in the worksheet (“RawData”) and copy the date(s), Name and comments in Column (“R”) to the Report spreadsheet where I will create a bookmark to the template I have set up.
Example
You would use the date filter and specify 28/08/2012, 30/08/2012
Use the staff filter and select the name Carl Walker
This should look in worksheet(“RawData”) identify the name date matching the above and the name Carl Walker and copy the comments in column (“R”)
Then paste this is to worksheet (“Report”) and look like the following.
28/08/2012 Carl Walker Shadowing
28/08/2012 Carl Walker 1/2 day annual leave
29/08/2012 Carl Walker Meeting
30/08/2012 Carl Walker UAT testing
Any assistance would be great from the geniuses out there in VBA land; I am new to VBA and have been trying over the past week to do this.
Thanks in advance,
[] I believe i was in breach of rules with my original post and can not edit the original title line to remove 'help required'.
Attached Files http://www.vbaexpress.com/forum/images/attach/zip.gif Warehouse.zip (http://www.vbaexpress.com/forum/attachment.php?attachmentid=8717&d=1346673756) (66.2 KB, 3 views)