Frequently Asked Questions



Questions Answered
Click on a question; the answer will drop down.


Click again and the answer will close.

Every day Pamela receives numerous questions from troubled computer and iPad/iPhone users, by email and at various seminars and workshops. Her answers provide advice on a variety of subjects related to computer hardware and software and Apple iPad and iPhones. Listed below are the questions that Pamela feels will be helpful to most users, from beginners to the more advanced.

If you cannot find the answer to your question listed below, ask Pamela your questions here or click on the ‘Ask Pamela’ link on the sidebar menu below the category list. You can also leave Pamela a Message by clicking on the Blue Button at the bottom of the right hand sidebar. Pamela always answers promptly.

Excel Tutorials

How do I link information from one Excel Worksheet to another and have it update automatically?



In order to have Excel data update automatically from one Excel worksheet to another follow the steps below. We will call the Excel worksheet that contains the data you wish to copy Sheet A and Sheet B will be the worksheet where you wish your data to appear:

  1. Open the Excel worksheet (Sheet A) that contains the data that you want to copy to the new worksheet.
  2. Open the Excel worksheet (Sheet B) where you want the data to appear.
  3. Click into the cell that you want to copy in Sheet A.
  4. Press CTRL+C.
  5. Click where you want the information to appear in Sheet B.
  6. On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste Special.
    Excel - Paste Special 7. Then Click on “Paste Link” as shown  Excel - Paste Link

 

 

 

 

 

 

 

 

 

 

 
8. Click OK. Your data will update automatically on Sheet B every time you update data on Sheet A.

If you need help with any Excel problem just click on the blue button on the sidebar to the right of this page and ask your question. I will respond promptly.

I look forward to hearing from you.

 

Can you suggest a formula to deduct an amount from an original sum and continue it down the column?



Excel Column Formula