How to find empty cell and insert vlookup formula

Hi

My excel has two sheets
1.RAW
2.MASTER

My RAW Sheet has the following columns
Name status
a Present
b absent
c Present
d Present
e Present
f Present
g absent
l Present
m Present
n Present
o Present
p Present
q Present
r absent
s absent
y Present
z Present

And Master sheet has the following columns
name 3/1/2013 3/2/2013 3/3/2013 3/4/2013 3/5/2013
a Present Present
b Present Present
c Present Present
d Present Present
e Present Present
f Present Present
g Present Present
h Present absent
i Present Present
j Present Present
k Present Present
l Present Present
m Present Present
n Present absent
o Present Present
p Present Present
q Present Present
r Present Present
s Present Present
u Present absent
v Present Present
w Present Present
x Present Present
y Present Present
z Present Present

what i have to do is find the empty cell in master sheet for eg in this case 1st row 4th column 1st cell and input vlookup formula to fetch the status of these names into master sheet

output will be like as given below

name 3/1/2013 3/2/2013 3/3/2013
a Present Present Present
b Present Present absent
c Present Present Present
d Present Present Present
e Present Present Present
f Present Present Present
g Present Present absent
h Present absent #N/A
i Present Present #N/A
j Present Present #N/A
k Present Present #N/A
l Present Present #N/A
m Present Present #N/A
n Present absent #N/A
o Present Present #N/A
p Present Present #N/A
q Present Present #N/A
r Present Present #N/A
s Present Present #N/A
u Present absent #N/A
v Present Present #N/A
w Present Present #N/A
x Present Present #N/A
y Present Present #N/A
z Present Present #N/A

Please Login or Register  to view this content.

will be great if somebody can help

Hi, sathu,

VBA to insert a Formula that relates on the same data every day?

Maybe give this code a try but I would recommend to write the values found into the cells instead of formulas:

Please Login or Register  to view this content.

Ciao,
Holger