Copying specific items from a list in Excel

  Craig.m 20:25 17 Jun 2005
Locked

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.

Craig

  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()


Cells.Select


Selection.AutoFilter


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


Cells.Select


Selection.Copy


Sheets("Tabelle2").Select


ActiveSheet.Paste


End Sub

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

Elsewhere on IDG sites

Android Oreo News: Release Date & New Features

Best Photo Editing Software for iPad

iMac 21.5-inch (2017) review

Comparatif : quelle est la meilleure batterie externe 2017 ?