Copy and paste through vba

[Sunil Dushila]

Hi All,

Need little help on this.

Attached is the sample excel sheet. It will help you to understand what I am trying to achieved 

In attached sheet, it has 10 sheets (sheet1, sheet2, sheet3….. so on up to sheet10) all sheets have same formatting and some data in it. There is one another sheet called ‘summary’.

Is there a VBA code can check every single sheet (sheet1, sheet2, sheet3 upto sheet10) with following criteria

If probability column = High or Very high, Impact column = Very High or High or both have same value, High and Very high and chk if status column= blank in sheet1, sheet2, sheet3…. So on sheet10) copy those rows and paste in to summary sheet.

Probability Column Impact Column Status If
High Very High Blank True
Very High High Blank True
High High Blank True
Very High Very High Blank True

If any of the criteria will true copy that whole row and paste into summary sheet.

I hope this will make sense.

Looking forward to hear from anyone 

[Sunil Dushila]

23 views to this post, but no solution so far :P

i think i am asking too much

[Sunil Dushila]

what if we drop last criteria and just run first two cafeterias Probability and Impact?

[briguin]

I'll bite..but there are multiple steps in your request.

In column S
S11 Title = "MoveToOtherSheet"
S12 put an equation =If((Countif("K12","=*High*")+Countif("L12","=*High*"))=2,1,0), copy it down to s30
Use the equation as a flag to decide if you need to copy to summary sheet
Now you need to loop through each sheet

This is only meant to give you another starting point

Please Login or Register  to view this content.