VB Code help for Excel 2003 - Please Help

Joined
Nov 10, 2010
Messages
1
Reaction score
0
Hi,

I am new to both Visual Basic programming and Excel spreadsheets.I have a work project that I am trying to streamline the process for. I am trying to create a Macro that will use Column values such as A,B,C etc through column U. Column " A" would be the fixed value to start the look up and ensure matching criteria. Columns "J" and / or "K" can only equal "Y","N", or <null>. If either column "J" or "K" or both columns return a "Y" or <null> value the macro would then extract the entire row from column A to U into a second spreadsheet. Could some one advise me of the proper Visual Basic code to achieve this? I am completely at a lost as to how to get this completed or even if this can be done. I have tried to use the advanced filter but due to the structure of the spreadsheet, it did not execute as needed. I would greatly appreciate any help possible.


Thank you,
Suzzette






 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top