I was looking to do the following.

I have a workbook. 1 sheet

Column A is for Name

Column B is for Amount

Column C is for Account Type


The following is what I am trying to do.
By running a macro, I would like like excel to see if the specific
Account Type (Column C from Wrk book 1) Workbook is created (The
workbook would be in the same directory if it is created). If the
workbook exists, then go to a specific sheet - all sheets are named
after the Name in column a or workbook 1. Then put the amount in the
exact Name sheet in Cell A4.

Any help would be appreciated.
Thanks in advance

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=382104