2015- Happy New Year
http://www.excelforum.com/the-water-...4-onwards.html
2015- Happy New Year
http://www.excelforum.com/the-water-...4-onwards.html
could you make it sticky please
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Excel Mac- Insert Copied cells
http://www.excelforum.com/excel-new-...-formulas.html
Anybody else have problems getting McG's wb to work?
http://www.excelforum.com/excel-prog...condition.html
Anyone have a look at this, please.
Lookup functionality from a group against a matrix
I have no idea what to do with it.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
OP facing automatic De-selection in excel when connected to internet. Any suggestion will be helpful to the OP
http://www.excelforum.com/excel-gene...bug-in-xl.html
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
OP is running MAC. UDF works for me on Windows machine. OP cannot get to work. Any thoughts out there?
http://www.excelforum.com/excel-prog...same-time.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I see you're pursuing alternatives but the issue was thatwon't work on a Mac.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
This one will require a UDF or VBA
http://www.excelforum.com/excel-form...in-a-cell.html
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
Is it possible to count consecutive dates in unsorted data? (with a criteria)
I've tried a few VBA loops as well as standard formulas. https://www.excelforum.com/showthread.php?t=1060307
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Anyone up for a challenge. OP is looking to do a search using one identifier that indicates multiple field criteria. I am baffled.
http://www.excelforum.com/excel-prog...arch-code.html
Can somebody look at this, I have run out of time.
http://www.excelforum.com/excel-prog...ml#post3958290
The code works for me, it creates a formula from closed workbooks, then renames the workbooks as whatever the formulas are.
Thanks.
I should add, the code just works once, running it a second time results in error when writing the formula.
Last edited by davesexcel; 01-16-2015 at 08:54 AM.
Anyone have a look at this ...
Downloading Visio and connecting to excel 2007
Started out looking for generic advice on which version of Visio to download.
Now it seems to be a problem automating Outlook.
Welcome any input/thoughts.
Thanks, TMS
It is a real nice, challenge one which I have spent couple hours, but could not give it an end.
Start and End calculation is finished, though it is sure that there must be better solution somewhere.
Also, I am stuck in Total cell (cell I4).
Can somebody look at this and give an end?
http://www.excelforum.com/excel-form...tal-hours.html
Quang PT
This poster needs help with a pivot table:
https://www.excelforum.com/showthread.php?t=1061056
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I am unable to understand this OP's actual problem (Date Format)
http://www.excelforum.com/excel-prog...or-format.html
Would somebody else like to have a go here: http://www.excelforum.com/excel-char...ct-result.html ?
I need to step away for a bit.
A VBA solution would be much better for this.. the two threads are linked of course
http://www.excelforum.com/excel-gene...ml#post3958138
http://www.excelforum.com/excel-gene...ed-lookup.html
Life's a spreadsheet, Excel!
Say thanks, Click *
http://www.excelforum.com/excel-char...et-advice.html The OP says he is having trouble implementing the solution in 2013. Not knowing what might be different between 2007/2010 and 2013, can anyone look at the tutorials and identify any obvious "here's where 2013 is different" steps?
Originally Posted by shg
Can someone have a look at this. I've lost the plot.
Use Cell Formula in VBA code
Thanks, TMS
I'm thinking this might be a SUBTOTAL trick of some kind... http://www.excelforum.com/excel-form...ml#post3963902
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Workbook open event is not working in this OP's colleague machine (VBA)
I am unable to fix the issue so any suggestion will be helpful to the OP.
http://www.excelforum.com/excel-prog...alization.html
This person is stuck building a "heat map" using one of Chandoo's templates: http://www.excelforum.com/excel-gene...-map-help.html
It appears that his hangup is around adapting Chandoo's 5x5 table to the OP's 10x4 table. Since Chandoo's tutorial depends on the use of structured table references (and I,, stubbornly, do not want to learn structured table references today), I do not know how to adapt structured table references and named ranges using them from 5x5 to 10x4. Can anyone step in and help?
Can I get a little backup on this:
http://www.excelforum.com/excel-prog...-workbook.html
User requests a Command Button macro that modifies a single cell on multiple workbooks with similar names in the same folder.
I started on this on Tuesday and am still out of the office with the flu.
Hi guys. Can someone help me (and the OP) with this one. OP was trying to retrieve data from one workbook to anther. I gave them a solution using indirect but it seems indirect only works on OPEN workbooks. Can someone look at it and see if there is a formula solution to this for CLOSED workbooks?
thanks
http://www.excelforum.com/excel-form...yperlinks.html
Happy with my advice? Click on the * reputation button below
Anyone want to chime in on this 1?
http://www.excelforum.com/excel-prog...ml#post3977955
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Any one here (Subtotal)
http://www.excelforum.com/excel-gene...ml#post3979287
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
http://www.excelforum.com/excel-prog...ml#post3981394
I'm not sure what OP means by "automatic scrolling" - and to be honest, I don't have the energy to begin explaining about the options of looping through selecting / delay which is the approach that springs to mind. Not sure what he's actually aiming to achieve. Anyone?!
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Anybody want to look at this, my head hurts.
http://www.excelforum.com/excel-prog...ml#post3948177
I don't have any clue how some of the row numbers disappear from excel worksheet
But I suspect some addin may caused this issue
Any suggestion will be helpful to the OP
http://www.excelforum.com/excel-gene...ml#post3983077
can anyone help with this? I think it fell through the cracks...
http://www.excelforum.com/excel-prog...worksheet.html
I have probably gone just about as far as I can realistically go with this one: http://www.excelforum.com/excel-char...ock-chart.html
I know how to make a panel chart without VBA, but he seems to want to do it all in VBA. Since I never use VBA to create charts (and am too lazy to learn it just for this one post), I'm calling on others who may be more conversant with manipulating charts with VBA to help him out with the code details he gets stuck on.
I don't know how better I can help this guy, anyone please take care this thread... (VBA)
http://www.excelforum.com/excel-prog...ers-value.html
Excel function not working after converting the File to Dutch Version
Any suggestion will be helpful to the OP
http://www.excelforum.com/excel-form...g-formula.html
http://www.excelforum.com/excel-prog...uaranteed.html
please check the attached with xl'03
Anyone care to cast their eyes over this, please:
Subscript Out Of Range Error
Not sure of the purpose of this code but not for me to question. If I have understood what it does and how it does it, it should work. But, in some cases, it doesn't.
Thanks for any input, ideas and thoughts, TMS
Hi all.
Apologies if it seems like I'm asking for help on my own post, but would just appreciate if, on top of what Mr Shorty's said, someone with Excel 2010 could verify if they get the same results as I do:
http://www.excelforum.com/excel-form...-0-errors.html
Thanks a lot
Form Visual Effect is happening in the end of the code only not while the code runs (VBA)
Any suggestion will be helpful to the OP
http://www.excelforum.com/excel-prog...-continue.html
I'm unable to understand the OP's requirements here
http://www.excelforum.com/excel-prog...ank-order.html
Can you please help?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Here's one that is extending beyond my union approved job description: http://www.excelforum.com/excel-char...iple-axes.html
I believe the filter or pivot approach will work just fine, but the OP does not want to "click away from the chart" to execute changes to the pivot table or filter. My only thought is to automate the pivot or filter changes through macros associated with buttons on the chart. However, as noted, that goes beyond what I can do or want to learn how to do at this point.
Can anyone help here? I can get it to work if the dates are always Sat or Sun, but they are not always...
http://www.excelforum.com/excel-form...ml#post3992416
This guy has a working solution, but he seems to dislike his helper columns. Since I am one who prefers to use helper columns, I am suggesting that one of you who is much more keen on eliminating helper columns would step in and help eliminate the helper columns.
http://www.excelforum.com/excel-form...ial-value.html
The OP here marked solved before I could call in the cavalry. I have sometimes wondered about this as well, so, even for my own education, is there a way to code a VBA UDF so that Excel will automatically recognize the output type and change the number format accordingly? http://www.excelforum.com/excel-prog...s-in-udfs.html
I have seen this behavior with native date and financial functions, where if you put =TODAY() or =PV() into a cell formatted as general, Excel will recognize that "data type" of the function and format the cell for you (whether you like it or not). Can we code a VBA UDF in such a way to get similar behavior, or will it necessitate "change event" procedures and such to force the issue.
I'm having trouble interpreting the data here - can you please take a shot at it?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Can somebody check this out and see if it is an xl'07 issue.
http://www.excelforum.com/excel-prog...ml#post4002083
OP claiming that OS Windows XP / 7 is causing Printing Problem in Excel.
I am unable to fix the issue so any suggestion will be helpful to the OP
http://www.excelforum.com/excel-gene...g-problem.html
OP is using some sort of calculation but I don't know how he is arriving it
Anyone please take this thread
http://www.excelforum.com/excel-gene...a-dataset.html
OP asking if the Find/Replace window can be anchored, not sure if there is a VBA way to do this?
http://www.excelforum.com/excel-gene...ce-window.html
OP in need of HTML Web Query in VBA to search Website and Get the Resulting Value in excel Cell (may be UDF with HTML object query I think)
Any suggestion will be helpful to the OP
http://www.excelforum.com/excel-prog...ml#post4006558
Anybody want to bite on a formula here...
http://www.excelforum.com/excel-form...umproduct.html
HTH
Regards, Jeff
I would really appreciate if someone could assist with providing a VBA solution to the OP. The formulas that were provided work however, over 65,000 rows makes the task impossible to accomplish.
Thank you.
http://www.excelforum.com/excel-gene...g-problem.html
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Could somebody with more VBA experience than I offer a suggestion here?
This VBA request I don't quite understand. Any Takers?
Anyone provide ideas and inspiration for this:
http://www.excelforum.com/excel-gene...d-in-tab1.html
The OP has multiple sheet that have replicated data using INDIRECT. There is an issue when rows are added or deleted. I have suggested using INDEX but that, seemingly doesn't provide the solution being searched for.
Thanks, TMS
Mental block on this ... just can't see what the OP is asking for.
http://www.excelforum.com/excel-prog...mpty-cell.html
Anyone care to take a look?
Thanks, TMS
I don't know what this OP want me to do
http://www.excelforum.com/excel-new-...uplicates.html
http://www.excelforum.com/excel-gene...ml#post4017210
OP is trying to work on something to track food eaten with "bad" symptoms. I have started on something here, but if anyone else has any input, that would be great, I would hte to re-invent the wheel
Anyone care to take a look at this one:
http://www.excelforum.com/excel-new-...err-clear.html
Ideally, someone who has a deep understanding of error trapping and handling.
I know, and so does the OP, various ways of avoiding this issue, but that's not the point. The OP is using "On Error GoTo Here" to switch on error handling. But it doesn't seem to handle the error generated when Application.WorksheetFunction.Match doesn't find the search value. We both know that it can be avoided using "On Error Resume Next", and I have explained that it can also be avoided by using just Application.Match. Again, not the point he is making. Why doesn't "On Error GoTo Here" work?
Mysterious Result by Iferror() unable to fix the root cause
http://www.excelforum.com/excel-form...to-defeat.html
Does anyone have an idea what the OP is trying to do here?
http://www.excelforum.com/excel-prog...e-not-set.html
If posting code please use code tags, see here.
http://www.excelforum.com/excel-prog...using-vba.html
The OP PM's me requesting help. I didn't feel that I could help him. When he bumped his thread, he asked if I knew anyone who could help him. I suggested that he might want to post additional details about his requirements, or try to narrow the scope of his question down to something more specific, and that others would be more likely to respond. If anyone here has any suggestions or questions for this OP, you might have a look and see if we can offer anything helpful -- even if it is another question to help him ask a better question.
Would anyone care to take a look at this and offer thoughts and advice.
Xltm opens the original not a copy
The OP is saving a workbook as a template file, but then double clicking on it to open. He says that double clicking on the template opens a copy of the workbook for most users, but not for one of them.
Strictly speaking, I don't believe that the "template" is being used in the true sense of a template, as Microsoft might consider it. They are simply using the "template" as base copy of the file. Apparently, the users double click on the file and it opens a copy of the file. They create a costing using it and print it out but never save the file.
I am more than a little confused and would welcome a second, third and fourth opinion.
Thanks, TMS
Here's one that has been haunting me for a while.
http://www.excelforum.com/excel-prog...ot-saveas.html
Not sure what this OP wants me to do?
http://www.excelforum.com/excel-gene...-research.html
Simple combination of functions needed to populate result but I am week in maths so unable to understand how the OP arrives the result.
http://www.excelforum.com/excel-form...ach-value.html
http://www.excelforum.com/excel-form...s-formula.html
Next request is out of my wheel house. Can this be accomplished with worksheet change event?
Hmmm.. I'm also interested how formatting can change values in the chart:
http://www.excelforum.com/excel-gene...kes-sense.html
Never use Merged Cells in Excel
Anybody want to help someone do a waterfall chart?
http://www.excelforum.com/excel-char...tter-idea.html
Entia non sunt multiplicanda sine necessitate
I think this poster needs VBA and that isn't in my wheelhouse. Anyone who can help him?
http://www.excelforum.com/excel-form...l-a-value.html
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Any thoughts on this issue. I am at a loss at how to even formulate in my mind. Need to look at OPs last post to understand what he wants.
http://www.excelforum.com/excel-gene...n-workbks.html
http://www.excelforum.com/showthread...=1#post4043652
Any help to draw data from table?
I am unable to fix which one is causing Automation Error (VBA)
http://www.excelforum.com/excel-prog...s-clients.html
Hyperlink created in 2013 on a shape is crashing when the file is opened in 2010 while clicking the shape
Any suggestion will be helpful to the OP
http://www.excelforum.com/showthread...=1#post4046341
Anyone would like to take this maths question?
http://www.excelforum.com/excel-prog...n-and-row.html
http://www.excelforum.com/excel-prog...in-a-cell.html
Long and confusing and mac, if anybody wants to take the time.
http://www.excelforum.com/excel-prog...with-data.html
Scope creep has taken this beyond my capabilities.
Alan
@Alan: answered in thread.
Regards, TMS
@Trevor
Thanks. I could not wrap my head around the last request.
Alan
You're welcome. Let's hope it works in the live environment. Basically, for blank cells in columns B to D, it propagates whatever is to the left, including blanks. Initially it applies a formula and then converts the formula result to a value. That way, you end up copying across but still have blank cells. Then, for the blank cells in row 10 down, it propagates whatever is above. Same approach, formula then value.
If the "rules" are the same in the live environment, it should be OK.
Cheers, Trevor
Please, please, please ... can someone take a look at this and see if they can explain it in a different way.
Took me a while to see the issue, out of context, but with the code and the workbook, it is more obvious.
However, I just don't seem to be getting it across to the OP. Maybe it's me, it could very well be me, but I really can't say it a different way ...
Thanks to anyone with more patience than me
Hi,
Can your amazingly genius minds help me solve my requirement in my thread Partial Match for Group Names ?
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
The purpose of this thread is not for you to bump your own questions. It's for when you get stuck trying to help someone else.
ANyone feel like jumping into this 1? Looks fairly interesting - creating a dynamic pic from an excel range.
http://www.excelforum.com/excel-gene...t-in-list.html
I've got this OP started: http://www.excelforum.com/excel-char...bar-chart.html but he wants to create his counts using a pivot table, and pivot tables/charts are above my pay grade. Can anyone step in and help with the pivot table creation?
You've got to learn Pivot Tables mate, I reckon they're the single most useful thing in Excel!
I wouldn't ever use pivot tables/charts in my regular work -- only here on the forum. That said, I am slowly learning them. It wasn't that long ago that I would not have even recognized that the OP's question naturally fit into what a pivot table can do. I think I am making wonderful progress just starting to recognize the kind of problems that can be solved using pivot tables.
Posting this to raise awareness of the thread and the issue.
http://www.excelforum.com/excel-form...on-2014-a.html
Maybe plus rep to show support?
Would somebody look at this one.
I've proposed that a VBA solution is what OP needs. I don't trust myself VBA. I've taken this as far as I can formula wise. OP inherits data in multiple sheets and must make summary sheet(s) of their own from that data.
http://www.excelforum.com/excel-form...ata-is-in.html
Thanks,
FR
@FlameRetired: VBA solution provided. This consolidates the monthly data into a single worksheet and then bases the calculations on that sheet. It uses SUMPRODUCT with several Dynamic Named Ranges.
Regards, TMS
@TMS
Thank you for looking into this. It was way above my pay-grade.
@FlameRetired: Me too, once. But, you practice, you get better
I have, once again, got myself into a question that turns out to be more about pivot tables than what the original question suggested. The OP has not been able to upload a sample spreadsheet, but can anyone step in and suggest how to get his pivot table to pull out the data he needs? I expect that, once we know how to get the data from the pivot table, creating the chart will be easy.
http://www.excelforum.com/showthread...56#post4071656
Is this possible with a UDF?
http://www.excelforum.com/excel-form...-function.html
@ Tony - not really, the rule of thumb is to not expect a function to actually DO anything
But go ahead and break that rule if you really want
http://www.excelfox.com/forum/f22/br...unctions-1519/
There are a few odd things they can do that I know of: set indent level, add comments, merge and unmerge, add a picture.
I have examples if you'd like to see them.
Last edited by shg; 05-15-2015 at 06:35 PM.
There's an example of indenting with a UDF at http://www.excelforum.com/excel-form...-function.html, and setting a comment at http://www.mrexcel.com/forum/excel-q...reference.html
Last edited by shg; 05-15-2015 at 08:03 PM.
Nope. Found it.....excelfox
http://www.excelfox.com/forum/f22/br...1519/#post7156
Can someone help here pleasze?
http://www.excelforum.com/showthread...77#post4075377
Would somebody look into this one? OP has 1600 cells of array formula. That seemed OK. Then they requested 4 conditional formats to apply to those same cells. These all seem to require more array formulas. I'm out of ideas.
http://www.excelforum.com/excel-gene...arge-data.html
Does anybody know how to connect to Business Objects Central Management Sercer console and extract data ? What are the list of references needed to be added to the Project to connect to InfoStore ?
Sarang
Saarang84, this is The Water Cooler subforum and it's not planned to answer questions.
more over this is Cavalry thread where we seek help for OTHER members, not for ourselves.
Could someone have a look at this thread?
http://www.excelforum.com/excel-prog...-a-button.html
Once we got over the confusion concerning the nature of the request (VBA not conditional formatting...), I know that I can't help . Can you?
http://www.excelforum.com/excel-gene...ell-value.html
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
http://www.excelforum.com/excel-char...ce-charts.html
Does anyone know if it is possible (or if it is impossible) to add a 2nd data set to a 3D surface chart?
Can anyone take a look at http://www.mrexcel.com/forum/excel-q...orrupted.html?
There is a LOT of code in the workbook MyMacros, but the problem is much simpler: there is a compile error for two controls on one of the forms; the control names appear in Intellisense, but the compiler doesn't like them. CodeCleaner didn't work, which surprised me.
I looked at: http://www.excelforum.com/showthread...70#post4092670
Tried helping, but something came up and don't have the time to further help here today.
Hopefully you can pick it up from here
Inveniam Viam Aut Faciam
Hello all
I've been trying to help the OP here:
http://www.excelforum.com/excel-prog...-from-url.html
He wants to display around 900 product images in the workbook but doesn't want to just go to the image URL. Do any of you have any ideas? As regards this I'm at the limit of my knowledge.
Regards
DBY
For some reason this demands a reference to Outlook 15. So, I'm stymied?? Hopefully one of y'all can help.
Just uncheck the reference and add a reference to whichever Outlook version you have.
@ Rory - that worked! Duhhhhh - Thanks
Would somebody have a look at this one. I am stumped. I'm not ever sure this can be done without OP supplies some more structure ...... but I don't even know what it would be.
http://www.excelforum.com/excel-form...low-input.html
Edit never mind. I think I've found something that will work.
Last edited by FlameRetired; 06-14-2015 at 06:55 AM.
This seems to require some knowledge of working with support files. I don't know how. The content is also in French. OP assures us that shouldn't be an issue.
Would anyone like to take a look at this?
http://www.excelforum.com/excel-form...rom-scale.html
Dave
Perhaps someone with a sharper eye and better skills than I have can help this OP... http://www.excelforum.com/excel-gene...-way-help.html
he needs addresses separated but I don't see any consistency between them that you can use to create a formula to accomplish it.
New member needs assistance with Access and Excel...
http://www.excelforum.com/excel-prog...-database.html
VBA solution needed. Way beyond me!!
http://www.excelforum.com/excel-form...omer-name.html
Glenn, when you notice a thread is in the wrong sub-forum, just use the REPORT button on that thread asking a moderator to move it. They can also remove previous posts in a thread to set it back to zero replies so more people can see it on the UNANSWERED THREADS list.
@ JB
I've clicked on that Link several times and have hesitated to use it...it says
Note: This is ONLY to be used to report spam, advertising messages, and problematic (harassment, fighting, or rude) missing code tags, poor thread titles posts..
Need an arrayed formula here
http://www.excelforum.com/excel-form...selection.html
Hi Guys,
I'm stumped as to why something is not working, because as far as I can tell my code just does what the user would do manually, but the results are not working out. I suspect somehow the macro running interferes with the solver addin, but I haven't ever touched on that so I'm a bit out of my league on solving the discrepancy between manual and automated. If someone could help this guy, you may have some insight on what I'm misssing.
http://www.excelforum.com/excel-prog...ew-to-vba.html
When the data is right on the third sheet (which is where the solver works) the results copied are fine onto the 4th sheet, which is intended as "historical" data. But somehow putting in the data and running the solver by calling its macro does not work out.
UPDATE: No problem anymore.... I missed something obvious... a cell was pointing somewhere else, and I didn't compensate. (Dumb Me )
Last edited by Arkadi; 06-26-2015 at 08:49 AM. Reason: Figured it out, simple mistake, feel stupid :(
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Now that I've gotten some off-topic answers in my post, the chances of you gurus seeing the question is greatly reduced. Any help here would be appreciated:
http://www.excelforum.com/excel-prog...in-memory.html
Got a doozy here, chip in if you can. Break out address from a text string....
http://www.excelforum.com/excel-prog...in-spaces.html
I have not used Morefunc yet, if anyone else has, can you offer any suggestions here...
http://www.excelforum.com/excel-prog...ml#post4115913
I took a stab at this one, and it quickly got above my head. I think the question is really more about the logic used in financial calculations and not so much about how to program them into Excel. The functions he is using seem to be calculating correctly. The OP is not sure that the result is really correct, so I suspect someone with a solid financial background (NPV/IRR/cash flow/investment return type problems) to explain whether he is choosing the correct function(s) for the task.
http://www.excelforum.com/excel-form...r-answers.html
Why is this sum(countifs()) not working. It seems to be correct...
http://www.excelforum.com/excel-form...ml#post4120736
Can anyone help the OP with this? It's been almost a month, with not 1 reply
hahaha yeah, I think that may help....
http://www.excelforum.com/excel-prog...f-the-day.html
Easy one, but I am not getting the expected result logic Formula Question
http://www.excelforum.com/excel-form...ax-number.html
Hey Ford,Can anyone help the OP with this? It's been almost a month, with not 1 reply
That thread is marked solved???
2 of us have tried this one. Anyone else have any ideas? They are trying to remove the false values form an array so they end up with an array that only multiplies the true values.
http://www.excelforum.com/excel-prog...umproduct.html
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
This one is all Greek to me.
http://www.excelforum.com/excel-new-...ng-soccer.html
Is there something I am missing with the ChangeLink method here?
http://www.excelforum.com/excel-prog...ink-error.html
I hate to admit I'm a bit stumped by the latest addition to this thread:
http://www.excelforum.com/excel-prog...ml#post4132288
A thread that looks like it was accidentally abandoned, if anyone is familiar enough with FREQUENCY to jump back in:
http://www.excelforum.com/excel-gene...ml#post4097016
Really interesting problem here. Can you guys offer suggestions?
http://www.excelforum.com/excel-gene...mbol-mean.html
Is it just me ... ? This link: http://www.excelforum.com/excel-prog...ard-speed.html
gives me:
Database Error Database error
The Excel Help Forum database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.excelforum.com home page, then try to open another page.
Click the Back button to try another link.
The www.excelforum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
I can't get around the error values in this thread:
http://www.excelforum.com/excel-form...ef-errors.html
@TMS
Not just you...I get the same...actually have had several incidents such as that today...Gremlins...
@TMSNope! I get that occasionally, too. I also get redirected to something called Sucurri (sp?) Cloud. They inform me that the Forum site is down for maintenance. Happens pretty often.Is it just me...?
@FR: I've had that but this one's a bit different ... a database error for a specific thread. Still doing it
Same for me. Trying to access it via http://www.excelforum.com/showthread.php?t=1094694 fails with the same error. Must be something corrupted in the thread content I guess.
Another one ...
http://www.excelforum.com/excel-prog...or-1004-a.html
Can't even report it because it just show as:
Database Error Database error
The Excel Help Forum database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.excelforum.com home page, then try to open another page.
Click the Back button to try another link.
The www.excelforum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
It blew me off too
Interesting turn of phrase
I had thought of making an even more risque comment... but I managed to control myself....
It's 20th Century American vernacular
And what century are we in now?
Hi Trevor,
Welcome to the 21st century (I thought you knew)
That's what I thought ... so I guess you're living in the past
Hey Trevor,
If Space has three dimensions then why not Time?
Ok, you're getting surreal now. And it's not even Doctor Who season
What do you mean "getting"
create any thread with the words "compile 1004"
@vlady
This is what's causing the issue?
Are there other "Key Words"?any thread with the words "compile 1004"
Hi Vlady,
I just put such a thread in the Water Cooler - what gives??
have experiment on title here http://www.excelforum.com/development-testing-forum/
Hi Vlady
I have no issue when I click on this Link...what am I missing?
http://www.excelforum.com/development-testing-forum/
Opps Sorry. Cleaned up the experiment thread titles.
Still the key word affects and gives a database error message.
compile 1004
Hi Vlady
Don't understand...what's the link?