I am looking to take a list of companies in a column and copy each cell
into another sheet in the same file in a specific cell. After i copy
the first company into this cell, a refresh occurs automatically with
the data from that company. Once it completes, I filter the rows so
that only pertinent data is visible, then I print. I want this to occur
each time a new cell in the column copies into the active cell that
reloads the data. I do not need feed back on the automatic data data
reload. Its the loop of getting the columns of companies to run down
the list and perform all the functions described above for each company
in the list. Help.....


--
mibsaweiss
------------------------------------------------------------------------
mibsaweiss's Profile: http://www.excelforum.com/member.php...o&userid=32533
View this thread: http://www.excelforum.com/showthread...hreadid=523154