copying data from one workbook to another...

[emvs2060]

Hi,

I have huge data in one workbook, with columns having date name etc... result should be I have should copy data of specific dates and paste in another workbook.....

 

[Archangelos]

First of all, I suggest you improve your English. It's a little bit hard to understand what you are talking about.

Secondly, have you ever worked with VBA?

 

[emvs2060]

Hello @Archangelos,

Thank you for your valuable suggestion,

may be u didn't understand... I will be clear to you...

I want a VB code which will help me to copy the data from one workbook to another workbook using some criteria... in below example I want to copy the data of the particular date in to another workbook and paste in the cells asp date in that sheet....,

So, in below example, I want to copy the data of date 05/25/2018 column, and paste in another workbook column which has the same date 05/25/2018. Date is criteria as it should check for date in another workbook and paste the data in that columns only....



Hope u have understood, if you can kindly help me with that code.... and I have some good experience in VBA, as I have struck in this while writing VB Scripts...

Thank you....

eg : below is the sheet look like

Date	Name	Rollno	address
5/25/2018	xxx	123	xxy colony
5/24/2018	yyy	1234	yyy colony
5/23/2018	zzz	12345	Aaa colony

<tbody>
</tbody>