macro to consolidate - help!

[jw01]

hello

i have a macro that goes in a set path (folder) and extracts data from the "master" worksheet and dumps it into my together.

the issue im having is the range on my macro is set as pretty large
.Range("B10:P1009").Copy

1) i was wondering if it would be possible so if column B contains "0" then it not copy over row?
2) also, for each row that is pasted, so after the last column, if i can show how make the macro go into worksheet called "YTD OT Summary" sheet and paste over the name of the person in cell C10 i.e. each time a row is copied over in the B:P range, in column Q, it also assigns the name of the person?

this is my code...can someone pls help....i have over 75 files so i would appreciate it!

also, how can i make excel not calculation or set the workbook calculation to manual, each time the macro goes into a workbook?

Please Login or Register  to view this content.

pls help..thx u

[arlu1201]

Do you have a sample file that you use along with the above code, that you can attach ?

[jw01]

hello

i have attached a sample file (i have 70 of these files for different individuals).

basically i would like my macro to work the way it is except

1) if column B in the "master" sheet contains 0...then do not copy that row

2) copy over the name in "ytd ots summary" from cell C10 to show person's name

pls help!

[jw01]

not sure how to integrate this wid the code....if it helps?

Application.WorksheetFunction.CountA(Range("B:B"))

[jw01]

any thoughts guys? pls and thx u

[jw01]

anything guys?!?!? pls and thx u

[arlu1201]

We can do this. It will be far easier than checking for 0 before copying each file. What we can do is, copy all the data, and then filter /check for 0 in the column required (in your case column B) and delete those rows.

What do you think?