Hello Vinod, It may be easier to setup formulas on the master sheet to do what you want. Alternatively, it is possible to consolidate sheets by using macros. As a start, start the macro recorder and carry out the consolidation. Stop the recorder once the process has finished and the examine the code to see how excel recorded the macro.
There may be better ways to consolidate work sheets an you may want to make the macro generic so that it can handle any kind of workbook. Pranav To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
