Most common question/answer

[Domski]

Jonmo,

Quite a cool little collection in such a short time and although I've not read it verbatum I like where you're going.

From a personal opinion I think something like this needs to be constructed as a series of 'articles' rather than as an ongoing set of posts on a thread. Those ideally could then be refined, added to and updated over time as new thoughts are come across.

I don't consider my knowledge to be sufficient to be able to write de facto guides to best practise in Excel but would be keen to be able to review and, hopefully, add to such a source of information. I'm sure between us we could come up with a truly fantastic source of information for all Excel users.

One of the truly great things about Excel is that there are so many alternative ways to achieve the same thing and many of them have their place under different circumstances.

I guess what would be the ultimate goal would be something along the lines of the Excel Wiki that was attempted and sadly never really worked, due to outside influences I seem to recall.

Top idea anyway and worth some serious consideration.

Best wishes,

Dom

 

[Jonmo1]

I will definately be working on this some more, to clean it up. But I like Domski's idea of having Each common problem it's own thread, with one master thread linking to each individual one.

Perhaps at least have it one thread, but the initial Post #1 is an Index, and then each problem/solution is it's own post #. Then Post #1 can index/link to each individual Post (problem/solution).

 

[Jonmo1]

I protected my sheets but now my macros don't work

Could you use UserInterFaceOnly:=True?

Yes, but I'm not a big fan of that. Because that setting doesn't get saved when you close/reopen the book. So when you close the book, then reopen it, it's not set to UserInterFaceOnly anymore.

You could do that with a Workbook_Open Event, But I'm just not a fan of it. But in the interest of the goal of the thread, I'll add that in.

Thanks.

 

[Gerald Higgins]

I like what you've done jonmo.

Some suggestions for other topics which I think are very common problems
Conditional formating
Date / Time problems
Text formulas, for example splitting second names from first names, stripping out leading characters, and so on.

 

[schielrn]

This question comes up a ton too:

http://www.mrexcel.com/forum/showthread.php?t=318073

How do I make a tab name based off a cell value or even file name for that matter sometimes.

 

[NateO]

Yes, but I'm not a big fan of that. Because that setting doesn't get saved when you close/reopen the book. So when you close the book, then reopen it, it's not set to UserInterFaceOnly anymore.

You could do that with a Workbook_Open Event, But I'm just not a fan of it. But in the interest of the goal of the thread, I'll add that in.

I'm well aware of this and I don't use that, either, because it's not static, althought I can understand why it's not (consider code run from a 3rd party, from a 2nd Workbook). Event-driven procedures are cool, but I don't necessarily use them when it's just as easy not to.

 

[xyzabc198]

Also worth explaining <> 1 because I used to think this would mean it is one, not it's not one (due to being less or greater than) How did I come to the conclusion it meant 1? An I.T. specialist told me in a training seminar...

*mumbles* stupid....waste of mon...why did the...*groans*

 

[onlyadrafter]

Hello,

I also thought about this a while ago,

http://www.mrexcel.com/forum/showthread.php?t=289126

and while I think it is a really good idea. In the end, the Microsoft Excel help will be re-written, as most of the answers/solutions here are better than the help file (IMHO).

 

[Yokiboha]

Alright, It's ON !!

I'll start working on it right now.

Anybody out there have suggestions for common problem/solutions to add to it?

Reverse lookup? i.e. using VLOOKUP to find values in columns to the left?

 

[Jonmo1]

Reverse lookup? i.e. using VLOOKUP to find values in columns to the left?

That's a good one. Thanks