Copy Data One Sheet to Another

Solved/Closed
kaluputha Posts 5 Registration date Friday February 19, 2010 Status Member Last seen March 2, 2010 - Mar 1, 2010 at 09:43 AM
kaluputha Posts 5 Registration date Friday February 19, 2010 Status Member Last seen March 2, 2010 - Mar 2, 2010 at 07:58 AM
Hello,
dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data date wise i have enter to sheet 2.at the moment I'm doing it manually.it is possible to make macro something to do that,pls advice to me.thanks.

my first data sheet...
http://img24.imageshack.us/img24/6711/85012856.png


my second data sheet...
http://img193.imageshack.us/img193/8494/60008434.png

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 1, 2010 at 01:03 PM
Your 2nd image does not load but what you want to is very doable. In face why even copy the summary to other sheet. In the other sheet you could have formula that would do the summary.
If for some reason you do want to have a macro do it, even that would be possible. I would suggest use macro recorder to see how easily you can accomplish it.
0
kaluputha Posts 5 Registration date Friday February 19, 2010 Status Member Last seen March 2, 2010
Mar 2, 2010 at 07:58 AM
Thanks for your idea friend.i have make formula in sheet no 2 & now my problem is solved.
0