Get data

[Decreenisi]

Here is a complicated request. I have a spreadsheet called "Rejects"
with colums called week number, date, part no, qty, fault and action.
Then I have another spreadsheet called reports, in which I want to have
a macro button called get data. In this spreadsheet Cell A1 will have a
number, i.e 4 which is the week number. So I would like the macro on
click, to look at the value in A1 then to open rejects, look for all
the A colums with "4" then copy colums A* - F*, and paste them into the
reports spreadsheet. So am I asking the impossible ?

Yours confused.

 

[Don Guillett]

Far from impossible. One way is to set up data>filter>autofilter>filter on
4>copy/paste to the next available cell in the other worksheet.