Automatic insertion of excel sheet from one work book to another
I have been using MSword for quite a while but never MSExcel. I am very new to MSExcel, equations and functions. I could learn only to add cells, do mathematical operations on different cells and some other functions. Coming to the point, I have to copy so many cells from one sheet to other. Problem is that the rows and columns should be changeable and whatever changes happen on one sheet should automatically in other. Since, the number of rows and columns are countless; I don’t think the manual assignments of cell will not work? Any expertise on this topic? Kindly share the code or sample document if possible.