Search results for query: *

Thanks for the help and insight. Just gotta ironout the quirks.

@rustychef As I mentioned to SkipVought, I'm not a programmer and have very little knowledge in vba programming. The code that I pieced together thus far are from various snippets of code I found on the web. It's doing what I need, it may not be the cleanest but my supervisor just wants the...

If I knew more about VBA then I'd know what you're talking about for MS Query. Anyways, I went about it another way and have it more or less doing what I need it to do but it seems to copy over the last row twice to the new sheet. Here's the code I have rewritten (forgive me I'm not a...

Worksheet("Products") is a master product list that contains multiple families of products. The macro searches the first column of "Products" for a family match based on the initial 6 or 7 characters of the string and then copies certain columns based on a drop down. I need this to be...

The code I have written below copies an entire row of cells from one worksheet to another but what I need to do is copy certain cells within the row to another worksheet. For RowIndex = 1 To 250 Set curCell = Worksheets("Products").Cells(RowIndex, 1) If Left(curCell, 6) = ProductFamily...