Hi Joe,
if the rows are exact too, just go to cell A1 in sheet 2 and enter the following :
=+Sheet1!A1
or
=+Sheetname!A1 (where sheetname is the name of your first sheet)
then drag the formula over your other 9 columns and drag it down as far as is required.
(by dragging, I mean position your mouse pointer on the black box at the bottom right of cell a1, the pointer should turn into a "+" then left click and drag over/down as far as you want.
is this what you had in mind ?
Chris
Thanks Chris,
It works but it loses the format of the cells (like shading and wrap text). Is there any way to do it so it copies everything, including the format?
Thanks Chris,
It works but it loses the format of the cells (like shading and wrap text). Is there any way to do it so it copies everything, including the format?
Aladin -
I used your code and it gives me an error. Says something about a circular reference. Please help again.
My reply seems to have got tangled up in another thread so here goes again-
Select the cells you want to link, copy them and paste special- paste link to where you want them to be. Paste special again and choose the 'Formats' option- this should preserve your formatting from the original sheet, although in my experience, word-wrap is a law unto itself :).