addressing

Article View: comp.apps.spreadsheets

Article #386

Back to comp.apps.spreadsheets Previous Next

#386

From: karl gauss
Date: Tue, 16 Mar 2004 21:13

14 lines
1464 bytes

i am using quattro pro. on page A, i have a list of names going down
from cell A1 to cell A30. 

on page B, i wish to have the name from page A cell A1 go in cell B:A1
on page C, i wish to have the name from page A cell A2 go in cell C:A1
on page D, i wish to have the name from page A cell A3 go in cell D:A1

and so on. to achieve this, i have been doing the tedious task of
typing +A:A1 into cell B:A1 and then typing +A:A2 into cell C:A1 and
so on. 

is there a fast way to do this?

thanks you experts!

Technical Details

Message-ID: <40576c95.87924662@news1.sympatico.ca>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 107c76,2118e0862845590a,start
X-Google-Attributes: gid107c76,public
X-Google-Thread: f75a7,2118e0862845590a,start
X-Google-Attributes: gidf75a7,public
X-Google-ArrivalTime: 2004-03-16 13:30:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
From: hato@rio.br.com (karl gauss)
Newsgroups: comp.apps.spreadsheets,corel.support.wordperfect8suite.quattropro
Subject: addressing
Message-ID: <40576c95.87924662@news1.sympatico.ca>
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 14
Date: Tue, 16 Mar 2004 21:13:19 GMT
NNTP-Posting-Host: 209.226.147.119
X-Complaints-To: abuse@sympatico.ca
X-Trace: news20.bellglobal.com 1079471709 209.226.147.119 (Tue, 16 Mar 2004 16:15:09 EST)
NNTP-Posting-Date: Tue, 16 Mar 2004 16:15:09 EST
Organization: Bell Sympatico