Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving certain data to different sheet | Excel Discussion (Misc queries) | |||
moving data from one sheet to another | New Users to Excel | |||
Moving data from one sheet to another- How to? | Excel Worksheet Functions | |||
Moving row data to another sheet | Excel Programming | |||
Moving Data from one sheet to another | Excel Programming |