Ajay Gaikwad
New Member
I am struggling with a loop from past 3 days, finally requesting help from the community.
I want to each cell in column M from (input sheet) to output sheet in column BE multiple times based on the rows in sheet3 and then continue to copy the next cell in column M (input sheet) and copy it in output sheet in column BE below the already copied data. This should run till the last value in column M input sheet. Below is the real scenario i am facing
I have 63 rows (62 + 1 header) with value in column M of input sheet (the number of rows are not constant and should be flexible) I want to copy the value in cell M2 of the input sheet and then copy in the output sheet in column BE (row 1 is header). The number of times this value should be pasted should be based on the row count in Sheet3 Range B7 until last filled row (in this case I have 4 rows in sheet3 so the value should be pasted 4 times in output sheet). Then it should move to cell M3 in the input sheet and copy it same number of times in the next available row in Column BE of the output sheet.
This way it should copy till the last row in column M of input sheet to the output sheet in col BE, the same number of times as row available in sheet3 B7 onwards.
Result to check would be 62 (cells in input sheet) * 4 (rows in sheets 3 B7 onwards) = 248 (in output sheet column BE)
Thank you very much in advance.
I want to each cell in column M from (input sheet) to output sheet in column BE multiple times based on the rows in sheet3 and then continue to copy the next cell in column M (input sheet) and copy it in output sheet in column BE below the already copied data. This should run till the last value in column M input sheet. Below is the real scenario i am facing
I have 63 rows (62 + 1 header) with value in column M of input sheet (the number of rows are not constant and should be flexible) I want to copy the value in cell M2 of the input sheet and then copy in the output sheet in column BE (row 1 is header). The number of times this value should be pasted should be based on the row count in Sheet3 Range B7 until last filled row (in this case I have 4 rows in sheet3 so the value should be pasted 4 times in output sheet). Then it should move to cell M3 in the input sheet and copy it same number of times in the next available row in Column BE of the output sheet.
This way it should copy till the last row in column M of input sheet to the output sheet in col BE, the same number of times as row available in sheet3 B7 onwards.
Result to check would be 62 (cells in input sheet) * 4 (rows in sheets 3 B7 onwards) = 248 (in output sheet column BE)
Thank you very much in advance.