Report summaries choose date

[god_karthi]

Hi,
I Hope I will get some idea. I have sheet1 is many data and column A is date and it will go many rows with different dates.
I need In sheet2 if I select any particular date will paste from sheet1 which date I selected.

if any one can help me it will more usefull for me.

thanks

[vcoolio]

Hello God_Karthi,

I assume that you want the whole row of data associated with the date transferred to sheet 2. If so, the following code may do the job for you:-

Please Login or Register  to view this content.

The code includes an Input Box for you to enter the date that you wish to search for as I also assume that your data set is large and that you don't want to manually search for the date. You will need to enter the date into the Input Box exactly as you have it in your selected cell.

Do you need the data that is transferred from sheet 1 to sheet 2 cleared once it is transferred?

Following is my test work book for you to peruse:-

I hope that this helps.

Cheerio,
vcoolio.

[MarvinP]

Hi god_karthi and welcome to the forum,

I believe this is an Advanced Filter type of problem where you don't need VBA to do what you want. Read up on Advanced Filters at:
http://www.contextures.com/xladvfilter02.html or
http://www.tushar-mehta.com/publish_...lysis/06.shtml

[god_karthi]

Dear Sir,
Thanks a lot.this is what i need exactly.
.Thanks for your valuable help.

[god_karthi]

Dear Sir,
I am struggle with my problem. with below mentioned
My Data is column "A7" to column "CO"
I want to paste from "D26"
I want to start "D26" and every time this data will clear before paste value.
i have changed format accordingly My requirement.
Your code is working from column A if I change column D26 then the code is not working.and also I find the data is pasting entire row.In this case my formula will going to delete.that I don't want.
If it's possible kindly change code according to my requirement.and I have attached for your easy understand.

This worksheet will use for production data's and every time i am changing date.( I have used calendar, I have changed your code Input box to calendar).
I hope you understand my situation.
Thanks in advance.

[vcoolio]

Hello God_Karthi,

Please bear in mind that you would be helping immensely the volunteers who offer their help on this Forum by telling us exactly what you would like to do right from the beginning.

Anyway, a slightly amended code which should do the task for you follows:-

Please Login or Register  to view this content.

Judging by the good work that you have done, you should be more than capable of making any further required adjustments.

Attached is your updated sample.

Good luck!

Cheerio,
vcoolio.

[god_karthi]

Dear Sir,
Perfect!!! thanks for help,this is what I need exactly
In future I will Keep in my mind do not come in same problem for future Help If I required.
Thanks for Your advise to correct my problem.
God_karthi

[vcoolio]

Hello God_Karthi,

Glad that I could help.

Cheerio,
vcoolio.