Help modifying code to copy data from one sheet to another

I have a bit of code that works perfect for copying data from certain columns and rows from one sheet to another in order to create a packing slip.

I need to modify the code a bit to use it on another sheet to copy it's data to a "material req" sheet (different columns)


Here is the code that works great (it works even if data is filtered, works perfect)

Please Login or Register  to view this content.

This basically takes all data from the first three columns (starting at row 8) and copies it to another sheet (packing slip).


What I need is it to be used on another sheet (sheet2 "material list") and have it copy the data from the first three columns (a,b,c) and also from column g (skipping d,e,f).
This would also start at row 8 and work exactly like the other bit of code and it would copy it to sheet14 "material req".

Other than that it would work the same way.

I just can't figure out how to get the range of what it is copying to switch from a,b,c to a,b,c,g.


Thanks

Hi, thanks for the help.

It gives me a 400 error and does not copy anything.

The only thing I did see is that it just unlocked the material req sheet that's it.

This should start copying the data at row 8, like the other one does. I didn't notice that starting point in your piece of code, but I am not advanced enough to tell 100%. Everything above row 8 is headers and title stuff.


Thanks.

Worked perfect, sorry for the delayed response.

Thanks!