Hi,



So I have an input file that I need to be split up into various other tabs, this input file comes into my sheet nicely with my macro and generally has a very specific format so I am able to just code it to take specific row numbers and paste them into the correct tabs. If the formatting changes on my input file at all it will not work though. In very simple terms I just want to even just select all rows with a specific value in my column B.

I have attached the simplest form of data that I can provide to be able to do this, I would just like to be able to select all rows where column B = Sugar or Cotton or whatever it may be, so that I can copy and paste it into other tabs.

A small worry I have with this is also is whether there would be spaces in between the data when it gets copied and pasted. I can't have any spaces when it gets pasted.

THANKS!

Attached Files

book.xls (28.5 KB, 14 views)