View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sweetetc
 
Posts: n/a
Default If than copy function / Macro

I have two worksheets.

The two columns that are as follows
Column A Column B
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
Liz
--
Thanks
ETC