Hi
Greetings to All
I take this as an oppourtunity for thanking forum for rendering invaluable solutions in excel vba coding.
I am working in Accounts Department. We prepare various financials for our company
We prepare different sheets for the relevant company and consolidate in summary sheet by copying the cells and pasting the link.
It takes a quite a lot of time and we need to prepare atlease 50 sheets to 100 sheets We need to prepare this auditors so that they can view the link and satisfy.
Is it possible to automate through macro.
your advise will be helpful.
Cell A3 will be heading of the sheet
No of rows will be different for each each
B colm with cell text" Total" shall be value will be pasted in the summary sheet.
Attaching the excel
Thanks
Bookmarks