Only pull through some information

[Irwell1878]

So I have

TAB 1
This contains a load of data broken down by worker. (I don't know how many lines each worker has)

On Tab 2 I want it to pull that data through only for a certain few workers.

What would be the best method of doing this?

 

[hiker95]

Irwell1878,

So that we can get it right on the first try, can we see what your actual raw data workbook/worksheets look like, and, on another worksheet what the results manually formatted by you, should look like?

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

Try using https://app.box.com/files (Free file sharing) to post an example file.

Once you have created the uploaded file, copy the address line and then paste it back here!!

 

[Irwell1878]

Irwell1878,

So that we can get it right on the first try, can we see what your actual raw data workbook/worksheets look like, and, on another worksheet what the results manually formatted by you, should look like?

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

Try using https://app.box.com/files (Free file sharing) to post an example file.

Once you have created the uploaded file, copy the address line and then paste it back here!!

Thanks,

https://app.box.com/s/0ehq2m3lpov74imoh71fqdxym2s6ze7x

Hopefully that works.

 

[Fluff]

How about

Sub FltrSome()
   Dim ary As Variant
   
   With Sheets("Summary")
      ary = .Range("J4", .Range("J" & Rows.Count).End(xlUp))
   End With
   With Sheets("Extract")
      If .AutoFilterMode Then .AutoFilterMode = False
      .Range("A1:F1").AutoFilter 1, ary, xlFilterValues
      Intersect(.AutoFilter.Range.Offset(1), .Range("A:B,E:F")).Copy Sheets("Summary").Range("A4")
      .AutoFilterMode = False
   End With
End Sub

 

[Irwell1878]

Is there nothing I can do without using VBA?

 

[Fluff]

It can be done without VBA, but I don't know how.
Hopefully one of the formula folk will pitch in.

 

[Irwell1878]

It can be done without VBA, but I don't know how.
Hopefully one of the formula folk will pitch in.

Thank you anyway, appreciate the help.

 

[mikerickson]

AdvancedFilter has a copy to other location feature that would help. The destination sheet must be active when AdvancedFilter is activated.