I'm very new to VBA in Excel, but now I need to create en new workbook to make some reports...
On Sheet1 I have data in column A to N.
On Sheet2 I need the data from Sheet1, column a,b,d and f, but only if data in column a=4. The data needs to be placed in cell B3 and down.
I have a piece of code that copies column a to n if a=4 and places it in the upper left corner on Sheet2, and it is this code I have tried altering:
The things that don't work is the specific columns and where I put the copied cells:-(
Can someone help me?
/J
Bookmarks