A
~Alan
XL2000
Situation: In sheet1 column A rows 1:12 is where the characters are
imputed. though out sheet1 are vlookups from sheet2 columns A through G
Problem:There are times when the information from sheet2 may need to be
changed. I know that I can go to sheet2 and manually change the info or I can
highlight the columns in sheet2 and use Data\Forms and make the changes there
Question: Can anyone think of an easier way like maybe a macro that
will go to each vlookup and ask if the information is correct if not
change to if correct then next
Situation: In sheet1 column A rows 1:12 is where the characters are
imputed. though out sheet1 are vlookups from sheet2 columns A through G
Problem:There are times when the information from sheet2 may need to be
changed. I know that I can go to sheet2 and manually change the info or I can
highlight the columns in sheet2 and use Data\Forms and make the changes there
Question: Can anyone think of an easier way like maybe a macro that
will go to each vlookup and ask if the information is correct if not
change to if correct then next