Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design Input, please
A typical 'set' of data is as follows:
Col A B C D E F with headers: Item Description Qty Unit Rate Total and data: M External brickwork 100 m2 50.00 5000.00 this will be followed by another set of data, just a few rows later. The example above would have a rowheight of 12.75. User A creates the workbook and the sets of data (with the exception of values in cols E and F). User B adds these values. User C has to work with their product. What I'm struggling to achieve, is a way to let user C see the 'workings' that led user A to reach the quantity (100), and display that alongside the relevent dataset. In a simple case for the above qty, the workings might be: 2/ 10.00 2.00 40.00 ¬¬¬¬ ' underline 4/ 15.00 1.00 60.00 ¬¬¬¬ ¬¬¬¬¬ 100.00 but this could go on for many rows, before the total is reached. BTW, Cols G:J are reserved for other uses. Could I have a hidden sheet, accessed by a cell in Col K, that would display the workings whilst still also displaying the relevent dataset alongside? Any help much appreciated. Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.548 / Virus Database: 341 - Release Date: 05/12/2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design Input, please
You could use comment boxes. They are hidden and can pop
out when rolled over. Try this Sub Commentator() Worksheets("Sheet1").Range("A1").NoteText _ "2 @ 10.00 x 2 = 40.00" & Chr(10) & _ "4 @ 15.00 x 1 = 60.00" & Chr(10) & _ "60.00 + 40.00 = 100.00" End Sub -IA -----Original Message----- A typical 'set' of data is as follows: Col A B C D E F with headers: Item Description Qty Unit Rate Total and data: M External brickwork 100 m2 50.00 5000.00 this will be followed by another set of data, just a few rows later. The example above would have a rowheight of 12.75. User A creates the workbook and the sets of data (with the exception of values in cols E and F). User B adds these values. User C has to work with their product. What I'm struggling to achieve, is a way to let user C see the 'workings' that led user A to reach the quantity (100), and display that alongside the relevent dataset. In a simple case for the above qty, the workings might be: 2/ 10.00 2.00 40.00 ¬¬¬¬ ' underline 4/ 15.00 1.00 60.00 ¬¬¬¬ ¬¬¬¬¬ 100.00 but this could go on for many rows, before the total is reached. BTW, Cols G:J are reserved for other uses. Could I have a hidden sheet, accessed by a cell in Col K, that would display the workings whilst still also displaying the relevent dataset alongside? Any help much appreciated. Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.548 / Virus Database: 341 - Release Date: 05/12/2003 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |