SAVING PART OF SHEET

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I have a workbook that has 5 sheets. I print off a section of sheet 1 and
ideally this is the only part of the sheet I want saved in my archives . Any
idea how I could set my workbook up so that I can save just a part of the
sheet or even only sheet 1 of the workbook?

cheers
gregorK
 
gregork

You can't save part of a workbook.

You can however, copy the sheet or part of it to a new workbook and save that
workbook.

File>New>Workbook

Copy the sheet or part of sheet from original workbook to new workbook.

Gord Dibben Excel MVP
 
Hi Gord!

I use Ron de Bruin's SendMail 3.1 to help perform this trick.

I select the areas that I want in a separate new file and then use
SendMail to mail it to myself.

I can do it for whole sheets or a selection of sheets with various
options.

Clumsy? Yes! But it's very quick and involves little effort.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
gregork

You can't save part of a workbook.

You can however, copy the sheet or part of it to a new workbook and save that
workbook.

File>New>Workbook

Copy the sheet or part of sheet from original workbook to new workbook.

Gord Dibben Excel MVP
Click to expand...
 
Take a copy of the cells you require...
paste values into a new workbook and save.


alternatively

set up a macro to copy the cells you require....
paste values into a new sheet and then delete the sheets not required and
save.

I am not saying these are the best ways to do this but with my limited
knowledge this is how I would go about this!
 
Thanks Norman

I stayed away from Ron's Sendmail because I was using Forte Agent for both
news and email.

Naturally Agent was not recognized by Windows and IE as a valid email program.

I have now relented and just started to use Outlook as default email client so
guess it's time to load the Sendmail 3.0 and give it a whirl.

Gord
 
On Sat, 03 Jan 2004 17:47:36 -0800, Gord Dibben wrote:

Oops! Sorry Ron. Make that Sendmail 3.1

Gord
 
Hi Gord

3.0..3.1
We Always try to make it better Gord

I upload Norman's manual a few seconds ago so even a
Canadian can understand it<vbg>

Good luck
 
Hi Gord!

I was going to say, "Whatever you do, don't read the User Guide!"

In fact the real beauty of Ron's work on SendMail 3.1 and Google
Search 6.0 is that the interface is so intuitive and user friendly.

Need any help translating Canadian into English, don't hesitate to
ask. <vbg>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Harlan!

Strine!?

No fear of that. 8 years of English grammar school with scars to prove
it!

Stupid language. US hasn't gone far enough in removing irregularities.

Give me Bahasa any time.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Gregork,

I was dealing with exactly the same question as you do. I made a
workbook for my company in which people (in sheet1 “hours”) can write
down their working hours.
At the end of the week the sheet is printed and the sum of the hours
is copied to sheet 2 (“totals”).
I want to save the workbook, but only the sheet “hours”, every week
with a unique name, while keeping last week as it is and save the
original book for future use.
This is what I did.
First I made a counter at sheet 1 representing the weekno. (Actually
there is also info about the year and the user)
Say A=year, B=week, C= username, N=name of original sheet. (all
declared as string).
Then I followed the next steps:
1. save original workbook (N)
2. delete sheet “totals”
3. save modified book with name C+A+B.xls
4. open original workbook (N)
These steps can be put in a macro.
5. Close workbook CAB.xls manually. (I do not know yet how to put this
in the macro too)
Now you can continue working in workbook 1.
This is, of course, a very simplified way in which I wrote this down
and there is a lot more to tell about it.
Basically however this is the procedure.

Greetings Harry
 
Back
Top