I am attempting to create a macro that opens a file named "shrinkage-billing.xls", searches for a variable "PTOSH" in column A, copies the adjacent cell and pastes the data in another worksheet named "Shrinkage Report 2009.xls"
The code follows ...
I get the following error when I run this macro:Please Login or Register to view this content.
Run-time error '1004';
Method 'Range' of object'_Global' failed
I am not certain if I have the Offset syntax incorrect, or maybe the destination reference. As Shrinkage report 2009.xls is in fact the workbook that houses the macro, Can I use 'ThisWorkbook' instead of the actual filename? Also ... the data in Column B in "Shrinkage-Billing.xls" is in hh:mm format which does not paste well in excel. Any chance I can just copy the text before the : ??
Any help would be so appreciated, as somehow I have been dubbed the excel-meister of my workplace. It's a lie I tell you!
~M
Bookmarks