First off, thank you for what you do! I am self-taught (arguably by a pretty shoddy teacher), and am determined to figure *some* of this stuff out. I've come to this forum many many times to work through issues with great success. Thanks!
I need a code to look at the rows on one worksheet and based on the value of column A for each row, copy cells A through E in that row to cells A through E of a blank row on a corresponding worksheet.
I found a code from another post that does just what I need it to with one small exception. The code was posted by DaveGuggs and is as follows:
I have modified the code above to fit my workbook. It works great and is WAY simpler than the code I had clunked out. I need to make one small change- in the code where it copies and pastes the data to the new sheet, I would like to only copy the data in column A through E, not the entire row.
I tried a bunch of things, for example, in this row of code
I put in
in place of
But it returned an error 13, type mismatch. What do I need to put in to only copy columns A through E of row I?
I'm sure this has a simple fix, and I'm sure that my question exposes my lack of vba intellegence. ; )
Thank you much!
Al
Bookmarks