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
|