Do Until Loop to copy cells to another sheet

Hi,

I have a workbook with multiple sheets and one main sheet called "Low Level Data". I want to paste certain cells from a worksheet to the next blank row in the "Low Level Data" sheet. The macro seems to be copying the cells but not pasting them anywhere!

My code is below, can anyone help?

Please Login or Register  to view this content.

Help would be Much Appreciated!

The first problem was that you were checking against the wrong variable for the engine number. You assigned the value to SCEngineNo but the If statement checked a variable called EngineNo.

There also was no mechanism to stop the looping once the engine number or blank was found. You would fill your sheet with the same info in each row.

I've highlighted the changes to your macro.

Please Login or Register  to view this content.