Moving 1 Data Cell into A second Sheet?
 

Hi..has anyone done this before?

I have tried countless tomes to make this work, admitedly I am new t
using visual basic.

But what I am trying to do seems so simple but..

I have a Column of data on my Main worksheet that I want to reflect i
a Second worksheet but into four lines.

Example: In my Master worksheet I have a column of price which A1
$225

When I enter this data I want it to appear in a second worksheet but i
four rows i.e. A1 through A4 (the same amount $225)

It seems so simple but I can not get it to work.

Anyone encounter this,? Any suggestions would be greatly appreciated.
Thank you in advance...Mat

--
Message posted from http://www.ExcelForum.com

Moving 1 Data Cell into A second Sheet?
 

On your second sheet put this in the cells a1 through a4
=Sheet1!A1

"iomighty " wrote in message
...
Hi..has anyone done this before?

I have tried countless tomes to make this work, admitedly I am new to
using visual basic.

But what I am trying to do seems so simple but..

I have a Column of data on my Main worksheet that I want to reflect in
a Second worksheet but into four lines.

Example: In my Master worksheet I have a column of price which A1 =
$225

When I enter this data I want it to appear in a second worksheet but in
four rows i.e. A1 through A4 (the same amount $225)

It seems so simple but I can not get it to work.

Anyone encounter this,? Any suggestions would be greatly appreciated.
Thank you in advance...Matt


---
Message posted from http://www.ExcelForum.com/