VBA to seperate info

[Zygoid]

It has been a few years since I have done VBA in excel. I can't seem to get the results and would appreciate any help.

I have a workbook with 6 sheets (named sheets 1 thru 6 for this help)

sheet 1 has an addresses on each row (along with other info). this sheet changes daily with rows being deleted and added.

col. O has the zip codes, the zips are what i want to base my seperation on.

so, something like this;

Please Login or Register  to view this content.

I can't seem to get it right

[Bryan Hessey]

It has been a few years since I have done VBA in excel. I can't seem to get the results and would appreciate any help.

I have a workbook with 6 sheets (named sheets 1 thru 6 for this help)

sheet 1 has an addresses on each row (along with other info). this sheet changes daily with rows being deleted and added.

col. O has the zip codes, the zips are what i want to base my seperation on.

so, something like this;

Please Login or Register  to view this content.

I can't seem to get it right

Hi,


try something like

Please Login or Register  to view this content.

and I recommend using the same iRow setting for all three items, rather than risk a spurious entry in one column.

hth
---