Joe Grech wrote:
Hi
Re my query to paste selections from different sheets onto a single sheet using
Paste Special and even the Link option is checked the paste worked OK but no
link was created. What have I done wrong?
Try this. Put your cursor on a blank page.
1. Type an equal sign but do not enter RETURN yet,
2. click on the tab of the sheet that you want a duplicate entry,
3. click on the cell that you want duplicated,
4. press RETURN
5. You will be instantly returned to your (formerly) blank page with
the entry duplicated.
6. Duplicate this process as required. You can merely copy your newly
duplicated cell which contains now a formula to the surrounding area for
the rest of the area you want to appear on your duplication page. The
formula in each cell will be automatically adjusted to correspond to the
source cells.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
