Announcement

Collapse

Computer Lab Guidelines

Here in the computer lab, we talk about cool tech, the newest coolest gadgets, and tackle your toughest tech questions.

If you need to refresh yourself on the decorum, now would be a good time. Forum Rules: here
See more
See less

Excel Question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Teallaura
    replied
    Originally posted by robrecht View Post
    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.

    Leave a comment:


  • robrecht
    replied
    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.

    Leave a comment:


  • Teallaura
    replied
    I found it! Thanks!!!!

    http://spreadsheets.about.com/od/dat..._data_form.htm

    Leave a comment:


  • Teallaura
    replied
    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.

    Leave a comment:


  • Sparko
    replied
    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.

    Leave a comment:


  • Teallaura
    started a topic Excel Question

    Excel Question

    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.

Related Threads

Collapse

Topics Statistics Last Post
Started by Sparko, 06-17-2021, 01:36 PM
27 responses
226 views
0 likes
Last Post Sparko
by Sparko
 
Started by The Melody Maker, 06-21-2019, 11:17 AM
62 responses
13,597 views
0 likes
Last Post Teallaura  
Working...
X