I have a huge data sheet that is being updated every week. It has about 2,000 colums and 6 rows.
Every cell each week is new (Its a list of average prices, so the names of the items remain the same but the prices fluctuate.)
However, there are about 100 prices that have to be the same each week. I need to be able to copy and paste these values in without deleting the other values.
So when copy and pasting a chunk of the sheet with a few numbers scattered within it, the blank spaces do not replace existing values when pasted in.