Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
Hi Tom, I wanted to thank you in advance. I just read your message an
going to try your suggestion. ASAP. I can't tell you how appreciative I am of your time and advice. Thanks again, Mat -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
iomighty,
I beleive you had a similar post on June 2. Did that post help you? Charle -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
Hi Charles,
Ya this is a second post of my original problem. Thanks for origina post. I attempted to make it work but I ran into problems..hence th above post. I wanted to say an appreciative thanks for your help an advice. I am going to try the above suggestion as soon as I get a fre moment here. Enjoy the weekend, Mat -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering data from one worksheet to another | Excel Discussion (Misc queries) | |||
Excel 2007 crashes on entering data in a specific range of cells | Excel Discussion (Misc queries) | |||
Entering the same data on more than one worksheet | Excel Worksheet Functions | |||
Entering 1 line of data values that will show up in a second Sheet? | Excel Programming | |||
Entering data into more than one worksheet | Excel Programming |