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
.