Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: How do I set up a cell to click it to link a database?
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? |
#2
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
excel locks up after selecting a cell | Excel Discussion (Misc queries) | |||
I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
Undoing LINKS in Excel 2000 | New Users to Excel | |||
Excel formatting of text-- one cell needed | Excel Discussion (Misc queries) |