Copying a Worksheet into another Workbook

How to make a copy of a Worksheet from the current Workbook to another Workbook? Open the Target Workbook, when the Source Workbook is already in open state. (adsbygoogle = window.adsbygoogle || []).push({}); Right-Click on the Source-Worksheet Tab. Select the Move or...

Read More

Data Validation in Excel

Excel Worksheet Cell accepts values of any data type viz. Text, Number, Date/Time or expressions (result values can be any of these types).  Worksheets are the best tools for What…If analysis and present numerical data in Graph Chart form.  Besides all these we can...

Read More

Display 12 Months Charts in one Chart Object

I know, we need some details on this to start with.  Since, this is all about Graph Charts I will present some data for our chart below then go into details about the whole project.  Here is the image of sample Chart prepared using the sample data shown above the Chart: The...

Read More

Welcome Message in Application

Let us try a small trick with VBA.  How about a welcome message pops up automatically when you open your Excel Workbook and a Goodbye message before closing the Workbook? We assume that you are using Microsoft Excel 2007. Open one of your existing Excel Workbooks or create...

Read More

Displaying Worksheet Formula

Worksheets can have hundreds of  formulas linked to one another.  Output value of one cell formula can become part of another formula in another cell.  When worksheets of this type involves in complex analysis tasks it becomes difficult to track the relationships between formulas in cells or range of cells, especially when cell references...

Read More