Fill a cell with a data range

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!

Taking what you said as written, it doesn't make sense. I think the problem
is the nomenclature that you are using. What do you mean when you say
"saves the data"?
Normally, "saves the data" means to save the file. But if you do this after
each time you populate C1, you will end up with a file that has, in C1, only
the last value you put in C1. I don't think that is what you want. Please
post back and clarify what you mean by "saves the data". HTH Otto
"Deeds" <Deeds@discussions.microsoft.com> wrote in message
news:7AF62822-62A2-4016-9717-36B72074B67C@microsoft.com...
>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!