Hi,

I have a 40 tabs spreadsheet. On a weekly basis I need to update half of the
sheets and the rest at the end of the month. Each week I need to add the end
of week data, so basically modify the formatting of the new cells to match
the formatting of the previous cells, extend the border lines to include the
new set of cells in the new column and if there is any formulas in the
previous cell, copy it to the new cell. This only applies to the rows that
has cells filled, for the empty rows nothing should happen. Can I write a
macro that I can use on sheets i need to update to do what i have described
above?

Thanks!!