0
   

Linking between Excel worksheets (text)

 
 
Reply Tue 25 Mar, 2003 03:12 pm
Ok Excel experts, I need help. How can I link text values?

Here is what I mean:

I have sheet 1, it needs to pull text data from a certain cell on sheet 2.

With numbers this is easy using SUM but with text it just gives the value of the text as 0.

Any ideas?
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 0 • Views: 12,182 • Replies: 23
No top replies

 
roger
 
  1  
Reply Tue 25 Mar, 2003 03:18 pm
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.
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 03:25 pm
name of sheet and cell
='Daily Cash Tot.'!B25

letme try that on text
0 Replies
 
Craven de Kere
 
  1  
Reply Tue 25 Mar, 2003 03:25 pm
Someone at my office got it. I needed the + sign.

Here's an example:

=+(Sheet2!A10)
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 03:26 pm
works for text
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 03:27 pm
err CDK I name all my sheets gets easier to remember where I'm getting the data pulled in from Smile
0 Replies
 
Craven de Kere
 
  1  
Reply Tue 25 Mar, 2003 03:29 pm
good point.

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

=+Sheet2!A1
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 03:31 pm
yeah you don't need the ()
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 03:32 pm
so what you do'n?
0 Replies
 
Craven de Kere
 
  1  
Reply Tue 25 Mar, 2003 03:45 pm
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.
0 Replies
 
roger
 
  1  
Reply Tue 25 Mar, 2003 04:32 pm
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.
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 04:36 pm
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.
0 Replies
 
dagmaraka
 
  1  
Reply Tue 25 Mar, 2003 04:56 pm
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.
0 Replies
 
husker
 
  1  
Reply Tue 25 Mar, 2003 05:07 pm
dagm... send me some software an I'll get it down in notime Smile
0 Replies
 
dagmaraka
 
  1  
Reply Tue 25 Mar, 2003 10:44 pm
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!
0 Replies
 
Craven de Kere
 
  1  
Reply Wed 26 Mar, 2003 12:44 pm
roger wrote:
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.


I really do hate it. It had no formatting, just rebeliousness.
0 Replies
 
Heeven
 
  1  
Reply Wed 26 Mar, 2003 01:12 pm
A sort of related question ... does anyone know how to download the address book from a Lotus Notes mail-box to an excel spreadsheet?
0 Replies
 
husker
 
  1  
Reply Wed 26 Mar, 2003 01:34 pm
Heeven will let you knew in a few if it's possible - got to poke around
0 Replies
 
Craven de Kere
 
  1  
Reply Wed 26 Mar, 2003 01:39 pm
Hmm, I never used Lotus but I bet it can be exported. Look for an export option.
0 Replies
 
husker
 
  1  
Reply Wed 26 Mar, 2003 01:41 pm
Never "THAT" easy with Notes! Wink
0 Replies
 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » Linking between Excel worksheets (text)
Copyright © 2021 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.04 seconds on 06/15/2021 at 01:20:45