VBA Excel. With/Next with an If statement and a Xlookup in it.
Budget: $10 – $30 USD
I need to take the data from “3 Enter Quote Data” tab and paste it to the bottom of tab “Coat Source Details” tab. Need this repeated for each row from 24 down to 56 if there is data in columns F G and H of each respective row.
But it’s a little more complicated then that. There is data that’s reappeared in each row. And there is an If statement that has to get repeated in each Next.
I need this ASAP so please don’t reply with an offer for 2 or more days from now. If you cannot get it to me in the next 12 hours please don’t send a proposal.
In the attached there is more information. I have the tabs and the data laid out. Plus there is some code that might be useful to you.
I know how to do this for the first row but don’t know how to do a next statement to loop through each row. The code in the attached shows how to do it for the first row. It only there to be helpful to you.
But it’s a little more complicated then that. There is data that’s reappeared in each row. And there is an If statement that has to get repeated in each Next.
I need this ASAP so please don’t reply with an offer for 2 or more days from now. If you cannot get it to me in the next 12 hours please don’t send a proposal.
In the attached there is more information. I have the tabs and the data laid out. Plus there is some code that might be useful to you.
I know how to do this for the first row but don’t know how to do a next statement to loop through each row. The code in the attached shows how to do it for the first row. It only there to be helpful to you.
Related categories:
Excel VBA