Correct a #REF! error

This error occurs when a cell reference is not valid.  This error within the Mystery Shopping Bible© is commonly seen when a row is deleted from the Assignments worksheet.  As a result, the corresponding row on the Payments worksheet will reflect the #REF! error.  This error happens because the Payments worksheet no longer has the proper cell references to draw data from, since it was deleted from the Assignments worksheet.  This is exactly the reason that no rows should ever be deleted from the Mystery Shopping Bible©.

To correct this problem, you can delete the rows on the Payments page that show the #REF! error.  This will normally resolve the problem.  However, sometimes, the formulas will be off as a result of the row that has been deleted, so check the formulas, or contact me for assistance.

 

Should you have a need to remove an assignment from your the Mystery Shopping Bible© simply delete the data within each cell of the assignment row, or just type a new assignment over it.  This will avoid any unnecessary errors.

 

Back to Top

Some messed up formatting in a column

If a few cells in a column had the formatting messed up (for instance, your dollar amounts do not display 2 decimal points, they round to the nearest whole dollar in a few cells) you can easily fix this by copying a cell in the same column that has the proper format and pasting to the cells that show the wrong format.

• Select the cells you want to copy.

• Click EDIT > COPY

• Select the cells you need to correct (you can select multiple cells)

• Click EDIT > PASTE SPECIAL.

• Select FORMATS

• Click OK

Back to Top

Hide the worksheets you don't use

There are probably worksheets you do not use within the Mystery Shopping Bible© so don't delete them, just Hide them and keep them out of your way.  If you record your mileage like I do, on the Payments worksheet, there are 2 worksheets you can hide.  These 2 worksheets were created in v5 upon request from several shoppers that record their mileage by day rather than by assignment.  Those two worksheets are Mileage and Report-Mile2.  To hide a worksheet just do the following, and when you want it back, just unhide it!

• Select the worksheet you want to hide by clicking on the worksheet tab at the bottom.

• Click FORMAT > SHEET > HIDE

The worksheet is now hidden.  Complete the same steps for any other worksheets you want to hide.  If you find you need a worksheet you have hidden, simply unhide the worksheet or worksheets you need.

• Click FORMAT > SHEET > UNHIDE

• The UNHIDE dialog box will appear listing all the names of your hidden worksheets

• Click the name of the worksheet you want to unhide

• Click OK

your worksheet is now unhidden and available for you to use!

 

Back to Top

Taking a "screenshot"

Taking a screenshot is often helpful, so it is something that you should know how to do.  Especially for those of you that may have had the need to contact an IT department.

 

There is specialty software for this, however all versions of Windows allow you to do this without any extra software.

 

There is a key called PrintScreen (or some similiar version, such as PrtScn, PrntScrn, or another combination of these letters).  This key can normally be located to the right of the F12 key.  For my keyboard, the F Lock must be in place, otherwise I get the "(" symbol.

 

If you have multiple windows up on your screen, make sure to select the program, web page or whatever you want a screenshot of.  Once you press the PrintScreen key, the image on your computer is placed into your system clipboard.  You can then paste this image into email, or any other document.  If you only need this image once you can just paste it wherever (your email or document).

 

If you want to capture a dialog box or window, press the ALT key while pressing the PrintScreen key.

 

Back to Top

How to record a shop that is cancelled

Cancelled shops. Now there are a few different ways to look at how to do these.

• You can delete the entry (NOT the row) so it no longer exists. To do this you can select (on ASSIGNMENTS) Columns B-R (MS Company – Reimbursement Amount) of the row that has the shop you are canceling.

• You can also list CANCELLED in Column I (Mall or Shopping Center Name). And to ENSURE that the shop does NOT display as a shop you need to do, enter the date you cancelled the shop in Column C (Shop Date). I would also suggest using Column O (Special Instructions) to make notes about your cancelled shop, which include the date (which will match what you have in Shop Date) and whom you spoke with to cancel your shop. I also like to include the Fees for the shop in this field also. One thing that is VERY important is you do your cancelled shops in this manner, Change the amounts listed in Columns P, Q and R (Shop Fee, Bonus and Reimbursement Amount) from the amounts you listed to 0. Otherwise the cancel date you listed in Column C (Shop Date) will show you are due money on your PAYMENTS worksheet.

Back to Top

How to set the Print Area on a page

You can choose exactly what you want to print. You can do the following:

Print all or part of the worksheet. You can choose exactly what you want to print. You can do the following:

Print all worksheets in your workbook

1. Click Print on the File menu.
2. Under Print what, click Entire workbook.

Print one or more worksheets

1. Click the worksheet(s) you want, and then click Print on the File menu. (Tip:  Hold down CTRL to select more than one worksheet.)
2. Under Print what, click Active Sheet(s).

Print a portion of a worksheet

1. Select the data you want to print, and then click Print on the File menu.
2. Under Print what, click Selection.

If you plan to print a specific portion of a worksheet frequently, you can define it as a print area. That way, every time you print the worksheet, Excel prints only the data specified in the print area.

• To set a print area, select the data you want to include in your printout, point to Print Area on the File menu, and then click Set Print Area. (Note:  You can only set one print area at a time. To clear a print area, point to Print Area on the File menu, and then click Clear Print Area.)

Back to Top

Can I use the MSB on my Mac?
I use a PC personally, and right now I am using the Public Beta 2 Version of Microsoft Office 2007.

• I have MS Bible owners that use Office 2003, Office 97, Open Office (not all the advanced features are available, but it IS a free program), and even some Mac Users.

  A new MS Bible Owner that uses a Mac provided me with more details, which will hopefully help some of the Mac users out there that are unsure whether or not they could use the MS Bible with their Macs.

• Mac OS 9 (Operating System) using Office 98 for Mac.  It probably also runs on Mac OS X with the Office 2004 for Mac.

Back to Top