Call in the Cavalry - 2015

2015- Happy New Year
http://www.excelforum.com/the-water-...4-onwards.html

could you make it sticky please

Originally Posted by martindwilson

could you make it sticky please

All done - Now stuck

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

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

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

I see you're pursuing alternatives but the issue was that

Please Login or Register  to view this content.

won't work on a Mac.

This one will require a UDF or VBA

http://www.excelforum.com/excel-form...in-a-cell.html

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

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.

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

This poster needs help with a pivot table:

https://www.excelforum.com/showthread.php?t=1061056

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

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?

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

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

Anyone want to chime in on this 1?

http://www.excelforum.com/excel-prog...ml#post3977955

Any one here (Subtotal)

http://www.excelforum.com/excel-gene...ml#post3979287

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?!

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?

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.

http://www.excelforum.com/excel-prog...ated-data.html

I'm having trouble interpreting the data here - can you please take a shot at it?

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

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

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

http://www.excelforum.com/excel-prog...its-value.html

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

http://www.excelforum.com/excel-prog...file-type.html

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?

Anybody want to help someone do a waterfall chart?

http://www.excelforum.com/excel-char...tter-idea.html

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

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

Originally Posted by TMS

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

Something is missing

Hi,

Can your amazingly genius minds help me solve my requirement in my thread Partial Match for Group Names ?

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?

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?

http://www.excelforum.com/excel-prog...ting-rows.html

@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

@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

Originally Posted by xladept

@ Tony - not really, the rule of thumb is to not expect a function to actually DO anything

That's what I thought too until someone at some place posted examples of UDFs that do DO stuff!

Can't remember where or when or what they did.

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.

Originally Posted by Tony Valko

Can't remember where or when or what they did.

Might have been the private MS MVP forum.

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

Originally Posted by scottiex

But go ahead and break that rule if you really want

http://www.excelfox.com/forum/f22/br...unctions-1519/

Isnt that what this post links to?