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...
my second data sheet...
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.