Hello There,
I have values in Sheet1 in a particular column. I would like to display it in Sheet2 in a fixed set of columns.
I am aware this can be done using arrays/collections. I tried my best but couldn't get it done (wiped out everything).
Could you please help me out how this can be done using arrays and collections? Your code will be of help in the future as well.
I have attached a sample workbook for your reference.
Look forward to hearing from you.
Thanks & regards,
Donald
I have values in Sheet1 in a particular column. I would like to display it in Sheet2 in a fixed set of columns.
I am aware this can be done using arrays/collections. I tried my best but couldn't get it done (wiped out everything).
Could you please help me out how this can be done using arrays and collections? Your code will be of help in the future as well.
I have attached a sample workbook for your reference.
Look forward to hearing from you.
Thanks & regards,
Donald