Formula / Macro Help for Populating data and pulling in data

Hi

Im new to Excel Forums so please be gentle with me

I need some help

I have some research that i have been doing for work and have just been informed by the developers that they need the data in a certain format. For example i have researched the price of a beer like Budweiser from 6 supermarkets. I have put the SKU ''Budweiser'' in Cell A2 and have have put the web links to this product from the supermarkets in cells B2, C2, D2, E2, F2 and E2.

The developers need the research to go in all the same column. I.e. Cells A1 to A6 would be say ''Budweiser'' but the web links need to go in B1 to B6. I would then have to put the same for ''Heineken'' in cells A7 to A12 and have its corresponding web links in cells B7 to B12. This order would be the same for all the products. I.e. another 6 cells in Column A & B for another product

I need to do this for about 1,300 different products.

I only know the basics of Excel, so please any help would be really appreciated!!

If required i can attach an example, incase im not explaining it very well

Hi there,

Do all products have six links (columns) associated with them, or do some have more/fewer?

Regards,

Greg M

Hi there,

Take a look at the attached workbook (1,300 products) and see if it does what you need - it works on the basis that six links are provided for each product.

It uses the following code:

Please Login or Register  to view this content.

The highlighted values can be altered to suit any future layout changes.

Hope this helps - please let me know how you get on.

Regards,

Greg M