Dear Friends,
I have a worksheet, called monthlysheet, in which cols. A - CX are there.
Assume that I have right now data from A4 - CZ104 (Row #3 is my header data).
From Col.A to Col.BZ are my values
From Col.CA to Col.CX are formula based columns.
Now, if i copy 50 data from some other workbook to this monthlysheet in cols. A - BZ, then I want to copy the formulas (all available in row #104) for the copied 50 data also.
i.e. if values are copied in Col. A then automatically the formulas in Col.CA to CX should be copied for the same number of copied data rows.
I need a VBA to automate the process.
Thanks & regards.
Bookmarks