I have a list of prices. I want a macro that when a button is pushed, the data will go from one cell to another. However, I have 10 rows at the top of the page. I want to price to go into the last blank cell of those ten rows....that is if a price was already in a cell, it would fill the new data into the one below it.
I know it has to be some sort of "if" "then" code, but I am in way over my head!