best solution

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
 
F

Frank Kabel

Hi
not really sure what you're trying to do. Could you post an example
(plain text - no attachment please)
 
A

~Alan

lets make it real simple
Put the number 123 in column A row 1
in column b row 1 is =IF(A1="","",VLOOKUP(A1,sheet1,2,0))
now if the information that is vlooked up is the number 1
and I need a number 3 I then can 1 do away with the vlookup and change
it to a 3
or I can go to sheet1 column b which is the 2 in the vlook up statement
and change it there
but I will first have to find 123 or I can highlight the row and use
data/form and change it there
now does anyone know of a macro that can be run that will go to
specified vlookup ask if it needs to be changed and alow you to make the
chamge

The sheet1 has 100 vlookup and I dont want to have to go and look at
each one of them
 
Top