Pages

Sunday, January 29, 2012

My Menu ver 1.0 - Insert Formula

Insert Formula



1 Sheet Name - It will insert the formula to show sheet name in active cell. ( Note Will work in saved workbook only)

2 FULL Path -It will insert the formula to show the path of active workbook. ( Note Will work in saved workbook only)

3 Workbook Name - It will insert the formula to show the active workbook name . ( Note Will work in saved workbook only)

4 Workbook Path -It will insert the formula to show full path of workbook . ( Note Will work in saved workbook only)

5 Todays date - will add formula to show today's date

6 Current Time - will add formula to show current time

7 Todays Day - will add formula to show today's day like sunday ,monday etc

No comments:

Post a Comment