Dezbend
Premium,MVM
join:2001-04-20 | reply to Dezbend
Re: [OT] excel help
never mind... I am following the instructions in help. |
|
Dezbend
Premium,MVM
join:2001-04-20 | reply to bjl
I have a macro, how do I make a button? |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | reply to Dezbend
you could probably create a macro and add a button to run it. |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to Dezbend
one last question.... and thanks for all the help.... is there a way to turn auto sorting on? (so when he drops the raw numbers into sheet 2 it will update the numbers with the functions bjl provided me, it will then sort sheet 1 by a certain column value(i have a total column that adds up the sales)?
--
DSLr Mafia Member. |
|
Dezbend
Premium,MVM
join:2001-04-20 | reply to bjl
ok thanks. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA
| reply to Dezbend
said by Dezbend  :said by bjl :also, right now if the name from sheet 1 isn't in sheet 2, you'll get the nasty #N/A error. you can is ISNA() and IF() to change these errors to meaningful messages. can you explain this a little more for me? I do have a bunch of #n/a I need to clean up... I want it to result a "0" if there is no name found. you need to wrap the vlookup functions with IF(ISNA()), e.g:
=IF(ISNA(vlookup statement),0,vlookup statement)
--
flickr gallery | photo blog (rarely updated) | play mafia! |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to bjl
said by bjl :also, right now if the name from sheet 1 isn't in sheet 2, you'll get the nasty #N/A error. you can is ISNA() and IF() to change these errors to meaningful messages. can you explain this a little more for me?
I do have a bunch of #n/a I need to clean up... I want it to result a "0" if there is no name found.
--
DSLr Mafia Member. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | reply to Dezbend
no problem! |
|
Dezbend
Premium,MVM
join:2001-04-20 | reply to Dezbend
vlookup works for what I need. Thanks bjl! |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to bjl
correct.
the vlookup function may be what I need. when I get a chance today, I will look at this function and play around with it a little.
Thanks for pointing me in that direction bjl. I will let you know.
--
DSLr Mafia Member. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | reply to bjl
also, right now if the name from sheet 1 isn't in sheet 2, you'll get the nasty #N/A error. you can is ISNA() and IF() to change these errors to meaningful messages. |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA
| reply to drew
said by Dezbend :The list of names on sheet 2 may change from day to day… I took this to mean that sheet 1 won't change, but the data in sheet 2 will. |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs: | reply to bjl
Sheet 1 won't always have the same names as Sheet 2. I don't think this is something they wanted to do "manually" |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA
| reply to Dezbend
looking at it again, I think you can use vlookup. see the attached. |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to drew
said by drew :The issue is that there are two sheets and the rows aren't equivalent. QFT
don't worry about it guys. If it isn't easy, it isn't worth it. This isn't a job requirement, it was a "hey this would be nice" kind of thing. It is easy enough for me to say Excel can't do it.
--
DSLr Mafia Member. |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs: | reply to Archivis
The issue is that there are two sheets and the rows aren't equivalent. |
|
avd706
insert annoying animated gif here
Premium
join:2003-02-06
Union, NJ | reply to Archivis
mysql FTW |
|
Archivis
Your Daddy
Premium
join:2001-11-26
Earth
 ·Verizon FIOS
| reply to Dezbend
So you need to put a value (Cell C), into Cell A, only if it meets the criteria in Cell B?
That's called an Array Formula. You don't need VBA for that. Excel supports this.
But yeah, you definitely need to be "retrieving" instead of "pushing" data. Dez, hit me up in PM's. If I don't know how to do it in excel, it can't be done, or you need to be a programmer.
--
'A government big enough to give you everything you want, is strong enough to take everything you have.' -Thomas Jefferson -
|
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH
| reply to Dezbend
The problem too with delivering VBA-modified Excel workbooks to end users is that they WILL find some way to break it. Suddenly it isn't a formula not working or some Excel garbage, but the program YOU wrote and now must fix.
I think it's perfectly reasonable for you to tell him that Excel is not a practical solution.
--
Have more fun with your GPS.
Geocaching.com |
|
Dezbend
Premium,MVM
join:2001-04-20
| reply to drew
If excel can't do it, then I don't care. I track my students in an Excel, but I just pull their sales numbers and update it manually. A supervisor asked me to make him one, and I was trying to automate it as much as possible, but we don't have access or anything to use without getting IT involved.
--
DSLr Mafia Member. |
|
