I am trying to help my wife. I am fair when it comes to vb and excel but
have no idea how to make them work together. She has 5 columns. Column E
contains a month of the year. She wants her program to pop up the names
attached to the month on the first of the preceeding month.
on the first day of each month
check all cells in column e against next months name
if these equal each other then print entire row
continue until out of rows
end
I have vba for dummies but I guess even that is above me.
Can anyone help or point me in the right direction? Thanks guys.
Al,
If I understand you correctly, you could probably achieve the same via an
Auto Filter. Go to Data-->Filter-->Auto Filter and then in Column E use the
dropdown to filter for the required month and then print the result of that
filter.
HTH,
Katherine
> I am trying to help my wife. I am fair when it comes to vb and excel but
> have no idea how to make them work together. She has 5 columns. Column E
[quoted text clipped - 9 lines]
> I have vba for dummies but I guess even that is above me.
> Can anyone help or point me in the right direction? Thanks guys.