in the following, the counter - which determines the row
the historical data is entered - is maintained in cell
(1,30). The data you wish to periodically record is in
cell (10,1). when you run this macro, the data is
recorded in the next cell of row 3.
:-)
Sub recordhistory()
etcount = Cells(1, 30).Value
etcount = etcount + 1
Cells(1, 30).Value = etcount
trapdata = Cells(10, 1).Value
Cells(etcount, 3).Value = trapdata
End Sub
-----Original Message-----
I keep track of pricing info in a spreadsheet. I would
like to "click on a
cell" to be directed to somewhere that I can keep a
(purchsase) history
attached to that cell. Any ideas how I might be able to
do that?
.
|