Advanced Filter Macro Help

[cdmcnamara]

Hi,

I am attempting to write a macro that takes data from a worksheet and sorts it into corresponding worksheets. Here is the code that seems to be troublesome:

Please Login or Register  to view this content.

I would like the code to sort through the data on Sheet4 and then copy the rows in the Multiline sector into the Multiline sheet.

I have attached a workbook to help.

Thanks in advance!

[JBeaucaire]

Try this one:

Please Login or Register  to view this content.

Simply edit the "MyVal" string (in blue) and the same macro can be used to copy to any sheet that matches exactly.

[cdmcnamara]

Thanks a lot, that works great but I have another question. So the list I will be working with is a huge list with many columns and rows and while this works with two columns, I was wondering if you can possibly tweak it so that it works based on a selection and all I have to do is specify what column to look for myVal in.

Thanks for your help in advance!

[JBeaucaire]

I can't picture what you mean. Sorry. Wouldn't it be easier to just work with a real sample workbook, with real, complete sample data and before/after examples to refer to?

Like you did the first time, mock up a complete dataset this time showing what you want to do fully.

[cdmcnamara]

I apologize for the all the numbers in the sheet but its sensitive data, and I also had to take out some of the headings.

The sheets indicate what the goal would be after I run the macro. I was hoping just to be able what to specify what header I want to sort by, ie. Sector, Edit Date, etc. and have it go through the whole data sheet and copy all the multilines over to the multiline sheet. Hope this helps.

Thanks!

[JBeaucaire]

Ah! So you just want it to parse out all the values to specific sheets, erasing original data and replacing it with the current data in the DATA sheet? Yes? Or keep the data on each sheet and ADD to the bottom each time it's run?

I've got a bunch of those macros, pretty much ready-to-use.

[cdmcnamara]

Hey sorry I didn't specify more, the sheets in the multiline, banking, insurance sheets are what they would look like after the macro is ran, so initially they would be blank. I would also like to leave the data in the data sheet intact, so just copy it into the other sheets.

Thanks!

[JBeaucaire]

Like so to replace all existing data:

Please Login or Register  to view this content.

[cdmcnamara]

Works great, thanks.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)