Hi,

I've created a simple macro that accesses a .txt file, copies a range
or data, opens a new document and pastes the data.

I need to increase the functionality of this Macro as follows:

One of the copied cells in the first document contains a value that
needs to be stored into a variable (the value is always in the same
cell so this reference can be hardcoded).

When the new workbook is opened I need to retrieve the value above and
compare it to the worksheet names, once the relevant worksheet has been
found I need to open the worksheet and paste the information into the
appropriate cells.

I'm sure this can be done and am half way to doing it but can't seem to
get the syntax right. If anyone can give me some pointers I'd be very
appreciative. If at all possible could you provide comments for each
step so I can see the processes involved for future reference.
Many thanks
Dave


--
francd1
------------------------------------------------------------------------
francd1's Profile: http://www.excelforum.com/member.php...o&userid=24703
View this thread: http://www.excelforum.com/showthread...hreadid=382715