VBA Macro for Copy and Paste data multiple times

[ssuresh711]

Hello Everyone,

Requesting your help. I have two excel work book named "Inventory.xls" and "Resource.xls".

In a resource workbook, I have a set of resources available for the day and everyday the data may be change.

In a Inventory workbook, I have a set of datas needs to be worked.

I need a macro to pull the available resources and assign the names in the inventory work book.

For example: I have 50 lines in the inventory work book. I have 5 resources available for the day. So If I run a macro, For the 1st five lines first resource name should be assigned. For the 2nd five lines, the next resources should be assigned and so on.

Could any one please help?

Thanks