Sheet A, Column A is a list of tasks that can grow according to the owner. Column B through E are data columns that are imaged in sheet B, currently there are only 30 rows in Sheet B. I have protected sheet A so users can not corrupt the equations. Macros already established are "Insert Row" which finds the last active row and inserts a new one as well as "Insert Month" which copies the columns from Sheet B and pastes them to the right of the last group of month column for the new month of data entry.
Due to the fact that rows can be added beyond the initial 30 rows, I would like to develop a macro that would count the active rows in Sheet A, copy the same amount of rows from sheet B and paste them similarly to my "insert month" function. I think if I can get help in the count, match count, copy amount part, I can insert it into the "insert month" macro easily enough.
Thanks in advance for the help on my first post!
Bookmarks