www.ultimatehandyman.co.uk

Me again Right heres the problem, i have an excel document which is basically several test sheets on A4 size pages, i can mark page breaks on the page and see exactly what is going to be printed and can select the pages i want to print. All good so far, the problem is i am sending the documents to someone to verify the results , but the results are coming in dribs and drabs, so i do not want to send the full document (upto 10 sheets ) At a time i would like to basically select the pages to send and not all of them . Can anyone help me here? Another thing is how do i convert the excel file to a PDF so it cannot be altered by the recipient .

Thanks in advance

Nick

Maybe I don't understand your question properly, but the only way you can send separate pages is to save them as a new spreadsheet by copying and pasting each page.

As for creating PDFs, I use the free CutePDF

Install it.

Select Print and choose it from the drop-down menu where you select the printer. It then pops up a dialog box to save as PDF.

You can drag and drop it into PDFCreator to convert to pdf, but you would have to save each page separately if you only want to send one page at a time.

you can email a seperate worksheet.

Click the email button on the standard toolbar and you get an option to send the workbook or worksheet.

You can get to this option by FILE->SEND TO->MAIL RECIPIENT

to send several sheets at once you need to do what the others suggested or the best way is to write a bit of VBA code, but if you don't know VBA its not easy. If you can wait til next week I can write something for you.

You need Adobe PDF Writer (not reader) to convert a single worksheet to PDF but you have to pay for that. Not sure is any of the free ones will do the job. Worth a try :

Thanks All, i tried to just copy and paste it from the main folder to a new excel document but the format of the document seems to change totally in size and layout of the columns? i cannot see whats going wrong as i am simply doing the copy and paste option????

I hate office work, give me a manual labour job any day LOL

Nick

What version of excel are you using. It could make a difference

Try "save as" instead of copy and paste.

Have you got Office 2007? That now has a PDF creator built in, or try Primopdf http://www.primopdf.com/

Try a save as and call it something else or try paste special, it may work.

You can copy several worksheets to a new workbook and email that if you prefer. e.g. from the 6 picts below

1. Assume I have an existing workbook with 4 worksheets and I want to email Results A and Results C.

2. Select Results A and Results C worksheet tab, (you need to hold the CTRL button down to multiselect

3. Right Click and Select Move or Copy

4. Ensure you copy to a new workbook, Move is the default action

5. The 2 worksheets will be a new workbook (i.e. new excel file)

6. Email that file to whoever, Selecting Add Attachment will email the file,


... and thats it.

Right back to do a spot of plumbing!

Thanks John, your a lifesaver, i dont think i could hae done it without your help. sometimes a picture speaks a thousand words. Now i have another slight problem i currently have all the pages stored as one workbook all on one tab, one page below the next how can i split up the pages to add them to more tabs so i can use your method above? I bet your getting tired of trying to help me LoL I think i need to go on a course to use excel


Nick

No worrys Nick, why do you want to seperate the pages into different tabs, its not usually done that way.

For printing, you can also hightlight an area and print the selection(FILE->PRINT AREA->SET PRINT AREA), or just copy the area and paste its as text, picture or whatever format you want in Microsoft Outlook, (not outlook express).

If you want to do as you say, i.e. move one page to the next worksheet tab, you can select the first page (e.g. CELLS(A1) to CELLS(I,50)), Right click, select CUT, and paste them into the next worksheet. If you have any formulae, they will be copied also

If this is as clear as mud, let me know and I will clarify it for you