ExcelBanter - Copy data from one worksheet to another using a function or a macr

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy data from one worksheet to another using a function or a macr (https://www.excelbanter.com/excel-worksheet-functions/81266-copy-data-one-worksheet-another-using-function-macr.html)

Sweetetc

Copy data from one worksheet to another using a function or a macr

I have two worksheets.

The has two columns that are as follows
19765L819 2
19765H560 1
19765L538 0
19765N435 3

I want to create a function or macro that will list the numbers in column A
the number of times indicated in column B
So the result of the above in a new worksheet column A should look like:

19765L819
19765L819
19765H560
19765N435
19765N435
19765N435
--
Thanks
ETC

All times are GMT +1. The time now is 01:58 AM.