I would like to populate a cell with a range of data. Example. Data range
A1:A20...I would like to create a macro that when you press a button it
populates cell C1 with cell A1 data, then saves the data, then populates cell
C1 with cell A2 data, saves the data, and so on. Can someone show me how to
accomplish this? Thanks in advace!