Hi Guys,
First question - How do i set/define a value in a certain cell, on a certain sheet (value can change) as a constant in excel vba so that I can perform an if statement against that function.
I want someone to come in an type a certain value in a certain cell, and then the vba to pick this up and perform an if on a column of data.
Second Question - If it finds that valuein that column, I would like it to copy the data to the right of that cell.
Many Thanks
Herbert
First question - How do i set/define a value in a certain cell, on a certain sheet (value can change) as a constant in excel vba so that I can perform an if statement against that function.
I want someone to come in an type a certain value in a certain cell, and then the vba to pick this up and perform an if on a column of data.
Second Question - If it finds that valuein that column, I would like it to copy the data to the right of that cell.
Many Thanks
Herbert