Locating and pulling data from one worksheet and placing onto another worksheet

Steve123's picture

I pull a report into Excel that is dozens of columns by thousands of rows; this becomes my main worksheet(Some of the columns contain text, some contain numbers and some contain dates.) I then create worksheets titled for each month of the year. Then I must search two columns in this main worksheet for all the dates that contain the current month and year. This information can be in either of the two columns or both. Once located, I must copy the entire row for each date found in that row into a second worksheet. So, for instance I would have a worksheet titled July with all rows containing the dates found for July. I must then repeat the process searching these same two columns for each month for the rest of the year. So I would have another worksheet (titled August) with all the rows located that contain the dates for August and so on. I would like to set this up so that I can enter the formula into my worksheet for the month and it will search the main worksheet and place the information into that particular month. I have tried using HLOOKUP, but after several attempts I don't think that will apply here. I think it might require writing a macro; but I am not very good with writing macros (yet). This information is to become part of a report that I must create. Can anyone help me?

USE Index / Match function

Instead of VLook & Hlook up combination.

You may use Index & Match function which are considered most efficient and seamless.