Need a Macro to copy text from a row and paste it in a empty row below in the same sheet

[kalidindi]

Hi,

I have data from A7 to J7 which consists of formulas and data derived from it, i want a macro to copy only the values to row A14 to J14 and clear the contents(not the formulas) from A7 to J7 and keep it for next set of values to be calculated. The next time the macro is run the data has to be copied into A15 to J15 and so on...Plz help on how to create a macro..

[Doc.AElstein]

Hi
This sounds fairly easy and there are probably lots of ways to do it

( Note when clearing, I would expect you just clear the calls containing values used in those formulas. Then the formulas will “clear themselves “ of a value. )

You need to give us some more detail and some test data to work on.
Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
Show us clearly what you have and the results you want to achieve.
Please do not use images as we cannot copy them to a worksheet.
Instead:
Either
use the Add-In Linked in my signature or similar tools to produce screenshots that we can copy.
http://www.excelforum.com/the-water-...ml#post4354756
http://www.excelforum.com/suggestion...d-data-17.html
http://www.excelforum.com/showthread...t=#post4354867
http://www.excelfox.com/forum/showth...=9804#post9804
http://www.mrexcel.com/forum/about-b...rder-help.html
http://www.mrexcel.com/forum/about-b...nstalling.html
http://www.forumexcel.it/forum/16-te...ce-bb#post1576

Collection of codes here: After selecting a Spreadsheet range run the main code in any of the modules:
https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9

Basically to use those tools you highlight the part of your Spreadsheet of interest, and then run the code which copies that screenshot in a BB Code Tag type format into your Clipboard. You then paste that into the Post Editor window. When posted it comes out in a formatted table. Practice using those tools in our Test Sub Forum. To do that start a “test” thread here and practice!!!
http://www.excelforum.com/development-testing-forum/

_....
or
Upload a File
http://www.excelforum.com/the-water-...his-forum.html
http://www.excelforum.com/tips-and-t...le-upload.html
http://www.excelforum.com/excel-prog...ml#post3927818


Alan