Hello,
I am trying to copy row data from 'Sheet1" into a new worksheet that is named as a value included in Column B on Sheet1.
Sheet1 is below.
I would like to copy row data using the site ID in column B. there are worksheets for each value in column B and there can be 100+ different values/ worksheets for values in Column B.
Ideally the code would sort through values in Column B, Create a worksheet for each unique value and copy the row data into the new worksheet.
this may be a tall ask, but thanks in advance!!
I am trying to copy row data from 'Sheet1" into a new worksheet that is named as a value included in Column B on Sheet1.
Sheet1 is below.
I would like to copy row data using the site ID in column B. there are worksheets for each value in column B and there can be 100+ different values/ worksheets for values in Column B.
Ideally the code would sort through values in Column B, Create a worksheet for each unique value and copy the row data into the new worksheet.
this may be a tall ask, but thanks in advance!!