Transfer certain amount of Columns from one sheet to Another

[trevor2524]

I'm trying to transfer the first 13 Columns from the Master sheet to the System Master Sheet. I have the following code from a previous macro but I'm having a hard time making it convert. Does anybody have any Idea?

Please Login or Register  to view this content.

[AB33]

You are looping through column A ONLY

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[trevor2524]

When I run the macro its having a problem with:

Please Login or Register  to view this content.

[trevor2524]

Ok, last problem its copyin each row 13 times before moving onto the next value and its starting on Row 2 in the System Master sheet for pasting when it should start on row 1.

[AB33]

This code loops through column A and if the cell is blank, it copies that cell up to column M.

Please Login or Register  to view this content.

[AB33]

If the aim is to loop through 13 columns and test each cell for a blank, it will take long to process it. It can quickly done by arrays, but only if you could attach a sample.

[trevor2524]

Ok, that worked but how do I get it to start pasting on Row 1 and not Row 2 on the System Master Sheet?

[trevor2524]

No its just to copy information from one sheet to another and its using column A as a reference to when to stop the loop since that field is always gonna be filled out.

[AB33]

Please Login or Register  to view this content.

[trevor2524]

Ok, that pushed it to start pasting on Row 4. I'm getting confused on what's happening.

[AB33]

How?
You are testing Sheets("Master") and copying in to Sheets("System Master").
I do not see NR=1 is turned in to 4.

Change this line in to 1 as you are looping through column A, not 13

Please Login or Register  to view this content.