View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iomighty iomighty is offline
external usenet poster
 
Posts: 1
Default 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