Hi all,
I would like to create a vba script to check and delete all the columns (in sheet1) that do not exist in sheet2
For example sheet1 may have columns:
_______A___B___C_____D______E____F___G___H
row 4: This | is | an | example | of | what | I | want
and sheet2 may have columns:
_______A____B___C__D
row 2: This | an | of | I
so as you an see, in sheet2.rows(2), the words "is, example, what, want" do not exist, so I would like to delete the columns "B,D,F,H" from sheet1.rows(4) so that the resulting sheet1 will only have columns that sheet2 has.
*also note that i am comparing two different rows in sheet1 and sheet2
Does anyone know how to do this?
Thanks in advanced!
Jason
Bookmarks