Saving data in pull down lists?

N

NervousFred

Is it possible for Excel to save the old number of a cell into a pull down
list when another number is put into the cell?
 
N

NervousFred

Gord,

This works good, but now I have another issue.(The issues never stop)

If I input a value into the table I am importing into excel and then refresh
the table the value I just put in is overwritten by the incoming data. Is it
possible to "lock" a value into a cell that is in an imported table so that
when I do refresh the table the value remains constant?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Auto update of daily web data into excel 3
Font Color in Pull Down Menu 1
Can a formula do this? 1
Can I pull 2 different data tables into one pivot table 1
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
How to create a pull down lists? 1
Populating a form from a spreadsheet 2
Help with Cell Formula 1

Top