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.
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.