Thread
:
Autofilter across two workbooks?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Autofilter across two workbooks?
As usual, you should copy/paste your coding efforts for comments and
suggestions.
--
Don Guillett
SalesAid Software
"CLR" wrote in message
...
Hi All..........
Might it be possible to create an "Interrogator" workbook, and an
"Interrogatee" workbook.........ie, I have a database in one workbook and
understand how to run the Autofilter by macro within it..........what I
want
to do is to set up another workbook, and have it contain a macro and the
AutoFilter Criteria to interrogate the database in the other workbook, and
report the results back to the "Interrogator" workbook. I've tried to
modify the Criteria code lines to bring in the cell values from the other
workbook, but no luck........
Please let me know if this is do-able.......
Vaya con Dios,
Chuck, CABGx3
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]