VBA search confusion :S

[Guacamoley]

Hello, I am using VBA and trying to get it to use 'sheet 2' and get it to search from collumns D > X and look for any value that is less than/equal to 14 days from todays date and display the result.

I am doing this for a project that is due on monday and I would really appriciate any insight into this as I am sooooo stuck!

Thanking you in advance

xx

 

[perco754]

Hi,

Please provide more information such as formulas used, data etc. so that we have a chance in trying to reproduce your problem!

BR,
perco

 

[GTO]

...I am doing this for a project that is due on monday and I would really appriciate any insight into this as I am sooooo stuck!

Thanking you in advance

xx

Is this homework?

 

[Guacamoley]

Haha no not homework!

okay well, I have a list of manditory training that I am trying to make all fancy (in a nutshell!).

In the spreadsheet it lists peoples staff numbers in column B. The whole of row 2 is the names of the courses. the space between these are filled with the due dates of an individuals course this has been worked out using EDATE function.

I have found a formula that works to figure out the less than 14 days from today =(B1-TODAY())<14

I just dont know where to start with making VBA search through the columns whilst using this search criteria.

Thank you for getting back to me, feel free to ask me further questions if I haven't addressed your point.

xx

 

[perco754]

Sorry, I still don't understand and if you want my help I need a much more clear view of what you're trying to do. Could please provide e.g. a screen shot of your sheet?
What do you mean by "The whole of row 2 is the names of the courses. the space between these are filled with the due dates of an individuals course this has been worked out ..."?

 

[GTO]

Hello, I am using VBA and trying to get it to use 'sheet 2' and get it to search from collumns D > X and look for any value that is less than/equal to 14 days from todays date and display the result.

I am doing this for a project that is due on monday and I would really appriciate any insight into this as I am sooooo stuck!

Thanking you in advance

xx

Haha no not homework!

okay well, I have a list of manditory training that I am trying to make all fancy (in a nutshell!).

In the spreadsheet it lists peoples staff numbers in column B. The whole of row 2 is the names of the courses. the space between these are filled with the due dates of an individuals course this has been worked out using EDATE function.

I have found a formula that works to figure out the less than 14 days from today =(B1-TODAY())<14

I just dont know where to start with making VBA search through the columns whilst using this search criteria.

Thank you for getting back to me, feel free to ask me further questions if I haven't addressed your point.

xx

Okay, a couple of questions:

I am presuming by what is said so far, that either Columns (Cols) C or D though X are filled with nothing but legitimate dates (as recognized by Excel. That is, they show in the formula bar in the locale's default and in the cells, they are right-aligned). Is this correct?

Are there possible blank cells in the range?

What do you mean by "and display the result."? Do we highlight these cells, give a total someplace of those meeting our test's criteria, or???

Utterly no offense to perco754, but example data would be better utilized if you could border inside/outside some sample date and paste it in the post.

 

[perco754]

Utterly no offense to perco754, but example data would be better utilized if you could border inside/outside some sample date and paste it in the post.

??? I meant that ANY provided example is welcome and real data is of course prefered. You could provide a screen dump in cases you don't want to or you are not allowed to show a real example.

 

[GTO]

@perco754:

Yes, of course. Some example is better than none, no matter what. I very much doubt that we disagree at all, and hope tha you did not take that to be my meaning. I was simply pointing out, that at least IMO, the OP can take the time to whip up some fake data (that replicates the real type(s)) and post it. Pics simply leave any 'answerer', or more accurately, all answers, building their own example data. Not exactly efficient. I hope you agree.

 

[perco754]

I couldn't agree more

 

[Guacamoley]

Sorry guys, im not ignoring you!

Im having a little difficulty uploading anything on here as I am not sure how, I have read through the FAQ but every link I click on says that it is restricted. I could always email if this is not possible?

Thanks again

xx