This is the first in a series of Worksheet 6.2 articles. I will cover some of the basics to getting your new Worksheet up and running as fast as possible. My main aim is to share with you the work I have done so that you can be very familiar with the process. Here we go…
The first thing you need to do when creating a Worksheet for Excel is to get your graphing capability sorted out. Even though the worksheet does all the legwork, I still find it useful to have the graphing capabilities. So firstly, you should open Excel and then go to File, New, and then use “Graphing” to create a new worksheet.
As far as I know, you are able to create any desired type of graphing capabilities, so my recommendation is to go ahead and make this type of worksheet. It is generally the quickest way to start.
Once you have created the graphing capabilities, you need to copy everything that you will need to type on this worksheet. There is some code that goes into the text box that you create. You will need to read this code before typing anything on the worksheet.
So firstly, you will need to copy everything that is in the text box that you created, including the text boxes that show up when you use the graphing capabilities. Then, you will need to use the following code to copy everything you copied into a new text box:
This will print out a series of numbers in a row and then copy them to a new text box. You then need to paste the text box in front of the output value of your new worksheet. By doing this, you will be able to use this worksheet later on in order to move the data between worksheets.
Next, you need to create a new worksheet. The new worksheet needs to be named different than the old worksheet. This will be the index number of the new worksheet.
After creating the new worksheet, you will then need to copy the cell references from the old worksheet, and paste them into the new worksheet. This is basically copying the formulas from the old worksheet into the new worksheet. Finally, you will then need to set the two worksheets up so that they are compatible.