View Full Version : Any Excel 2007 Experts Here?
Gaystoryman
05-05-2009, 02:53 PM
Could use some help, in setting up an excel formula, or whatever, to track some data from one sheet to another, that is not porn related.
Anyone really good at using excel?
The 'problem' is to take some data from one worksheet, to place in another worksheet, but the kicker is, I need to update the info on sheet 2, when added to sheet 1, ignoring any white space in between.
Anyone? :confused:
I am no expert either but had to do this recently myself.
The help section in excel talking about object linking and embedding (OLE) or linking worksheets using the formula bar may be helpful.
When you create the formula you simply use a code to link the cell to another worksheet. Be careful when doing this as changes made in the original will affect any sheets linked to it as well.
I opened both workbooks then followed the step by step instruction in the help section.
Gaystoryman
05-05-2009, 03:33 PM
Have to check that out, like why can't they simply call it what is, instead of all this mumbo jumbo... :bang: thanks Paul
gaydemon
05-06-2009, 02:54 AM
A fairly basic lookup from one sheet to another would be this:
=SUM('Sheet2'!G17)
It pulls whatever data / sum if finds on the sheet called "Sheet2" in Cell G17 and displays it where the formula is used.
You can create much more advanced ones that looks for certain data on the columns and returns the data only if it finds a match.. anyway if you need it more advanced that the above let me know.
Gaystoryman
05-06-2009, 10:20 AM
A fairly basic lookup from one sheet to another would be this:
=SUM('Sheet2'!G17)
It pulls whatever data / sum if finds on the sheet called "Sheet2" in Cell G17 and displays it where the formula is used.
You can create much more advanced ones that looks for certain data on the columns and returns the data only if it finds a match.. anyway if you need it more advanced that the above let me know.
I got a hunch I am over complicating the form/sheet.
Partially due to me wanting to be able to enter it as I go, but then switching sheets, is a lot simpler than coming up with formulas.
So back to the drawing board on this one, which is important to get right, for me anyhow. Interesting how there are so many templates premade, but when it comes to instructions, they seem to always get buried. :bang:
Thanks Bjorn, appreciate the suggestion, and to everyone else who offered some ideas.