Can you help me with this macro challenge?

E

excelgrrl

Joined
Jan 23, 2008
Messages
2
Reaction score
0
Is it possible to have a macro copy a range of cells (A1:K1) and place it in the next empty row?

My first row has formulas in it to grab information from a separate sheet within the same workbook with special formatting so I can import it into another program.

What I want to be able to do is take that first row, use my macro button to copy and paste (only the text not the formulas) the information into row 2, then when the information changes in row 1 with new information (from the other sheet) it will copy and paste the new information into row 3 and so on.

Is this possible?
 

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

Please Help Me with this Macro 0
Changes in How Code Acts After Upgrade of Excel 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Macro to copy and paste row 8
Auto Update a sheet through Macro 4
Macro will copy formula instead of value 6
Keeping formulas on an insert 1
VBA macro guru help needed! 1

Top