Export a sheet as a PDF

It takes a few clicks but it is possible

I have previously posted about using CutePDF to create pdfs from Excel sheets. There is another way, but it takes a few clicks and it only works in Excel 2010 and later versions. (It may work in Excel 2007 but I have taken that version off my PC so I can’t test it.)

Excel Cell Comments and Documentation

Macro to Create a Comment Report for a File

I was watching a video a while back and some Excel experts were lamenting the lack of a documentation standard in Excel. They mentioned that the cell comments system could be used for documentation, but there was no way to centralise all the comments. Well, I have written a macro to do just that.

Vote For a New UNIQUE Function

Dynamically extract a list of unique entries from a list

The Excel team has a great site that encourages people to post new ideas for Excel. It also encourages people to vote for the new suggested features.

I have just posted an idea for a UNIQUE function that extracts unique entries from a list.

Currently you have to manually maintain a separate list of entries for a drop down lists. You can’t use a list that contains duplicates for a drop down list.

What if that list was updated automatically via a formula from the original data source? So as new items are added at the data source they automatically appear in the drop down list?

Currently a dynamic solution requires a complex array formula or a UDF (User Defined Function – macro).

This would also make creating formula-based reports so much easier.

Please take the time to vote for my suggestion. Feel free to post your own suggestions as well.

Vote For UNIQUE Function