Adding buttons to a work sheet.

**jampy00** · 12-10-2012, 10:53 AM

Hello all,

I need help with adding some buttons to a work sheet that will require some macros ( I assume )

All the information on the works sheet s hinges around unique ID numbers.

I need two buttons on the sheet.

Button 1 - Needs to save as a .pdf using the unique ID number as it's name then clear the work sheet.

Button 2 - Needs to "save as" the work sheet as a new work sheet ( book ) using the unique ID Number and ensuring the .pdf button is there as well.

Thanks, if you need more info just let me know.

**Legend Rubber** · 12-10-2012, 11:03 AM

easy, but need more info... what is the unique idnetifyer?
What cell will it be located in?
what is the range of the number of pages...?

**jampy00** · 12-10-2012, 11:09 AM

Hi Legend Rubber

I'll do my best to answer.

The Unique ID is a numbered range ( CCR0001, CCR0002 etc )
This value will always be in B4 in work sheet 4
The range will always be a single page ( work sheet )

Hope that helps, Thanks !!

**Legend Rubber** · 12-10-2012, 11:29 AM

what Sheet are you saving? Sheet 4?
Can you attach your workbook?

**jampy00** · 12-10-2012, 11:33 AM

Yes, it will always be sheet 4

Workbook attached..

Also see this post: http://www.excelforum.com/excel-form...s-entered.html

as it pertains to the the same sheet in the work book.