Moving 1 Data Cell into A second Sheet?

  • Thread starter Thread starter iomighty
  • Start date Start date
I

iomighty

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
 
On your second sheet put this in the cells a1 through a4
=Sheet1!A1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering 1 line of data values that will show up in a second Sheet? 1
Excel 2013 Merge Data 2
Need Macro... 8
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
OFFSET LOOKUP function in VBA? 9
Loop to hide sheet based on cell 1
Entering data in one sheet and have it appear in second Sheet? 2

Back
Top