Hi,
Have you tried to use Update value on another sheet

Also look at Help with a series of default values
Hope these put you in the right direction
Steve
Hi,
Have you tried to use Update value on another sheet

Also look at Help with a series of default values
Hope these put you in the right direction
Steve