I'm off to meetings for most of the rest of the afternoon and seem to be going in circles on this one:
http://www.excelforum.com/excel-prog...ml#post2467706
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I'm stumped as to why his spreadsheet is doing this. The combo box is returning the value as text and not a number. He attached an example.
http://www.excelforum.com/excel-gene...t-numeric.html
ChemistB
My 2¢
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)
His named range "size" in the drop down boxes sheet has cells formatted custom: #" which is number with the quote custom inserted.
If you change to text and actually enter the quotes in those cells, then the initial sheet works.
Edit: I think I misinterpreted...Please ignore
Last edited by NBVC; 02-11-2011 at 12:25 PM.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
If I use that approach for the 2 comboboxes then the formula in $F$34:$F$63 break down.
You can always update the references to B26 or C26 in those formulas with Left(B26,2), Left(C26,2) or Substitute(B26,"""","")... but I am sure the methods you and romper provided should work better.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
I think I just have a mental block on this one. It shouldn't be that difficult for some of you INDEX/LOOKUP geniuses.It's more of a delete similar data than a merge similar data.
http://www.excelforum.com/excel-gene...ilar-data.html
Thanks
ChemistB
My 2¢
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)
Hi guys - im really busy at work and this is making my head spin. Could someone please take a look so the poor uy is not hanging on?
Cheers
http://www.excelforum.com/excel-gene...m-one-tab.html
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Thanks Romper
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
http://www.excelforum.com/excel-gene...ormatting.html
OP wants a VBA solution for conditional formatting as people will be pasting data.
ChemistB
My 2¢
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)
Hi Guys - hope that someone can help with this as im as desparate as the poster now to get to the bottom of it!
Col e is desired output, basically, he wants to sum between refils, will make sense when you see the attachment.
Here's the link below.
http://www.excelforum.com/excel-gene...-function.html
Thanks alot
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
I want to rename this thread 'first to the finish'... nice formula DLL.
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
lol , the hare and the tortoise!Originally Posted by Cheeky Charlie
I agree, cool formula DLL
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Who are you calling tortoise? Cheeky bugger!
(tongue in cheek)
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Can anyone help with this one? It works for me but not for the OP.
http://www.excelforum.com/excel-work...-printing.html
Either to much beer or not enough.....
Can any one sober/not so sober find a way into this thread?
http://www.excelforum.com/excel-gene...ing-maybe.html
burp, please excuse me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks