I gather data from an external source into one worksheet, entitled 'Paste'. It will look like the following:
Worksheet Date text1 text2
alpha 05/08/2019 text text
gamma 05/08/2019 text text
I then copy the row with 'alpha' in column A and paste to the bottom of the current rows of text in the 'alpha' worksheet, copy the row with 'gamma' and paste to the bottom of the current rows of text in the 'gamma' worksheet and so on.
It is rather tiresome when there are about 100 rows to copy over to the relevant worksheet.
Can someone help me with a macro that will read each row, copy that row to the worksheet name in column A, and repeat this for all non-empty rows in the 'Paste' worksheet?
Thanks
Worksheet Date text1 text2
alpha 05/08/2019 text text
gamma 05/08/2019 text text
I then copy the row with 'alpha' in column A and paste to the bottom of the current rows of text in the 'alpha' worksheet, copy the row with 'gamma' and paste to the bottom of the current rows of text in the 'gamma' worksheet and so on.
It is rather tiresome when there are about 100 rows to copy over to the relevant worksheet.
Can someone help me with a macro that will read each row, copy that row to the worksheet name in column A, and repeat this for all non-empty rows in the 'Paste' worksheet?
Thanks