Copy Data One Sheet to Another

[Solved/Closed]
Report
Posts
5
Registration date
Friday February 19, 2010
Status
Member
Last seen
March 2, 2010
-
Posts
5
Registration date
Friday February 19, 2010
Status
Member
Last seen
March 2, 2010
-
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 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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.
Posts
5
Registration date
Friday February 19, 2010
Status
Member
Last seen
March 2, 2010

Thanks for your idea friend.i have make formula in sheet no 2 & now my problem is solved.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!