I am trying to figure out how to clean up a workbook automatically. I
have a workbook that has a name and location in the first line. Three
to four rows down I have several columns that have a cost analysis in
them. Problem is I have a 1000 names with cost analysis and I want to
pick the names and then pull the numbers from three lines down and put
all of this into another sheet that is all cleaned up and looks good
so I can analize the data. Can someone help me? I know I want a do
until statement and will probably a if then statement but I can't
figure out how to start. Thank you for anyones help................