M
MT1
Hello:
Before I drive myself nuts building this workbook, I need to find ou
if it's doable. I appreciate any help or suggestions offered.
We have a spreadsheet at work that is used to track pickup/deliver
charges. Initially, someone enters the estimated costs and rout
information on a daily basis. The spreadsheet is very large -- hundred
of rows and 40 or so columns. Throughout the month, another perso
copies and pastes each of these rows into another spreadsheet as th
actual charges come in and notates the sheet accordingly. At the end o
the month, the person who enters the actuals, prepares it for month en
accruals. A new spreadsheet is then started for the new month.
Here are my questions:
1.) Is it possible to have 1 workbook that can be utilized by each o
these employees? Perhaps there could be 2 sheets -- sheet 1 being th
Master trace sheet which lists estimated costs, trip numbers and othe
pertinent info, and sheet 2 listing SOME of the pertinent info plus th
actuals costs. I would like some of the information entered into th
Master (such as the pertinent information) to automatically transfer t
the second one as it is entered. I do not need ALL of the informatio
that is entered in sheet 1 to appear in sheet 2. Only certains column
need to transfer/link. At which point the second person would track th
trip# and enter the actual costs. At the end of the month, I could se
up a third sheet to summarize what I need to accrue at month end b
link. As it stands now, we are working with 2 sheets and the 2nd perso
has to copy and paste whatever the 1st person enters. This is bizare an
time consuming. I have linked cells to seperate worksheets whe
summerizing, but nothing like this.
2.) Also, can 1 sheet in a workbook be password protected while anothe
is not?
Thank you,
Mar
Before I drive myself nuts building this workbook, I need to find ou
if it's doable. I appreciate any help or suggestions offered.
We have a spreadsheet at work that is used to track pickup/deliver
charges. Initially, someone enters the estimated costs and rout
information on a daily basis. The spreadsheet is very large -- hundred
of rows and 40 or so columns. Throughout the month, another perso
copies and pastes each of these rows into another spreadsheet as th
actual charges come in and notates the sheet accordingly. At the end o
the month, the person who enters the actuals, prepares it for month en
accruals. A new spreadsheet is then started for the new month.
Here are my questions:
1.) Is it possible to have 1 workbook that can be utilized by each o
these employees? Perhaps there could be 2 sheets -- sheet 1 being th
Master trace sheet which lists estimated costs, trip numbers and othe
pertinent info, and sheet 2 listing SOME of the pertinent info plus th
actuals costs. I would like some of the information entered into th
Master (such as the pertinent information) to automatically transfer t
the second one as it is entered. I do not need ALL of the informatio
that is entered in sheet 1 to appear in sheet 2. Only certains column
need to transfer/link. At which point the second person would track th
trip# and enter the actual costs. At the end of the month, I could se
up a third sheet to summarize what I need to accrue at month end b
link. As it stands now, we are working with 2 sheets and the 2nd perso
has to copy and paste whatever the 1st person enters. This is bizare an
time consuming. I have linked cells to seperate worksheets whe
summerizing, but nothing like this.
2.) Also, can 1 sheet in a workbook be password protected while anothe
is not?
Thank you,
Mar