I have been trying countless ways to get this to work this week and have
not been successful.

Anyone done this before, even if you have not I appreciate your
interest in helping so many of us on this forum.

What I have been trying to do is to build a worksheet where I can enter
one line of data. And then for this data to translate on a second
worksheet in a desired format.

It seems so easy as a concept but I continually run into dead-ends on
my own.

On my Master Sheet I want to be able to enter:
A1) Copy # Ex. "105"
B1) Invoice Line# EX. "110" *Always the same number
C1) Invoice Rep Ex. "ABCTRANS" *Always the same label
D1) Oty Ex. "1"
E1) Unit Price Ex. "200"
F1) Extended Price Ex. "200"
G1) Date Ex. 31-Jan-04


On a second Worksheet I am trying to get the results from this entry to
translate onto two lines to represent a balanced accounting entry.

So the desired result would be the automatic generation of;

A1) 105
A2) 105

B1) 100
B2) 110 *Every order will generate "Invoice line" 100 and 110 from the
original "110" entry

C1) "No Sales Credit" *This is a constant for this line
C2) "ABCTRANS" *This is what is entered on Primary sheet

D1) -1
D2) 1

E1) 200
E2) 200

F1) -200
F2) 200

G1) 31-Jan-04
G2) 31-Jan-04

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

Thank you in advance...Matt


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