I have a problem, and I know the solution to it, I just can't remember the name of the command I want and I can't think of any good way to search the help or the web to come up with it. I'm hoping someone here can help me with it. First, the original problem, just in case someone has an alternate solution. I want to make a chart that graphs 3 lines over 12 months. However, only 1 line will go the whole 12 months (my budget line), while the others will stop at the current month. Excel has an option to simply not plot non-zero cells. However, my cell has a formula in it that makes the cell look empty, but really it isn't. So, Excel is plotting that as a zero instead of just having the line stop. My solution is that I seem to remember there is a way to write a formula that will take a value from one cell and put that value in a different cell, without the destination cell needing any formula in it itself. For example, A1 would have my formula to calculate the number I want; A2 would have a formula that would take the value from A1 and put it in A3; I would make my chart using the value in A3; and that chart wouldn't plot anything for A3 if A3 is blank as a result of A1 not having any solution. Make sense? Does such a thing exist, or am I on crack? What is it called? Failing that, can you think of an elegant search term for the help/web to find it?
i'm a "novice" when it comes to excel, but whenever i just want to graph certain values, i just press Control and Click on the boxes i want. that sounds too simple to help you though.
I've always thought of myself as above average on everything to do with Excel, except for charts and graphs..... When I have problems with Excel, I usually go HERE You can post your question, and definite experts usually respond within an hour or less. Pugs
you might try this: When copying and pasting into different cells, right click on the cell you want to paste into and select 'paste special'. It should give you more options on what you want to paste. Select 'paste value' and it will not paste the formula just the value that was in the cell.
That would work, except that I'm looking for some passive mechanism. Otherwise, I'll have to do 153 cut-and-paste-special every month. And, I'll have to have a master copy with my formulas and produce values-only versions. All just to have my chart look okay. Of course, I can write some VB to do that for me. Maybe I'll need to go to the microsoft BB and ask there. Thanks pugsley.
Trying not to hijack your thread here JV but I have an Excel question myself. I have an Excel program (sheet) that is working with several other programs. One of the programs enters a 1 into cell A50 so that the cursor will move to cell C2. The problem is that the Excel sheet is setup to do this manually, when 1 is entered somebody must press enter on the keyboard to send the cursor to cell C2 from A50. Cand Send Keys be used here some place in the VBA code so that if 1 is entered SendKeys "Enter" is used so that the cursor moves automatically without somebody having to do it manually? Any help is greatly appreciated.
JV, If you don't get a better answer elsewhere, you might create a push button that will do all your paste specials for you.
You can do wonders with "iif". Do you use VBA(?), because you could easily handle it with this. If you could send me a before/after, I might be able to help.
How good is Excel with dates? I am wanting to write a collection of employee names and then certain dates for these employees. Let's say I have John Doe. He has several dates that all that expire in a year. I want one for the name of each employee and one column for each date. I want a column somewhere for dates that are expired.
I am so wanting to do a lot more with Excel than I currently am. Where's a good place to get a gentle boost from the basic adds, subtracts, and general formats? Any book you masters recommend?
It depends on what you want to do. I have a book called "Excel 2002 Power Programming with VBA" by John Walkenbach. It is a very good book. Most of the other stuff I search the web for.
Honestly, I would make frequent use of Excel's help. It's very good. That and the web is all I've ever used to learn Excel (of course, I am the one that started this thread with an Excel problem). Btw, thanks everyone for the help. I'll likely be doing a VBA solution. Lil Pun, I don't think I understand your problem. Can't you just type the names and dates? Do you need Excel to generate, select, sort, or otherwise manipulate the dates in some way?
The book that I mentioned earlier has saved my butt a few times. I highly recommend it, if you want to learn how to take advantage of VBA.
Hijack Numero Dos... Anyone any good at VBA coding? I know some VB .Net stuff but this old-school specific stuff for excel is making it tough. Anyway, here's what I need this macro to do.. It should delete all rows that don't have a certain word in the cells under column A. For example, all rows would be deleted if they didn't have the word and only the word apple in their cell under Column A. Any ideas? or is this even possible?
