Pull data from adjacent and selected row cells based on user inputted date range

[splreece]

MOrning all,

I am sure this is a standard fix but I can only really find formula and vba based on fixed dates and adjacent cells.

I am looking to run reports where my users can dictate a date range

Date from = Cell "L2"
Date to = Cell "M2"

I need to be able to search column "S" for any rows that fall within the date range above and then pull on a new sheet the following columns data:
"k", "h", "ag", "t", "u through to af".

Does this make sense?

any help would be appreciated.

 

[splreece]

works like a charm...

ive used this site a few times, and I am every time trying to use common sense and logic to figure out my own code, but I am learning it is really something that cant be learned by manipulating or dissecting others code, it is a must that I take a formal course in it...

(very comfy with excel but vba is a mystery)

 

[splreece]

works perfectly...

I'm quickly realizing that no matter how competent at excel I am, no matter of manipulating existing code and using logic will help learn VBA... definitely has to be a course or some sort of program.

 

[Peter_SSs]

works like a charm...

That's good, thanks for letting us know.

... but I am learning it is really something that cant be learned by manipulating or dissecting others code, ...

That's how I've learned most of the vba I know - and mostly on this forum.

 

[Peter_SSs]

That's how I've learned most of the vba I know - and mostly on this forum.

For example, being able to read data into an array from disjoint columns and in an unusual order like I used in this code, I learned from pgc01 in this thread.