N
Nimit Mehta
Problem: I have 1000 excel workbooks maintaining database
of conference calling customers. All workbooks are in a
folder and are named unique (customer name). All sheets
have same criterias. Coloumn A in all contains DATE, B
Contains TIME, C contains COUNTRY, D contains RATE, E
contains MINUTES. Entering this manually, i get RATE x
MINUTES = Total ammount which gets deducted from customers
total balance he has in his account. I.E All workbooks
contain formulas. All these workbooks are linked with one
main sheet called "report" where i can see current balance
of all 1000 customers at one go, and their other details
without opening individual files.
What my employees do right now is manually write down on a
paper, customer name, date, time, country, his password,
and minutes he called. At the end of the day i enter this
data of about 3000 minutes everyday into individual excel
files of all customers. This is really hectic.
what i want to do is, give my employees an excel sheet and
want them to write everything they used to write on paper
in this excel sheet, details like "name, password,
country, minutes" and that should automatically go into
the individual excel files of respective customers.
Do i need to use some third party software to make this
work, or can i do this using only Excel?
Thanking You.
Nimit.
of conference calling customers. All workbooks are in a
folder and are named unique (customer name). All sheets
have same criterias. Coloumn A in all contains DATE, B
Contains TIME, C contains COUNTRY, D contains RATE, E
contains MINUTES. Entering this manually, i get RATE x
MINUTES = Total ammount which gets deducted from customers
total balance he has in his account. I.E All workbooks
contain formulas. All these workbooks are linked with one
main sheet called "report" where i can see current balance
of all 1000 customers at one go, and their other details
without opening individual files.
What my employees do right now is manually write down on a
paper, customer name, date, time, country, his password,
and minutes he called. At the end of the day i enter this
data of about 3000 minutes everyday into individual excel
files of all customers. This is really hectic.
what i want to do is, give my employees an excel sheet and
want them to write everything they used to write on paper
in this excel sheet, details like "name, password,
country, minutes" and that should automatically go into
the individual excel files of respective customers.
Do i need to use some third party software to make this
work, or can i do this using only Excel?
Thanking You.
Nimit.