Macro to extract data when certain criteria met

[chriscusick]

Hi,

I am looking for some help in extracting data from multiple workbooks into a new one.

What i need is to extract the "name of staff" as well as Name, address, postcode, Price 1, Price 2 from multiple books into a new workbook, if the date column has "tba" in it. The fields are all in the same place across the 5 books and I have added an example sheet for people to look at.

I hope someone can help me and thank you in advance

[arlu1201]

Should the name of staff appear for every row containing the data?

[tbar05]

hi chris,

try something like:

Please Login or Register  to view this content.

[chriscusick]

Should the name of staff appear for every row containing the data?

Ideally I would like it to appear as a sort of header, so that you can see which rows belong to whom, but either way is fine to be honest

[arlu1201]

How would it appear as a header? Would there be multiple headers in your output sheet instead of the 1 header at the top?

[chriscusick]

hi chris,

try something like:

Please Login or Register  to view this content.

Thanks Tbar, quick question though, as my knowledge of macros is somewhat pitiful.

Does this macro pull the data from more than one workbook and paste the information to a new one?

---------- Post added at 07:41 AM ---------- Previous post was at 07:40 AM ----------

[/COLOR]

How would it appear as a header? Would there be multiple headers in your output sheet instead of the 1 header at the top?

Ideally it would be nice for it to appear something similar to:

NAME 1
xxxxx xxxxxx xxxxx

NAME 2
yyyyy yyyyy yyyyy

NAME 3
zzzzzz zzzzzz zzzzz

(apologies for the terrible "example" layout above)

though, as I said, if it is easier to just have another field in the row that has the name there for each line, then so be it.

[tbar05]

hey chris, the macro only pulls data from active sheet in the open workbook and puts it into sheet2 of that workbook

[chriscusick]

Hi Tbar05,

I do apologise I have just read the original posting I put and realised my own error....

I need the macro to pull data from multiple workbooks and enter it into a new one. I really am sorry about the misinformation. Is it possible to adapt your macro to do this?

[tbar05]

is there multiple sheets in the workbooks you want to pull data from?

are these other worksheets open, or do you want a macro to open/get data/close the other workbooks (and are the saved in the same location)