E
eijaz
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
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