Import into excel and filter data to new sheet

[tyson187]

Guys I need to make macro that starts by:
Opening an excel sheet (which the VBA code is used on) which will have a button saying select file.
Then this selects an excel file from a directory to import.
The imported file has 19 columns but rows in column M needs to contain a string And rows in N needs to contain a number.
If both conditions are met I want specific columns output on a new sheet. Let's say columns B, C, D, G, K, M, N, O, Q
on the new sheet I also want a new column consisting of the concatenated value of M & N.

My VBA usage and skill is very limited. So guys if this makes sense... How tricky does it sound.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

[tyson187]

Hi guys here is a sample file of the data that I am trying to create the macro for. I am attaching 1 workbook that uses 2 sheets but I want the macro to work on 2 different workbooks. The second sheet shows the results I want. The if condition is based on the second sheet (columns that are highlighted green). I only want the workbook (second sheet) to have the rows that meet that condition. If any input please let me know.

[jaslake]

Hi tyson187

In Source Worksheet Column M, will the records of interest ALWAYS contain a "/" (forward slash)?

You don't demonstrate this in your Sample File...

I also want a new column consisting of the concatenated value of M & N.

Where would that go, Column J?

Will you want three blank Rows separating each record?

Will the records in the "Result" sheet be cumulative or should they be cleared each time the Code is run?

[tyson187]

@jaslake thank you for reply yes the forward slash is always in col M.
On the new workbook I want the "Result" sheet cleared each time.
On the Results sheet I would like a new column added which is the concatenated value of M&N and put in the next free column (removing the / if possible - but not the biggest issue)
I don't need three blank rows per record. Any input is highly appreciated.

[jaslake]

Hi tyson187

This Code is in attached Workbook Results. Place both Workbooks in the same Folder. Open Results, click the Button. You'll be prompted to open a File (WorksheetMaster.xlsx).

Please Login or Register  to view this content.

[jaslake]

Hi tyson187

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save