Automatic data entry

  • Thread starter Thread starter milesryl
  • Start date Start date
M

milesryl

Is there a way to have data entered into the next available cel
automatically, without having to designate a specific cell? I have
ledger that I am trying to get updated automatically and so I wont kno
which cell info needs to go into, I'll only know the column. Thanks
 
Hi
not quite sure where you want to enter you data: Do you have a userform
for your entry?
How do you want this to automatically happen?
 
Hi Frank,

To answer your question:
I am trying to get info from my client database (mostly payment info
onto my monthly ledger. My monthly ledger includes any monies coming i
or going out for a given month. The ledger follows a chronologica
format so transactions are listed as according to the date. There ca
be more than one, or no transactions on any given day, which is m
problem. I can't assign any certain cell to input info from anothe
worksheet cause I don't know how many transactions I will have in
given month, and what order they will come it.
For more background info on my project: My client's payment info is i
my client database and most of the clients are on a payment syste
where money is automatically withdrawn from their bank accounts ever
two weeks. So instead of having to look through my entire clien
database to see who owes me money on a certain day, I would like
program to automatically take payment info from my client database t
the monthly ledger so I know what money has gone into my account on an
certain day. I am currently working on a TODAY() function to get tha
working, but once I have that part done I don't know how to enter i
into my ledger. Sorry for this being so long, but it's a bi
comlpicated. Thanks for any help you can offer
 
Hi
stiell not quite sure but if you want to get the sum for a specific
client for a specific date try the following
Assumptions for your 'ledger' sheet:
column A: the name of your client
column B: the date
column C: the amount

To get the amount for a specific customer for today you may use
=SUMPRODUCT(('ledger_sheet'!A1:A1000="client_name")*('ledger_sheet'!B1:
B1000=TODAY()),'ledger_sheet'!C1:C1000)

you als may consider using a pivot table. Take a look at
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
for getting started
 
Back
Top