Fill a cell with a data range

G

Guest

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!
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto fill cells with text if value of one cell meets specificcondition 3
Blank cells problem 5
Entering Values in a Single Cell to Update Next Empty Cell in a Ra 3
Save cell location to a variable 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Tranfer data from Excel to word (Docx) via VBA in Excel 5
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Need Countifs Formula Help 0

Top