(Msg. 1) Posted: Mon Aug 18, 2008 9:28 am
Post subject: Save Workshetts as Separate Files Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I have 3 weekly reports that must be sent to 3 different goups. I have each
as a separate Excel template. To fill them out, I have to open 3 instances of
Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
save each worksheet as a separate file for the purpose of sending the reports
to the right goups?
(Msg. 2) Posted: Mon Aug 18, 2008 5:38 pm
Post subject: Re: Save Workshetts as Separate Files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Elvis
Right click on sheet Tab>Move or Copy>Select Copy>use dropdown on To>New
Workbook
--
Regards
Roger Govier
"Elvis" <Elvis RemoveThis @discussions.microsoft.com> wrote in message
news:266BA62C-E15F-4871-BCCE-94505F24F829@microsoft.com...
> I have 3 weekly reports that must be sent to 3 different goups. I have
> each
> as a separate Excel template. To fill them out, I have to open 3 instances
> of
> Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
> save each worksheet as a separate file for the purpose of sending the
> reports
> to the right goups?
(Msg. 3) Posted: Mon Aug 18, 2008 6:35 pm
Post subject: Re: Save Workshetts as Separate Files [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Elvis
You can use a macro to mail every sheet to the correct group.
"Elvis" <Elvis RemoveThis @discussions.microsoft.com> wrote in message news:266BA62C-E15F-4871-BCCE-94505F24F829@microsoft.com...
>I have 3 weekly reports that must be sent to 3 different goups. I have each
> as a separate Excel template. To fill them out, I have to open 3 instances of
> Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
> save each worksheet as a separate file for the purpose of sending the reports
> to the right goups?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office