Loop code

**martinp1** · 02-26-2013, 06:37 AM

Hi All

I'm after something I know will be really simple but if you could help me that would be great!

I have a code that works well, it starts off at an invoicing sheet, then takes data from a tab in a quoting spreadsheet, then once finished, selects the next row in the invoicing sheet and the next tab in the quoting sheet

I just want to add a loop to it that says if cell B8 says "or" stop, but it it doesn't then execute the code below

A nice to have to be a message box to tell me how many loops it went through

Thanks again, I'm tearing my hair out as I know that this is simple!

Martin

**Norie** · 02-26-2013, 06:44 AM

Martin

Should be straightforward, can you post the code you have so far?

**martinp1** · 02-26-2013, 06:52 AM

Thanks, it's below. The cell B8 which is the condition is in the Master QM file, but you start from the Quote index file

Please Login or Register  to view this content.

**Norie** · 02-26-2013, 07:14 AM

Martin

Is that code for one invoice?

**martinp1** · 02-26-2013, 07:41 AM

Yes, this updates 1 line in the invoice spreadsheet, which is one tab in the quote model spreadsheet, so I'd like the macro to work through all of the lines in the invoice sheet

**Norie** · 02-26-2013, 07:54 AM

Martin

Where does B8 come into things?

Also, what exactly are you looping?

Sorry for the questions but the code is kind of hard to follow with all the jumping between workbooks.

Actually, could you upload a sample workbook that had some sample data and sample invoice?

Here's how you can do that:

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic