Hello
i have an Excel spreadsheet that contains 6 columns.
column1 is always populated. columns 2-6 contain other
information. the entries for columns 2-6 for any row
depend on the value on column1 for that row.
now there are several instances where there are blank
values in columns 2-6 for some rows, even though column1
for that row has an entry.
i need to write a macro that will for each of columns 2-6
find a blank cell, then perform a vlookup based on the
value in column1 for that row, then go to the next blank
and do the same thing, then repeat for each of columns 2-6.
the vlookup will find the missing data in another Excel
spreadsheet.
as this changes each month i want to use a macro to
automate this as opposed to manually doing vlookup each
month
i have no idea how to write such a macro. can anyone give
me some ideas,
thanks a lot
Mike