Questions

Questions people email in will go here.

Question:
What I would like to be able to do is tie the two worksheets together so that when I change a quantity on one page it will change the similar cell on the other page. I believe this is possible but I do not know how to do it or what to call it.

Answer:
The name of what you will be doing is called "Create a link to a cell in another workbook".  Its easy to do, a little awkward to explain.  Its almost as simple as linking to another cell in the same worksheet.  Example "=B2".  However you need to add the name of the 'source workbook' into the destination excel field.

Here is a example of linking to another workbook:

"=[EBAY Bookkeeping.xls]Sheet1'!$C$7."

Notice that the source workbook name is in brackets "[" and "]" followed by the source sheet name "Sheet1" followed by the specific cell info, the "$" make the focus lock on the row and column.

Depending on your version of Excel , this can also be accomplished by "PASTE SPECIAL - LINK" , copy the cell in the source workbook and then paste special - link in the destination cell.

This should be enough to help you get on your way.  If you have follow up questions please include the version of excel that you are using.