Hello,
I have a query in macro.
I have 2 excel sheet. In 1st sheet i have list of rows. For eg: 20 rows (may vary)(5 columns).
In 2nd sheet 1-3 names.
Now, If in 2nd sheet, i have one name, then in 1st sheet at the end column (6th column) , i want that names to be displayed.
If in 2nd sheet, there are 2 names, then in 1st sheet, i want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 1st name, 4th row as 2nd name and till last row.
If in 2nd sheet, there are 3 names, then in 1st sheet, i want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 3rd name, 4th row as 1st name and so on.
Is this possible in macro????
I have a query in macro.
I have 2 excel sheet. In 1st sheet i have list of rows. For eg: 20 rows (may vary)(5 columns).
In 2nd sheet 1-3 names.
Now, If in 2nd sheet, i have one name, then in 1st sheet at the end column (6th column) , i want that names to be displayed.
If in 2nd sheet, there are 2 names, then in 1st sheet, i want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 1st name, 4th row as 2nd name and till last row.
If in 2nd sheet, there are 3 names, then in 1st sheet, i want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 3rd name, 4th row as 1st name and so on.
Is this possible in macro????