Prev: Hyperlink does not show full address
Next: windows7 excel2007 problems
From: Daryl S on 8 Feb 2010 10:38
Barry -

Record a macro where you copy / paste special values that you want. Then
have the button call the macro you just recorded.

--
Daryl S


"Barry" wrote:

> Using Excel 2003 in Windows XP sp3
>
> My workbook has two worksheets. On worksheet 1 in cell B3 (Named Payperiod1)
> is a date value. On worksheet 2 in cell F9 (Named StartDate) is a date field.
> Using a button called "Pay_Period_1" on worksheet 1 I'd like to assign the
> value in worksheet 1 cell b3 to Worksheet 2 f9 Or something like PayPeriod1 =
> StartDate.
>
>
 | 
Pages: 1
Prev: Hyperlink does not show full address
Next: windows7 excel2007 problems