C
Chris Brokenshire
I am Mac OS X.3 Panther using Office X for Mac.
How do I do the following:
1) I want to enter data in a Word or Appleworks document and have it show up
in specific cells in an Excel spreadsheet...and vica versa.
2) I enter a client code (letters or numbers or both) in a spreadsheet cell.
Cells in the same row as the code contain data pertaining specifically to
that code. Whenever I enter the various client codes in that spreadsheet, I
want all or some of the data, that follows the code in the same row, to show
up in another spreadsheet pertaining specifically to each code.
3) I have a spreadsheet where numerous functions fill in many cells
automatically when data is entered in one or two other cells. I want the
cells with functions to be cells that can't be highlighted or enter data in.
I want the one or two cells that data is entered in to be the only cells
that data can be entered in. Also, when the spreadsheet is opened I want the
cursor to automatically show up in the first cell that data can be entered
in and then when data is entered I want the cursor to automatically jump to
the next cell that data is allowed to be entered in...NOT necessarily the
next cell beside or below that cell.
Thanks very much in advance!
Chris
How do I do the following:
1) I want to enter data in a Word or Appleworks document and have it show up
in specific cells in an Excel spreadsheet...and vica versa.
2) I enter a client code (letters or numbers or both) in a spreadsheet cell.
Cells in the same row as the code contain data pertaining specifically to
that code. Whenever I enter the various client codes in that spreadsheet, I
want all or some of the data, that follows the code in the same row, to show
up in another spreadsheet pertaining specifically to each code.
3) I have a spreadsheet where numerous functions fill in many cells
automatically when data is entered in one or two other cells. I want the
cells with functions to be cells that can't be highlighted or enter data in.
I want the one or two cells that data is entered in to be the only cells
that data can be entered in. Also, when the spreadsheet is opened I want the
cursor to automatically show up in the first cell that data can be entered
in and then when data is entered I want the cursor to automatically jump to
the next cell that data is allowed to be entered in...NOT necessarily the
next cell beside or below that cell.
Thanks very much in advance!
Chris