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

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?