On the second sheet
a1) =Master!A1
a2) =Master!A1
b1) 100
b2) =Master!B1
C1) No Sales Credit
C2) =Master!C1
D1)=-1*Master!D1
D2)=Master!D1
E1) =Master!E1
E2) =Master!E1
F1) =-1*Master!F1
F2) =Master!F1
G1) =Master!G1
G2) =Master!G1
--
Regards,
Tom Ogilvy
"iomighty " wrote in message
...
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/