Filtering, selecting and pasting into new Workbook

[Mick J]

Hi, I'm not vey experienced in writing macros and
therefore, before I spend time trying to write 1, I need
to know if the following is possible.

I have a selection of Workbooks all in the same folder,
each with a number of worksheets, the structure of each
workbook/worksheet is exactly the same, the only thing
that differs is the data therin. The workbooks have a file
name containing the week number. I need to be able to
perform a search within each workbook on defined selection
criteria(ie, for each workbook between say week 1 and 10,
then possibly for all worksheets named "ALPHA 6-2" or ALL
worksheets, find customer name "????" (within column B)
and select the 3 cells to the immediate right. Copy and
paste the data in these cells to a the new workbook that I
am running the macro from within. Within each workbook
the customer being searched upon will have an undetermined
number of occurences.

Any pointers to help me do the above would be much
appreciated.

Regards

Mick.

 

[Kalle]

of course you can do that all.

read in VBA Help about:

'mithy functions/methods/properties provided here
Workbooks()

'dealing with sheets.
worksheets()

'dealing with directories
dir

you can email me under "karl thomas . schmidt at web de" (remove spaces) and
I will help you on detailed questions. A proper answer means writing the
program for you, what's not the intention of this forum.