Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Database!
Thanks Tom,
It works! You wanted me to send you the original msg, which i am sending to you! If possible, help me out on the remaining queries( 3 & 4). Also, i hv a question for all, is it possible to create a database in Excel using a data-entery worksheet, so that whatever is entered on the worksheet, gets stored on a different workbook's worksheet which will be the Database! I want to integrate the auto-generation of a unique no & also see to it that sheet will validate that no duplicate entries r entered. Actually, i hv made a Reimbursement Voucher which every Employee who wants to get reimbursed for No-Transport-provided for a particular day(i.e Pickup/Drop to/from Company). They just hv to fill the (read-only) Voucher which will be located in a particular folder on the network & then enter the dates to be reimbursed along with a valid reason, e.g not Picked/Dropped up, had to catch a Cab, Train, Auto etc & Amount. The question is, whenever an employee fills in a Reimbursement voucher, i want the Reimbursement Voucher to generate a unique Code (e.g RV00001) in a cell labelled the RV# on the Reimbursement Voucher, so that employee can do a Save-As filename & then also print-it. Now whatever he entered will be automatically entered on a diff wrokbook's worksheet called say the 'Database'. Is it Possible, bcos the file stored on the network will be a read-only file? Can i send you the file for your perusal? Pls reply so that i can get this done at the earliest. Your help will really be appreciated. Thanks & best regards, Eijaz ================================================== ========================== Dear all, i hv few questions: 1) How to write a procedure to automatically create a no of sheets as the no of days in a month with the sheet names as 01, 02, 03...31...etc. 2) how to write a procedure which will automatically create a sheet each day, by concatenating the current date & a text such as "Comments", for the Sheetname. e.g the Sheet names would be created as " Comments-10292003", "Comments 10302003" etc for each current day....? 3) How to check whether a sheet has already been created & not create it by the same name again, but just append data to it. tried Worksheet.Add method, but it only adds addnl worksheets, not append to existing one..... 4) Made a Data Entry Template for transport reimbursement (voucher), which is shared over a network. Is it possible to generate a Random Aplhanumeric# for every user who fills in his reimbursement details( the details will automatically be stored on a seperate excel workbook with the unique aplhanumeric no along with the date when it was filled. Can anybody help? any help would be really appreciated. Thank & best rgds, Eijaz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Database!
I gave you the information you need for Questions 1 to 3.
-- Regards, Tom Ogilvy eijaz wrote in message ... Thanks Tom, It works! You wanted me to send you the original msg, which i am sending to you! If possible, help me out on the remaining queries( 3 & 4). Also, i hv a question for all, is it possible to create a database in Excel using a data-entery worksheet, so that whatever is entered on the worksheet, gets stored on a different workbook's worksheet which will be the Database! I want to integrate the auto-generation of a unique no & also see to it that sheet will validate that no duplicate entries r entered. Actually, i hv made a Reimbursement Voucher which every Employee who wants to get reimbursed for No-Transport-provided for a particular day(i.e Pickup/Drop to/from Company). They just hv to fill the (read-only) Voucher which will be located in a particular folder on the network & then enter the dates to be reimbursed along with a valid reason, e.g not Picked/Dropped up, had to catch a Cab, Train, Auto etc & Amount. The question is, whenever an employee fills in a Reimbursement voucher, i want the Reimbursement Voucher to generate a unique Code (e.g RV00001) in a cell labelled the RV# on the Reimbursement Voucher, so that employee can do a Save-As filename & then also print-it. Now whatever he entered will be automatically entered on a diff wrokbook's worksheet called say the 'Database'. Is it Possible, bcos the file stored on the network will be a read-only file? Can i send you the file for your perusal? Pls reply so that i can get this done at the earliest. Your help will really be appreciated. Thanks & best regards, Eijaz ================================================== ========================== Dear all, i hv few questions: 1) How to write a procedure to automatically create a no of sheets as the no of days in a month with the sheet names as 01, 02, 03...31...etc. 2) how to write a procedure which will automatically create a sheet each day, by concatenating the current date & a text such as "Comments", for the Sheetname. e.g the Sheet names would be created as " Comments-10292003", "Comments 10302003" etc for each current day....? 3) How to check whether a sheet has already been created & not create it by the same name again, but just append data to it. tried Worksheet.Add method, but it only adds addnl worksheets, not append to existing one..... 4) Made a Data Entry Template for transport reimbursement (voucher), which is shared over a network. Is it possible to generate a Random Aplhanumeric# for every user who fills in his reimbursement details( the details will automatically be stored on a seperate excel workbook with the unique aplhanumeric no along with the date when it was filled. Can anybody help? any help would be really appreciated. Thank & best rgds, Eijaz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an Excel Database!
Tom,
Can you pls Help me on the 4th one? Best Rgds, Eijaz ----- Original Message ----- From: "Tom Ogilvy" Newsgroups: microsoft.public.excel.programming Sent: Saturday, November 08, 2003 8:45 PM Subject: Creating an Excel Database! I gave you the information you need for Questions 1 to 3. -- Regards, Tom Ogilvy eijaz wrote in message ... Thanks Tom, It works! You wanted me to send you the original msg, which i am sending to you! If possible, help me out on the remaining queries( 3 & 4). Also, i hv a question for all, is it possible to create a database in Excel using a data-entery worksheet, so that whatever is entered on the worksheet, gets stored on a different workbook's worksheet which will be the Database! I want to integrate the auto-generation of a unique no & also see to it that sheet will validate that no duplicate entries r entered. Actually, i hv made a Reimbursement Voucher which every Employee who wants to get reimbursed for No-Transport-provided for a particular day(i.e Pickup/Drop to/from Company). They just hv to fill the (read-only) Voucher which will be located in a particular folder on the network & then enter the dates to be reimbursed along with a valid reason, e.g not Picked/Dropped up, had to catch a Cab, Train, Auto etc & Amount. The question is, whenever an employee fills in a Reimbursement voucher, i want the Reimbursement Voucher to generate a unique Code (e.g RV00001) in a cell labelled the RV# on the Reimbursement Voucher, so that employee can do a Save-As filename & then also print-it. Now whatever he entered will be automatically entered on a diff wrokbook's worksheet called say the 'Database'. Is it Possible, bcos the file stored on the network will be a read-only file? Can i send you the file for your perusal? Pls reply so that i can get this done at the earliest. Your help will really be appreciated. Thanks & best regards, Eijaz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an Excel Database for my Logged Time | Excel Worksheet Functions | |||
Creating Excel Worksheets from Access Database | Excel Discussion (Misc queries) | |||
Creating a Database in Excel | New Users to Excel | |||
Help needed on creating Excel database | Excel Discussion (Misc queries) | |||
PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions |