Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating worksheets from a database
I recently wrote code that automatically creates a new worksheet using data from an account column in the excel database worksheet. The newly created worksheet is used to store extra data about clients in the base worksheet called "Database". The database worksheet and "extra" worksheets are all contained in one workbook.xls file, making portabilty of the document easy. The database workshhet looks something like this last first address city state zip phone account By placing the cursor on a specific record and clicking on the create supplement worksheet button, the new worksheet is created and it is named using the account number from the appropriate column. It all works fine until I try to write code to automatically call up one of the created worksheets. I can not seem to get code written to call up the worksheet based on the account number from the account column. Any guru's out there with an idea? Include your phone number if you care to. I will call you on my nickel. Paul Veilleux Garland, Texas 972-278-2031:) I am legally blind. Sometimes I prefer to talk than read. -- PaulVeilleux ------------------------------------------------------------------------ PaulVeilleux's Profile: http://www.excelforum.com/member.php...o&userid=37899 View this thread: http://www.excelforum.com/showthread...hreadid=574338 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed on creating Excel database | Excel Discussion (Misc queries) | |||
creating mutiple worksheets | Excel Discussion (Misc queries) | |||
Creating multiple reports from a database | Excel Discussion (Misc queries) | |||
Links to External Database | Excel Discussion (Misc queries) | |||
PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions |