UDF? vlookup values, cell color and cell comments

[sharpdog]

Hello everyone,

I have searched High and low for a UDF that works, but I am struggling.

I am working with a schedule that spans for several years down the page - names at the top - dates down the left. (located in "Edit schedule here" worksheet) I have created a worksheet that functions like a monthly calender that uses vlookup to populate from the "Edit schedule here" worksheet. (Excel 2003)

I am looking for a way to vlookup cell contents, color formats and cell comments.

Currently this is the Vlookup I am using which works quite well for cell contents.
=VLOOKUP(B$4,Sched,COLUMN('Edit schedule here'!$B$5)+MATCH($A6,'Edit schedule here'!$E$5:$X$5,0))

Any help in creating a vlookupallexceptboarders UDF, or something like that would be great. ( I have read about UDF's, but never actually used one)

The cell comments are the most important, but why not shoot for the moon!

Any help would be great,

Luke

 

[sharpdog]

Bump... let me know if you don't understand what i am looking for.

Thanks,
Luke

 

[sharpdog]

I just figured out that this cannot be done with a UDF. I still havn't figured out a VB solution.

Luke

 

[sharpdog]

can anyone help me with this?

 

[sharpdog]

Nobody? Please?