looking up vlookup

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
 
A

AlfD

Hi!

I would have thought that you need to make your mind up to "fix" Sheet
2 before you "run" Sheet 1. So: maybe a process (? as a matter of
discipline or routine?) to check Sheet 2 is up-to-date before using it
as lookup.

If your problem is that the possible changes are scattered around, then
a VBA routine taking you through the possible changes is entirely
feasible.

Alf
 
A

~Alan

my  problem is that the possible changes are scattered around.
can you help with a VBA routine taking me through the possible changes

: Hi!

I would have thought that you need to make your mind up to "fix" Sheet
2 before you "run" Sheet 1. So: maybe a process (? as a matter of
discipline or routine?) to check Sheet 2 is up-to-date before using it
as lookup.

If your problem is that the possible changes are scattered around, then
a VBA routine taking you through the possible changes is entirely
feasible.

Alf
 
Top