help with formula

[Tim]

Here is the answer of my question sent to Google on 2003-
07-15 00:41:33 PST :
""" Tim wrote in message:

I've got a workbook with many worksheets on it(about 60). On 2 columns
on a sheet in this workbook i have data and i need to export this data
to particular cells in other worksheets. For example on columns A1:A20
and B1:B20 on a worksheet is my data and I want to export the contents
of cells A1B1 to cells A1B1 in worksheet1 then data from A2B2 to cells
A2B2 in worksheet2 and so on.
What is the easiest way to do this job?

Tim

If the data you want to export is located at Source!
A1:B20 and you
want Source!A1 to appear at Worksheet1!A1, Source!B1 to
appear at
Worksheet1!B1, Source!A2 to appear at Worksheet2!A2,
Source!B2 to
appear at Worksheet2!B2, etc., enter the following in the
destination
cells:

=OFFSET(Source!$A$1,ROW()-1,COLUMN()-1)

Allan Rogg """


I appreciate very high Allan's help and I wish him
happiness all his life but unfortunately I've made a
stupid mistake in my question and
the above formula is not exactly what I needed.

I'll try to explain my question again as much simply as I
can:
In fact I need to export only the data stored in column B
in the source sheet to the other sheets in this order:
Cell B1 from the source sheet goes to cell B1 in Sheet1;
then cell B2 from the source sheet goes to cell B1 in
Sheet2; then cell B3 from the source sheet goes to cell
B1 in Sheet3 and so on.

I also want to send my thanks to Jason Morin for the
answer of my question sent to this group on 7/10/2003.
Jason your answer was exactly what I needed.
THANK YOU MY FRIEND!!!