macro for finding data from diffrent sheet matching with date

[harishb63]

sir i am uploading sample file in the attachment

in this sheet if you see there are 3 sheets
by nane jan ,feb, report
and in my original sheet i will be having
12 sheets each for months
now i want is in the report sheet if i select the month and date

i should get that data in the given place under the label "info" time" and hora
(ie 3 columns and 13 rows

thank you in advance

harish

[AB33]

A simple code searching by date only as you have dates for day of the month. I am assuming not two dates are the same.

[AB33]

Why do you duplicate a post?

http://www.excelforum.com/excel-prog...with-date.html

[watersev]

hi harishb63, option, enter date in range E2

[harishb63]

sir i saw your excel i want to say that
take enen month in to considration (ie "D2"

the dates i have is furter used in to some other sheets as well
and if you take month cell in to considration the dates wont confict with other sheet same date

example if i enter jan and then date let it search jan sheet first and the date and the get the data of it

thank you for your fast reply

harish

[harishb63]

sir i saw your excel i want to say that
take enen month in to considration (ie "D2"

the dates i have is furter used in to some other sheets as well
and if you take month cell in to considration the dates wont confict with other sheet same date

example if i enter jan and then date let it search jan sheet first and the date and the get the data of it

thank you for your fast reply

harish

[harishb63]

when i posted first it did not refelect on thw web page i even got massage that
page expired i thought it havent got post

for that reason i have posted again

sorry for that

harish

[AB33]

The month in D2 now match the source for the data in that month.

[harishb63]

thank you sir for your fast reply

i saw your excel
it is working
as i told above let it search the sheet first than date
in my original data i have around 20 sheets 12 for each month and again name will be same 3 caracter
like "jan, feb mar apr,
remaing sheets will be analiysing those data and may be dates will be repeted

and one more thing

i want simple macro (ie dont want option explcit or sheet macro

thank you
harish

[harishb63]

thank you sir for you work in the no time you have done it

thank you very much

harish

[AB33]

Another option to match the day of the month with the date in D2.