Thank you Sam! That's exactly what I wanted.
Steve
On 1/13/2012 9:17 PM, Sam Mathai Chacko wrote:
Regards,
Sam Mathai Chacko
On Fri, Jan 13, 2012 at 10:58 PM, Steve Weaver
<stevebwea...@comcast.net <mailto:stevebwea...@comcast.net>> wrote:
Greetings,
Several months ago I received help from this group on a project to
separate transactions from a single Excel worksheet into three
different worksheets based on the rep number. Your assistance was
and still is very much appreciated.
I would like to improve on this process even more and need further
help. The problem I have is that each month when I create a new
worksheet I lose the headers and footers established for each rep
report along with the report totals on the last page. Please refer
to the attached file. Is there some way to retain the headers and
footers, along with the total on the last page, when creating the
individual rep worksheet? Is it possible to overwrite the existing
rep worksheet, thereby retaining the headers and footers, rather
than creating a new worksheet?
Thank you very much for your help!
Steve
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this
forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a
workbook. Forum owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
