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?
pls help..thx u![]()
Please Login or Register to view this content.
Bookmarks