spreadsheet referencing???

[Chris Brokenshire]

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

 

[JE McGimpsey]

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.

This can be done via automation in Word and Excel, using event macros.
How will Word know that you've entered data that should be put into the
Excel workbook (and where)? How will XL know what data to put into the
Word document (and where)?

Not sure what you're trying to do here, but embedding a worksheet into
the Word document may work for you.

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.

One way:

Assume data entry in Sheet1, data should be replicated in Sheet2. To get
data on the same row on Sheet2 enter something like:

B2: =IF(Sheet1!B2<>"",Sheet1!B2,"")

and copy down (and perhaps across.

OTOH, if in Sheet2 you have a code in column A, but the code in sheet1
may be in a different row, you could use:

B2:
=IF(ISNA(MATCH($A2,Sheet1!A:A,FALSE)),"",VLOOKUP($A2,Sheet1!A:J,2,FALSE))

C2:
=IF(ISNA(MATCH($A2,Sheet1!A:A,FALSE)),"",VLOOKUP($A2,Sheet1!A:J,3,FALSE))

etc.

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.

Select the cells you want the users to be able to access. Choose
Format/Cells/Protection and uncheck the Locked checkbox.

Choose Tools/Protect/Worksheet and protect the sheet's contents. You can
add a password if you wish, but you should realize that it's trivially
easy to bypass.

Only those cells that are unlocked are now accessible.