Mel pretended :
I have a spreadsheet with 2 tabs. 'RATE-REVISION' and 'RATE-
REVISION-070'.

Cells G3, F5, J5, N5, P5 are set to copy directly to the same cells
int he Rate-Revision070 sheet.

Cells C9 to F88 are completed along with cells H9 to K9 are also
completed (if there is data to complete). Cells L9 to M88 have the
work week pre-filled but may be changed if required. These fields
would also be copied to the Rate-Revision070 tabl

All fields are exactly the same in both sheets.

I also have another macro that is set to a 'clear button' to clear the
fields in either sheet. Cells F9 to F88 has a formula that is pre-
filled by the clear macro.

I had tried to set up a macro that would do this automatically but I
have not been sucessfull. Any help would be appreciated.
thx

Mel

Did you try doing it manually with the Macro Recorder running?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc