Excel: How do I set up a cell to click it to link a database?

J

jp@nes

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?
 
G

Guest

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
 
Top