Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Specific Sheet in Workbook
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open workbook to specific sheet | Excel Worksheet Functions | |||
Using a Windows Shortcut to Open to Specific Sheet in Workbook | Excel Discussion (Misc queries) | |||
How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
how to open a Workbook and activate a specific sheet | Excel Programming | |||
how to open a Workbook and activate a specific sheet | Excel Programming |