Hi
I sincerely thank from bottom of heart the forum for various solutions for vba coding for various automation and easying in terms of time saving.
I am in need of a help.
I am working acccounts department with figures thrown as Trial balance from the system.
The sheet is by default protected and auto filled with colour.
Every time while consoldating we do
1)unproetect sheet by going to review menu and
2) we go to format menu for choosing default fill colour no colour of
3)We do demerge the cells for the heading.
We do this activity for each and every work books
Can you please help to automate this process.
We do about 50 and 100 sheets every day.
Please help
We attch the excel and and result sought in the in different work sheets.
Thanks
Bookmarks