Export macro to a new sheet

[zepelin]

http://www.excelforum.com/excel-form...new-sheet.html

http://www.excelforum.com/excel-form...-next-row.html

I am new to this forum and i didn't see the form about macro. I need to make the above formula export data to a new sheet. Anyone an help?

[AB33]

I have adjusted the code, so that the output of the macro would be on a separate sheet, not on sheet1. The name of the sheet is called "Result", but you can easily change this name to your needs.

Please Login or Register  to view this content.

[mike7952]

No need to open new threads. Give others a chance to answer or you can reply to the orginal thread *Bump* to bring it back to the top of the board. I gave a solution to your orginal post here. http://www.excelforum.com/excel-form...-next-row.html

[AB33]

Mike,
If you had given the OP a solution, why is the OP has requested again? I have not touched, or amended your code, only added few lines at the bottom.

[zepelin]

Thank you Mike. I don't know the time zones in florida and i assumed you were sleeping