Create a sheet and name it
I need to write a macro which does the following
1) Create a new sheet in the current workbook
2) Scan the current sheet split each row into several columns and write
them in new sheet.
I know how to scan the current sheet but my problem is how, from the
current sheet, referer to the sheet I need to use to add rows. It is
not a copy row by row as sometimes several rows will make one row on
the new sheet
|