Hi Howard,
Am Thu, 26 Jun 2014 10:41:27 -0700 (PDT) schrieb L. Howard:
This code below does EXACTLY what I am looking for with the
exception of instead of an InputBox I want the code to go to the
column G lists on each sheet (but not sheet "Instructions") and
process the entries with a single click of the button.
please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "FindSheets"
In sheet "Instructions" you write in A1:An your IDs to search. Then
press button, The sheets indices will be written in column B
Regards
Claus B.
Claus,
Your example assumes that "Instructions" contains no instructions,
which is why I asked Howard to state where/how code gets the IDs. Also,
the sample doesn't split the results to separate columns which (I
believe) Howard wants done.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion