J
jeff
Hi, Ryan,
I'm sure there are better answers than mine coming, but
here go my thoughts:
To your over questions, I think it really depends on
what exactly is kept on all the transaction sheets
and how complicated you have to be (not WANT to be).
Simplest is best if you can define what that means.
Q: Is it possible to create a accumulative total sheet
that can link to the agent sheet created to keep a
running total? Yes, but see next Q first.
Q: Should a workbook be made for each agent verses a
sheet for each transaction? There is no definitive
answer for this, but to me, organizing by either agent
or date or some other criteria you have in the real
estate business makes sense. This way you just add
new sheets for each new transaction and yet keep
a "summary" or "totals" sheet for each workbook that
could keep the info you need at the central level.
You can get to these via links to the workbooks,
and adding a new agent would be easy to do.
Is it possible to link sheets together without the use of
a server? I've not tried it but using a peer-to-peer
network should work for linking to workbooks
- Others have experience here????
Good luck!
jeff
computers linked via a LAN and there is no server
available to the users. Computer A creates a sheet and
then places it in computer B's hardrive. Computer C pulls
the sheet off of computer B and then burns it to disk.
These sheets have closed commission dollars and I would
like to create a running total of $$ paid into the
company and to the agent. We have 57 agents and every
transaction a new sheet is created. My question is: Is
it possible to create a accumulative total sheet that can
link to the agent sheet created to keep a running total?
Should a workbook be made for each agent verses a sheet
for each transaction? Is it possible to link sheets
together without the use of a server? ANy information
would be greatly appreciated!
I'm sure there are better answers than mine coming, but
here go my thoughts:
To your over questions, I think it really depends on
what exactly is kept on all the transaction sheets
and how complicated you have to be (not WANT to be).
Simplest is best if you can define what that means.
Q: Is it possible to create a accumulative total sheet
that can link to the agent sheet created to keep a
running total? Yes, but see next Q first.
Q: Should a workbook be made for each agent verses a
sheet for each transaction? There is no definitive
answer for this, but to me, organizing by either agent
or date or some other criteria you have in the real
estate business makes sense. This way you just add
new sheets for each new transaction and yet keep
a "summary" or "totals" sheet for each workbook that
could keep the info you need at the central level.
You can get to these via links to the workbooks,
and adding a new agent would be easy to do.
Is it possible to link sheets together without the use of
a server? I've not tried it but using a peer-to-peer
network should work for linking to workbooks
- Others have experience here????
Good luck!
jeff
office and have run into a stumbling block. We have six
computers linked via a LAN and there is no server
available to the users. Computer A creates a sheet and
then places it in computer B's hardrive. Computer C pulls
the sheet off of computer B and then burns it to disk.
These sheets have closed commission dollars and I would
like to create a running total of $$ paid into the
company and to the agent. We have 57 agents and every
transaction a new sheet is created. My question is: Is
it possible to create a accumulative total sheet that can
link to the agent sheet created to keep a running total?
Should a workbook be made for each agent verses a sheet
for each transaction? Is it possible to link sheets
together without the use of a server? ANy information
would be greatly appreciated!