| View previous topic :: View next topic |
| Author |
Message |
99white99
Newbie
Joined: 08 Jan 2008
Posts: 2
|
 Posted: Tue Jan 08, 2008 8:04 pm Post subject: Thinking I might could get some help here... |
 |
|
I posted the below paragraph on another forum and I was informed Microsoft Access or OpenOffice Base could do what I want better.
I'll try to do my best at explaining this...
ok I work at a company where I have to enter information for a client into excel(on our manifest) and then transfer that information to a survey sheet...I'm wanting to cut down the time of this process by making the survey an excel sheet and linking them...
For example I enter the information into the manifest in cell CF and the same information is simultaneously put into cell DZ on the survey sheet.
I am going to be trying to find a way to do this at work but if I still haven't found a way by the time I get home I am hoping maybe someone here will have left some information.
Thanks
So I am just wondering if anyone can help me out on how to do this with OOo Base or Spreadsheet...Hopefully it can be done o.O |
|
| Back to top |
|
 |
helmerj
OOo Advocate
Joined: 12 Aug 2004
Posts: 235
Location: Germany
|
| Posted: Wed Jan 09, 2008 12:00 am Post subject: Re: Thinking I might could get some help here... |
|
|
| 99white99 wrote: | I posted the below paragraph on another forum and I was informed Microsoft Access or OpenOffice Base could do what I want better.
I'll try to do my best at explaining this...
ok I work at a company where I have to enter information for a client into excel(on our manifest) and then transfer that information to a survey sheet...I'm wanting to cut down the time of this process by making the survey an excel sheet and linking them...
For example I enter the information into the manifest in cell CF and the same information is simultaneously put into cell DZ on the survey sheet.
I am going to be trying to find a way to do this at work but if I still haven't found a way by the time I get home I am hoping maybe someone here will have left some information.
Thanks
So I am just wondering if anyone can help me out on how to do this with OOo Base or Spreadsheet...Hopefully it can be done o.O |
Hi!
Create a link from one cell to the other, by clicking the source cell until it has a black background (before it will have the black border with the black square in the right lower corner) with the left mouse button pressed down, move the mouse to the target cell. While doing that, press ctrl+shift to create a link (courser chnages while pressing them buttons). Only dragging would result in a copy, with the ctrl added it would be moved and with ctrl+shit there will be a link created. You can also do this manually by adding this into the input line for the target cell (linking A1 from sheet 1 to the target cell):
Cheers Juergen |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed Jan 09, 2008 6:26 am Post subject: Re: Thinking I might could get some help here... |
|
|
| 99white99 wrote: | I posted the below paragraph on another forum and I was informed Microsoft Access or OpenOffice Base could do what I want better.
I'll try to do my best at explaining this...
ok I work at a company where I have to enter information for a client into excel(on our manifest) and then transfer that information to a survey sheet...I'm wanting to cut down the time of this process by making the survey an excel sheet and linking them...
For example I enter the information into the manifest in cell CF and the same information is simultaneously put into cell DZ on the survey sheet.
I am going to be trying to find a way to do this at work but if I still haven't found a way by the time I get home I am hoping maybe someone here will have left some information.
Thanks
So I am just wondering if anyone can help me out on how to do this with OOo Base or Spreadsheet...Hopefully it can be done o.O |
Helmerj's approach will work fine. However, how big a client data base are you likely to have? If it is more than a dozen or so it is probablly better to look into using a data base like Access or Base.
It is going to be more time-consuming and a bit more problem to set up but it will give you better control over the data and allow you to generate various reports, etc more easily and probably with better data quality control
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
99white99
Newbie
Joined: 08 Jan 2008
Posts: 2
|
| Posted: Wed Jan 09, 2008 8:24 am Post subject: Re: Thinking I might could get some help here... |
|
|
| jrkrideau wrote: |
Helmerj's approach will work fine. However, how big a client data base are you likely to have? If it is more than a dozen or so it is probablly better to look into using a data base like Access or Base.
It is going to be more time-consuming and a bit more problem to set up but it will give you better control over the data and allow you to generate various reports, etc more easily and probably with better data quality control |
I'm thinking the whole database thing might be a bit much...The company already has too many different kinds of DB's that don't really work good enough together.
We assign sales reps to people and record that information on the manifest. I was thinking it would be more simple to do...
I have thought of a way to make Helmerj's approach work but it really isn't worth the pain of teaching others how to do it.
Thanks to both of you for the input so far! |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed Jan 09, 2008 9:56 am Post subject: Re: Thinking I might could get some help here... |
|
|
| 99white99 wrote: | | jrkrideau wrote: |
Helmerj's approach will work fine. However, how big a client data base are you likely to have? If it is more than a dozen or so it is probablly better to look into using a data base like Access or Base.
It is going to be more time-consuming and a bit more problem to set up but it will give you better control over the data and allow you to generate various reports, etc more easily and probably with better data quality control |
I'm thinking the whole database thing might be a bit much...The company already has too many different kinds of DB's that don't really work good enough together.
We assign sales reps to people and record that information on the manifest. I was thinking it would be more simple to do...
I have thought of a way to make Helmerj's approach work but it really isn't worth the pain of teaching others how to do it.
Thanks to both of you for the input so far! |
Oh, well if the company already has a lot of databases perhaps what you want already exists and with a bit of help from your IT people you can incorporate it into what you want.
For Helmerj's approach, you say that the sales reps already record the info on the manifest. Is it possible to set up a template to do what you want and distribute it to the reps (I'm assuming the manifest in is OOo. Then the copying etc would be invisible to the reps.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
