HELP! - VBA to VLookup, Copy & Paste

[Joey86]

Hi Guys,

I really need help trying to get a VBA macro to do a Vlookup on another sheet then to find all the rows with that value, then copy them and paste them on another sheet, hopefully this is possible and that someone can help cause I don't have any knowledge on VBA.

Ok so I have 2 sheets, 'Daily Report' and 'Exceptions'. On the 'Daily Report' sheet when a user changes the sections in yellow shown below, I'm needing the macro to go to the 'Exceptions' page and lookup that selection criteria then copy all the values (might be more than 1 row) then it needs to come back to the 'Daily Report' sheet and paste the values down below in the green.

Daily Report Sheet

Exceptions Sheet

 

[Joey86]

Exceptions Sheet:
[TABLE="width: 938"]
<tbody>[TR]
[TD="width: 116, bgcolor: #4F81BD"]Title[/TD]
[TD="width: 83, bgcolor: #4F81BD"]Customer[/TD]
[TD="width: 75, bgcolor: #4F81BD"]Date[/TD]
[TD="width: 103, bgcolor: #4F81BD"]Client Server[/TD]
[TD="width: 88, bgcolor: #4F81BD"]Error Code[/TD]
[TD="width: 84, bgcolor: #4F81BD"]Sequence[/TD]
[TD="width: 114, bgcolor: #4F81BD"]TSD Reference[/TD]
[TD="width: 68, bgcolor: #4F81BD"]Reason[/TD]
[TD="width: 112, bgcolor: #4F81BD"]Current Status[/TD]
[TD="width: 95, bgcolor: #4F81BD"]SLA Exempt[/TD]
[/TR]
</tbody>[/TABLE]

Consolidated Daily Report:
[TABLE="width: 1249"]
<tbody>[TR]
[TD="class: xl65, width: 232"]Customer[/TD]
[TD="class: xl66, width: 161"]Date[/TD]
[TD="class: xl66, width: 161"]Client Server[/TD]
[TD="class: xl66, width: 125"]Error Code[/TD]
[TD="class: xl66, width: 140, colspan: 2"]Sequence[/TD]
[TD="class: xl66, width: 110"]TSD Reference[/TD]
[TD="class: xl66, width: 115"]Reason[/TD]
[TD="class: xl66, width: 120"]Current Status[/TD]
[TD="class: xl67, width: 85"]SLA Exempt[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Are you sure that you don't have a blank column between Sequence and TSD Reference on worksheet Consolidated Daily Report? B:K is 10 columns, but you only have 9 headings.

 

[Joey86]

Nope there's no space, see the one I initally posted was a test worksheet and I'm trying to implement that same thing into the original, I've just uploaded the real workbook to my online storage and removed the customer details here: Storage_Backup_Report_v2 - Testing.xlsm sorry for some reason this post won't let me add attachments.

 

[Andrew Poulsom]

Columns F:G (in rows 31:44) are merged. You will need to unmerge them and delete the blank column.

 

[Joey86]

That worked great, didn't know the merged field would affect it, although it copied the customer selected as well as the customer that wasn't selected, is that normal?

 

[Andrew Poulsom]

Did you specify a criteria range?

 

[Joey86]

Yep selected B11 which has Customer 1

 

[Joey86]

Sorry Andrew, fixed it, It works now. So am I to record a macro doing those steps?

 

[Andrew Poulsom]

The criteria range needs to be 2 rows. The heading Customer in the first row and the name of the customer in the second.

 

[Andrew Poulsom]

Sorry Andrew, fixed it, It works now. So am I to record a macro doing those steps?

Yes.