I have some thoughts about making a command,button or whatever that can ease my pricelist adjustment job.
I have a price list of about 1000 rows. At the end of each row I have a cell with the actual price for the actual periode. The thing is that I update some of these prices once or twice a month. But now i want to add a new column where I type in the new price as I get it. Then when I have all the prices I need I was thinking about using a command button that will insert the new prices, that I have typed in, into the cells for the old prices. Like an update/refresh button actually.
Is this in anyway possible? Do you excel pro's understand what I want to do?

All answers appreciated