PDA

View Full Version : Help required, identify, copy and paste using VBA



WYLIE
09-03-2012, 05:03 AM
Hi

Please find attached a program I am working on, my aim is to identify the date range entered 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/05/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”)

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