|re: "I have limited VB knowledge and looking for somebody to help."|
Does "limited knowledge" mean that you can take some generic code and modify it to fit your specific needs (change search ranges, sheets names, etc.) or are you looking for a complete and working macro?
If it's the former, I can throw something together. If it's that latter, I would need some more specific information, like what columns the dates are in, exactly where should the data should be pasted, etc.
As it stands now, I'm a little confused by a few of things.
1 - Your subject line says "copy user specified data to new worksheet", the text of your post says "paste it in a new workbook" As I'm sure you know, those are very different things and the code required will be very different.
2 - You said "by prompting the user for a start and end date and then searches a specific column by asking the user to enter the column header title."
Does that mean that you have dates in more than one column and the code will need to know which column to use each time a search is done?
3 - Will multiple rows need to be copied for each search or will it be a single row based on a single date that will be found based on the start and end dates. In other words, will there typically be more than one date found between the start and end dates?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.