Dear Experts,
Looking for some help to copy and paste in 3 steps using a code. Workbook has 2 sheets
Sheet 1 name is Summary and
Sheet 2 name is Data (Data is in column A : J aprox 700 rows)
In summary (sheet 1) I have a dropdown list in B1
The code should be able to automate following three steps when value is changed in Sheet 1 (Summary) using the drop down in B1:
1. Go to worksheet Data range a1 & select current region and apply auto filter where column G is not equal to summary sheet b1 and not equal to “XXX” then copy the visible cells and paste it in Summary sheet starting from Range A3

2. Go back to data sheet clear filter and then again apply filter in column G this time it should select Summary sheet B1 & “XXX” only and filter in column I also selecting Summary sheet B1 and “XXX” then select current region and copy visible cells go back to summary sheet and paste it under the last used cell

3. Go back to data sheet clear filter and again apply filter on column G = “XXX” and column I <> summary sheet B1. Copy the visible cells go to summary sheet last used cell and paste it under it.

Best Regards/VKS