Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Hi, I need help in cell reference. I have a range of data in 20 columns in 30 rows, with data in each column being unique. All the columns have a defined name to identify the range of data.
If I choose the defined name from a drop down in cell A1 - say "Edwin": then the outcome in range A2:A32 should reflect the entire data range of C2:C32 which is defined as Edwin.
If I select the defined name of "Anoop" in A1 then the outcome in A2 should reflect the entire data range of Q2:Q32.....
Name: DerbyDad03 Date: May 23, 2009 at 16:36:38 Pacific
Reply:
re: Please help me as it is urgent!
Please be aware that telling people in a forum that your question is "urgent" is more apt to hurt than help. When you imply that your question is more "urgent" than anyone else's, you run the risk of turning people away.
Summary: Hello, I am trying to reference the current cell that I'm on (for a macro). I need to have it display the current cell such as in D8; I currently have it set to =D8. I want to have some way to make it...
Summary: Hi, I want to extract the cell reference from within a formula and can't for the life of me think how to do it ! Let's say in A1 i've entered a date. Cells A2 to A10 all point at cell A1 (so the form...
Summary: Hi, Not sure if this is what you are after and I am working in Exl 2003 but, You can copy the value in the cell in excel and paste it into word, you can't write the cell reference directly e.g Sheets1...
0 
