I scan coupons with a desktop scanner into a giant folder and I'm trying to make this easier on myself if at all possible. I'm wondering if once I have the giant index of all the coupons if there isn't a way to come up with a macro to put the coupons into the correct column based on their four digit redeemer number.

Here is an example of the coupon data:

Column A Column B Column C, D, Column E
4/29/2014 15:10 C:\Users\Galena\Desktop\Coupons Folder\2014 Coupons\HB1005-3\HB2013203589_04-29-2014_15-10-55.pdf 1 HB2013203589
4/29/2014 15:10 C:\Users\Galena\Desktop\Coupons Folder\2014 Coupons\HB1005-3\HB2013249468_04-29-2014_15-10-55.pdf 1 HB2013249468
4/29/2014 15:10 C:\Users\Galena\Desktop\Coupons Folder\2014 Coupons\HB1005-3\HB2013203553_04-29-2014_15-10-55.pdf 1 HB2013203553


The HB1005 is the redeemer number which will be found in column B. HB2013203589 etc. are the coupon numbers in column B and E (the same). I want to take all coupon numbers associated with each redeemer number and put them in a separate spreadsheet that has redeemer numbers listed at the top of each worksheet. I'm attaching that file.

The redeemer numbers (called FMNP #s) are each in column A2 of the worksheet and will always be there. So what I want is if 1005 is in A2, the macro will go to the next blank column in the worksheet and post all of the coupon numbers in that column, starting with cell 5.test coupon macro data.xlsm

Can anyone help? Thanks in advance!