The loop should process all rows iteratively until there is no data in column A.Ĭell C2 contains "2". If it contains a number, then the code should insert the corresponding number of rows below, while copying (and keeping the format) columns G to BW from the origin row to the newly inserted ones. I'd need code to check if column C contains a number or if it's empty. The number of rows is variable depending on the source data.
In a specific sheet called "xyz" I have data from columns A to BW. I have an Excel file with multiple sheets. I'd really appreciate some help to come up with a VBA code that does the following: I've been searching a solution to my issue on the board but could not find a working solution that covers my needs.
0 kommentar(er)
