Combine Multiple scripts into an array

Your code can't work as you have posted it as it's riddled with typos.

That said, in your lcNR line you are using the wrong offset - should be 0,1 rather than 7,1.

I see where I missed a quotation (which I've corrected), but other than that I don't see the typos you are referring to. It works well when I run it in a module by itself, but when I add it to a module with code already in it, it doesn't run correctly. It runs, but with 7 spaces between where the data from Incident Data sheet stops and Change Data starts.

I set the offset to 7,1 to start copying to B8 in sheet "!".

I appreciate the reply.

Respectfully,

Tim

E.g.

Please Login or Register  to view this content.

I assume you must have typed it out longhand? I think there is scope to simplify your code, but would help if you could mock up a workbook.

Thanks Stephen. I'll try to create a mock workbook and get it posted today or tomorrow. I had to type it long hand because the workbook and the internet are on two completely different networks and there is no way to get data from one to the other (it's a government thing )

Thanks!

Tim