D
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.
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.