Linking between Excel worksheets (text)

Does not. Well, using sum, it probably does. In your import cell, enter the "=" sign. Move to the cell on the sheet your are exporting from and highlight the cell you want. Press enter.

You could also do with with a formula using ! and cell reference, but I have trouble remembering the precise syntax.

name of sheet and cell
='Daily Cash Tot.'!B25

letme try that on text

Someone at my office got it. I needed the + sign.

Here's an example:

=+(Sheet2!A10)

works for text

err CDK I name all my sheets gets easier to remember where I'm getting the data pulled in from

good point.

BTW the above isn''t working for me now but this is:

=+Sheet2!A1

yeah you don't need the ()

so what you do'n?

It turns out that for some reason the formulas were not working on just one column.

I deleted the column and started again and all the variations work.

Don't you just love that kind of thing? I have one worksheet that absolutely will not do a sort based on one criteria. All the others work.

Maybe you had that particular column formated for numbers or something else not compatable with text.

Well I have a program called F9 and it sucks data out of the general ledger for nifty cool searchs and compulations. Then for Access I have an ODBC link; for a PIM and financial stuff hooked into the database and spreadsheets.

any SPSS buffs around here? I will need all the help I can get in the months to come. Just testing the waters for now.

dagm... send me some software an I'll get it down in notime

send it to you? you have noooo idea how long it took me to just download it! true, it was not quite an official version and I got it for one tenth of its official price, but man! i could not install it for the devil. these nice people that make cheap software available under hand want you to 'patch this' and 'patch that', i almost gave up and did the whole thing in excel. then i was somehow enlightened and it is all fine now. it should be an entertaining struggle now - trying to code long texts into variables and then evaluating some trends somehow. if everyone does science the way i do, then i am quite done with it! i will never believe a single quantitative analysis again!

I really do hate it. It had no formatting, just rebeliousness.

A sort of related question ... does anyone know how to download the address book from a Lotus Notes mail-box to an excel spreadsheet?

Heeven will let you knew in a few if it's possible - got to poke around

Hmm, I never used Lotus but I bet it can be exported. Look for an export option.

Never "THAT" easy with Notes!