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 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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