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.

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

--
Don Guillett
SalesAid Software

"Decreenisi" wrote in message
ups.com...
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.