software

Here is a complicated request. I have a spreadsheet called quot;Rejectsquot;
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 quot;4quot; 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 datagt;filtergt;autofiltergt;filter on
4gt;copy/paste to the next available cell in the other worksheet.

--
Don Guillett
SalesAid Software

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