Hello all - I have a question. I have a worksheet where I need to copy down cells A17 through I17 based on whether there is data in column K17. I need a macro which detects the last row in column K that contains data and copy cells A17 through I17 to the last row containing data in K17 PLUS an additional 4 rows. So for example - if the last row in containing data in column K is row 20 - I need the macro to copy the formulas from A17 through K17 down to row 24. I hope that makes sense. Any help would be GREATLY appreciated. Thanks!
Chris
Bookmarks