Can you help me with this macro challenge?

excelgrrl

New Member

Join Date: Jan 2008

Location: Iowa, United States

Posts: 2

23rd Jan 2008

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?

« record the maximum value in a cell | check if excel sheet in manual calc mode »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complicated Macro - Someone please help.....this will definetly be a challenge!!	Stuart	Microsoft Excel Programming	6	1st Nov 2006 07:26 PM
I'd love you if you could solve this macro challenge!	Jenna	Microsoft Excel Worksheet Functions	2	17th Sep 2004 11:07 PM
Another interesting macro challenge!	danison	Microsoft Excel Misc	5	9th Jun 2004 01:05 PM
Macro Challenge!	posborne	Microsoft Excel Misc	5	12th Jan 2004 05:30 PM
Macro challenge	Gregg G	Microsoft Excel Programming	0	10th Oct 2003 07:44 PM