There must be a way to do this... I have a huge table with column A -
file names in a "RABC0011" format on one list and an "ABC0011" on
another list. I am trying to copy certain columns of the R table to
the other table. In order to do this I have to set up a loop to check
if filename equals RABC0011 minus the R, add column F, G and H. Is
there a way to make "Rxxxnnn" = "xxxnnn"?


---
Message posted from http://www.ExcelForum.com/