PDA

View Full Version : Excel Question



Teallaura
04-06-2015, 09:44 AM
Is there a way to create an entry sheet that allows someone to make new entries to a sheet without opening the sheet? I'm thinking of a interface where Bob can enter information but not be messing with the data sheet itself. I'm doing a registry for my church but it's senseless to have something only I can update - and our church secretary isn't good with spreadsheets. I'm thinking I've seen this done in Excel but it's been too long and I don't have a clue how it was done.

Sparko
04-06-2015, 10:10 AM
You can have a spreadsheet link to cells in another spreadsheet, so that when the second spreadsheet changes, it also changes in the first spreadsheet. You do have to have access to the other spreadsheet though, or it can't update.

Go to help in excel and search for External References


====
Create an external reference between cells in different workbooks

1.Open the workbook that will contain the external reference (the destination workbook) and the workbook that contains the data that you want to link to (the source workbook).


2.In the source workbook, click Save Button image on the Quick Access Toolbar.
Keyboard shortcut Press CTRL+S.


3.Select the cell or cells in which you want to create the external reference.


4.Type = (equal sign). If you want to perform calculations or functions on the external reference's value, type the operator or function that you want to precede the external reference.


5.Switch to the source workbook, and then click the worksheet that contains the cells that you want to link to.


6.Select the cell or cells that you want to link to.


7.Return to the destination workbook, and notice that Excel adds the reference to the source workbook and the cells that you selected in the previous step.


8.Optionally, in the destination worksheet, edit or change the formula.


9.Press CTRL+SHIFT+ENTER.

Teallaura
04-06-2015, 10:13 AM
Thanks. I knew I could do it that way - and may end up having to. I'd like a simpler interface for the data entry so that it adds to the table.

Probably not explaining this well enough. :sigh:

Teallaura
04-06-2015, 10:14 AM
:woohoo: I found it! Thanks!!!!

http://spreadsheets.about.com/od/datamanagementinexcel/ss/090717_data_form.htm

robrecht
04-06-2015, 08:33 PM
A more powerful way of allowing multiple people to do this would be with a relational database, eg, MS Access. But it sounds like you may not need something this powerful at thus point.

Teallaura
04-08-2015, 09:49 AM
A more powerful way of allowing multiple people to do this would be with a relational database, eg, MS Access. But it sounds like you may not need something this powerful at thus point.
Thanks. No, it's just going to need an interface for the church secretary and I'll do the spreadsheet management. There isn't enough work to justify the purchase.