Excel Camera tool
The excel camera tool can be used to show the snapshot of a particular section from one sheet in another...
On Excel
Making excel useful for all. Practical implementation of tips ,tricks and methods. Macros for easy automation and to solve real life problems and scenarios
Get Unique values in MS Excel
How to get the unique values in MS Excel Or How to get only unique records out of a column...
Extract everything after a character in MS Excel
How to get everything after a character from a cell value. For e.g if we want to get everything after...
Get Filename in MS Excel
How to get filename in excel We may need to get the sheetname or the filename of the current excel...
Get cell address in MS Excel
How to get the various format of a cell address in excel Sometimes we may need to get the address...
