ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro to merge 3 rows multi times, columns A:K only (https://www.excelbanter.com/excel-worksheet-functions/248915-macro-merge-3-rows-multi-times-columns-k-only.html)

Steve

Macro to merge 3 rows multi times, columns A:K only
 
I have data in every 3 rows (5,8,11, etc), through column K. I need to keep
columns L & M as is.

I'd like a macro to merge A5:K7, A8:K10, A11:K13, etc, through a specific
number of rows (the max number of rows would change depending on which sheet
I was using) . Meaning one sheet would be through row 32 ( the last of the
merged rows) another sheet the last of the merged rows would be through row
50, etc. I could identify the max row in a cell if the macro could use that
number when it's run.

Thanks,

Steve


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com