Macro Or VBA code needed for sorting,matching and copying on to relevant sheet

Try this:

Please Login or Register  to view this content.

It will create the sheets as needed, put them in alphabetical order and parse the rows of data to each sheet. It will count how many rows of data are on the first sheet and compare that to how many rows are moved to other sheets and give you the totals as a comparison to make sure they match...they always should, but you never know.

Dear JBeaucaire
Thanks for quick response
thats what i was looking for,
one more thing, Can you include Scan date & Due Columns for me,

Many thanks

Kind regards
Ben

This is the line of code that determines how wide the copy is:

Please Login or Register  to view this content.

Change the "D" to whatever column you want to be the last column copied.


=============
NOTE: Unless you're quoting something specific, there's no need to use the QUOTE button, the QUICK REPLY makes a cleaner thread, easier to read.

=============


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. It is found across from the "time" in each of our posts.)

For reference, here is the most uptodate version of this macro. It provides a quick and easy way to customize the macro in the first 3 lines of command code.

Please Login or Register  to view this content.

Did the one provided work for you? You never indicated by closing this thread.