Copying specific items from a list in Excel

  Craig.m 20:25 17 Jun 2005

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 2005

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.

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?