ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Move data Macro (https://www.excelbanter.com/excel-discussion-misc-queries/98145-move-data-macro.html)

kingcole

Move data Macro
 
I have a bunch of data on one worksheet which is calculated with formulas.
After the data is calculated I want to be able to click a button which moves
the data to another worksheet specifically for results, and then clear the
original data. I want to be able to do this several times, each time storing
the data on the results worksheet so when i'm done changing formula variables
I will be able to print all my results at once.

Zygan

Move data Macro
 

zip an example spread sheet and i will write a macro i will keep
checking this post


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=559504


kingcole

Move data Macro
 
How do I attach a zip to the post

"Zygan" wrote:


zip an example spread sheet and i will write a macro i will keep
checking this post


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=559504




All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com