Copying specific items from a list in Excel

  Craig.m 20:25 17 Jun 05

I have a list of criteria that are to be checked off, some of the items receive a rating of 1 and I would like to automatically summarise the list onto sheet 2.

The initial list is a grouped by certain classifications and then below each of these is a list of checks. If on checking the result is a one I would like that whole row copied onto the second sheet. It is items that need to be highlighted as requiring follow on action.

I would do an auto filter if it was for me but that does not meet what I want for this situation as the user wants it all on a separate page to print out and is not really that up on Excel.

VLOOKUP seems to want the value out of a left hand column and requires them to be sorted first - this is not feasible in this case.


  Noldi 10:17 19 Jun 05

You Could try a macro something like this. This has the rated cells in Column A

Sub Sort_copy()



Selection.AutoFilter Field:=1, Criteria1:="1"





End Sub

This thread is now locked and can not be replied to.

Surface Studio vs iMac 5K comparison review: Apple and Microsoft all-in-one PCs battle it out

1995-2015: How technology has changed the world in 20 years

Social media image sizes, specs and aspect ratios: the ultimate guide

New MacBook Pro release date, price and specs | New MacBook Pro 2016 announced: Now with Touch Bar…