Well it does in one sense, it does what I told it to, but that isn't what I mean.
Macro: It copies 3 rows of cells from a reference (R) worksheet. It inserts them into the input page (I) at a specific point. The macro goes back to R and copies a different single row. The macro then goes to the cover page (C) and inserts this single row into a specific row. Next, the Macro connects the cells on C with the cells on I.
This works the first time. BUT... the second time, everything works up until it connects the cells on C & I. This time, the cells on C reference one row down from the original reference but I added three rows and I need the linking to be in relation to the 1st line of the inserted cells and specific cells after that.
I attached the file so if you give this a whirl, run the Module4AddCC macro twice. The second time, notice that on the cash flows page, the 2nd macro's name bar has the contents of the cell directly under the reference above.
Thank you.
Bookmarks