Copy Formulae to last row

[JV0710]

Please can I get some help on the below query.

I have a spreadsheet with about 120 rows of data ( Currently ). Rows 1:5 are headings.

from Row 6 - Some of the columns are for the user to enter data and others are formula.

The user can enter data in all the unlocked cells ( certain columns - affectively adding records ).

I would like a macro that - after the user has entered new data - unlocks the sheet, copies all formatting ( including conditional formatting) from row 6 down to the last row, and then copies all formulae ( cells that contain formulae only) from row 6 down to the last row. sort the data from row 6 to the last row ( sort on column C Ascending) , and then locks the sheet again.

The Last row is based on there being a value in Column A ( from row 6 )

I hope this explanation makes sense

Thanks, I would appreciate any help on this.

 

[JV0710]

Sorry, I have added one more thing that the macro should do:



I have a spreadsheet with about 120 rows of data ( Currently ). Rows 1:5 are headings.

from Row 6 - Some of the columns are for the user to enter data and others are formula.

The user can enter data in all the unlocked cells ( certain columns - effectively adding records ).

I would like a macro that - after the user has entered new data - unlocks the sheet, copies all formatting ( including conditional formatting) from row 6 down to the last row, and then copies all formulae ( cells that contain formulae only) from row 6 down to the last row. sort the data from row 6 to the last row ( sort on column C Ascending) , after the sort - select rows 7 to last row and copy-paste special-values, and then locks the sheet again.

The Last row is based on there being a value in Column A ( from row 6 )

I hope this explanation makes sense

Thanks, I would appreciate any help on this.

 

[JV0710]

Re: Need Macro - Copy Formulae to last row . . . and . . .

Good day

Sorry to be rude . . . but i am desperate for some help on this

Thanks

JVN

 

[JV0710]

Good Day everyone

Okay . . . this is my last plea for help with this . . . and then, I will leave it alone

Please if anyone can help me I will appreciate it

Thanks

JVN