guatelize
06-14-2011, 06:07 AM
Hello
Every day I'm updating a sheet with numbers followed by formulas and specific formats.
Instead of copy paste every time the formulas & formats from the above row, I'm looking for a macro to insert 5 rows when last used row is reached, copying the formulas & formats from the last used rows.
Attached an exemple :
Thanks for your help
Every day I'm updating a sheet with numbers followed by formulas and specific formats.
Instead of copy paste every time the formulas & formats from the above row, I'm looking for a macro to insert 5 rows when last used row is reached, copying the formulas & formats from the last used rows.
Attached an exemple :
Thanks for your help