Loop VBA code to create a pricelist based on input values in "Calculator" sheet

Hi Everyone,

Could anyone perhaps guide me on how to loop the below code through a range. I have a calculator sheet, and a price list sheet. What is happening I inserting values into the calculator from the Price list sheet, which gives the price, and in turn I paste it on the appropriate cell in the pricelist, which the code below does, but its only for the first two lines of criteria... I need it to loop through another 800000 lines to complete my pricelist, is this possible?

Kind Regards
Duke

Please Login or Register  to view this content.

Try to use this macro, I hope that can help you to fix your problem:

Please Login or Register  to view this content.

Regards,
Antonio

Hi Antonio

Thank you so much, it seems to be doing the job. Very much appreciated. Will it run the formula until the last row that has data in it, or to the very last row in the sheet at 1048... odd?

Once again, really appreciate this.

Kind Regards
Duke

Ther code runs until the last row that found in the sheet 'WiroA3 C100gsm I100gsm 20-22pp ', not until 1048576.

Regards,
Antonio

Thanks Antoka05, I have been running it, and it has gone through the night, all of excel goes stagnant, and all I see is a blue round mouse pointer going round and round. I am sure it is working, would it be possible to incorporate a status bar into the code to see how far the progress runs, so that I an be sure that excel has not frozen up?

You could use this code that shows, on the bottom left of excel, the row and the percentage:

Please Login or Register  to view this content.

Regards,
Antonio