Entering data in one sheet and have it appear in second Sheet?

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

iomighty

Essentially. I am trying to enter 1 line of data on a worksheet. I the
want this data to reflect the corresponding journal entries

Example: (1 line of data entry, First Worksheet)

Quantity = 1

Unit Price = 100

Date = March 31, 2004


Second Worksheet: (What I am trying to Automate)

Column 1: Quantity
A1 = 1
A2 = 1

Column 2: Unit Price
B1 = 100
B2 = -100

Column 3: Date
C1 = 31-March-04
C2 = 31-March-04




Hi..has anyone done this before?

I have tried countless times 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 two lines.

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

When I enter this data I want it to appear in a second worksheet but i
two rows, i.e. A1 through A2

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

Anyone encounter this,? Any suggestions would be greatly appreciated.
Even if you are unable to help I would like to express my appreciatio
for all of you who lend your knowledge to all of us.

Thank you in advance...Mat
 
A1(Second Worksheet): =First Worksheet!A1
A2(Second Worksheet): =First Worksheet!A1
B1(Second Worksheet): =First Worksheet!B1
B2(Second Worksheet): =First Worksheet!(B1*-1)
 
Back
Top