I need help with transferring text from one cell to another. I can do it with numbers but I am having a hard time doing it with text. Here's an example of what I need:
In CELL A1 I want to insert text and then have whatever I type to automatically transfer
to CELL D25.
I know this is easy for you guys, but it's kicking my butt. I appreciate your help.
Greg
In D25
=IF(LEN(A1)>0, A1, "")
Something like that?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I'm sure it must be more complex than this but from what you wrote, I'd think that simply putting =A1 in cell D25 would do it for you wouldn't it?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
YES. I'm an idiot. Thanks.
=A1 will result in zeros when it's blank.
I'm sorry to throw a monkey wrench into this, but I failed to mention that the cell A1 is on SHEET 2 and I want it to go to SHEET 1, CELL D25. Does that make sense. I'm sorry to bother you guys. I'm learning...
Ok, to address what ChemistB wrote, the formula would be =if('Sheet2'!A1="","",'Sheet2'!A1) in sheet 1 cell D25.
As you write it, start in sheet1 D25, write =if( then go to sheet2 A1 and add ="","", then click on sheet2 A1 again the close parens. it will write itself.
Thanks to everyone for the help. I appreciate it... and so does my boss.
I'm new here, so Hello!
Rather than create another topic altogether, this example is very close to what I want to do so thank you already... but what if I didn't want the data to repeat on sheet1?
In other words, one of my sheets is a running list of orders, but on the other sheet I just want the item and vendor to appear once, not every single instance of the same item.
Hope that makes sense, and very nice forum you have here!
_
Gskully, it is against forum rule #2 to post your question on another member's thread.
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.
So don't be shy, start your own post and your issue will get direct attention and be tailored to what your problem is. Thanks and welcome to the forum.
Okay, so I'm back. I'm trying to have CELL: E-10 on SHEET 5 go to CELL: F-4 on SHEET 4. It will be text. I'm pretty much an idiot but would like to learn at least a few things. I appreciate your time and help. thanks.
so, put your cursor in sheet4 cell F4, write =if(Sheet5!E10<>"",Sheet5!E10,"") and that should do it for you.
what that is saying is that, in sheet4 cell F4, if there is a value in sheet5 cell E10, return that value, otherwise leave this cell (F4) blank. Hope that helps.
Sambo kid,
Thanks for your help. I tried applying the formula and it didn't work for me. I tried to upload the actual Excel spreadsheet to this forum, but it wouldn't accept it; it might be too large. I'm not sure. If you feel comfortable with it, please send me an email to [email protected] and I will email you the document. I know this seems kind of shady, but I'm being sincere with my problems and will not do anything but what I'm saying.
When you say it doesn't work, what does happen? That would give a clue as to what is wrong.
When I do insert the formula it says, "Invalid Cell Reference."
well, I wrote this as a sample formula in sheet2 of an open spreadsheet I have and it works for me.
=IF(Sheet1!A2<>"",Sheet1!A2,"") So I would think that if you substitute your cell references for mine it should work for you.
I appreciate everyone's help, but I'm having a bad case of operator error going on here. I'm not good at this. I'm good at cutting glass. If anyone can provide me an email to send it to or send me an email, I would appreciate it. [email protected]
Again, I realize that asking for email addresses on the internet is shady, but I'm not being shady. I'm just an idiot.
If you post the formula that you are trying to enter into your sheet, I will tell you what is wrong with it. If you put a ' in front of your formula as you are typing it, it will treat it as text and not a formula and won't give you an error message.
My SHEET 5 is labelled 38 COVER. My SHEET 4 is labelled 38 DRAW.
Here's what my brain tells me to insert based upon the help I've received:
=IF(38 COVER!E10<>"",38 DRAW!F4,"")
an if then statement is saying, if something exists, then do this, otherwise do that. so you want to return the value in E10 unless it is blank, then if it is blank leave this cell (F4) blank.
should say =IF(38 COVER!E10<>"",38 COVER!E10,"")
you want to return the value in E10 and if that cell is blank then leave the cell (F4) blank.
you need to put the sheet names in single quotes (') also since there are spaces in them
should say =IF('38 COVER'!E10<>"",'38 COVER'!E10,"")
ChemistB, you made it happen. I appreciate it and I apologize for taking so much time. Greg
Glad we could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks