Computer Hope

Software => Computer software => Topic started by: Sheltie84 on August 12, 2014, 02:39:32 PM

Title: Help with linking excel documents
Post by: Sheltie84 on August 12, 2014, 02:39:32 PM

I am hoping someone can help.
I have one spreadsheet where we log data and we regularly will add new lines to the bottom.  The data is logging non-compliance's so will be numbered sequentially.  What I need to see if it is possible to do is we have a second sheet which we want to automatically update from the first, the second sheet though is set out differently and so only some of the information needs to be pulled across.  I can link the two sheets on 1 line, but not sure if I can automatically get it to use the next line from the first spreadsheet to update when I create a new sheet in the second.

Hope this makes sense.

Title: Re: Help with linking excel documents
Post by: Geek-9pm on August 12, 2014, 02:53:45 PM

How long have you used any spreadsheet?
Have you ever gone thorough the tutorials?
Linking to other cells, sheets, books and objects is a standard f thing  of most spreadsheets. You can have more that one spreadsheet open at the same time.

Have you read this?
http://office.microsoft.com/en-us/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx
Does that help?  :)

Title: Re: Help with linking excel documents
Post by: Sheltie84 on August 12, 2014, 11:57:25 PM

Thanks, I have managed to link the cells on the first of our sheets but what I am struggling to know is if I can then carry the formula on to the next sheet but using the next row down?

Title: Re: Help with linking excel documents
Post by: Geek-9pm on August 13, 2014, 12:22:34 AM

Sheltie84,
You need to do some tutorials
When you come up with a formula that has use in many areas, you need to decide if you just want to use copy and past to duplicate the formula or if you shouyld do something more advanced.
Most spreadsheet programs have a script language beyond the simple math formulas. One is VBBA for Excel.  The script is put in a hidden area and used as a new function. I like  to imagine that the spreadsheet is a sheet of paper and I write t he script on the backside of the paper.

But VBA does have a learning curve. It is a full language.
This is one of many tutorials out there.
http://www.excel-easy.com/vba.html

Here is a you tube that might be what you need right now.
https://www.youtube.com/watch?v=JpxgXROC7MU
Sorry I can not give you more specific help.