Copy and Paste data from one book to onother book

[JawaharPrem]

Hi all,

I book name "MC data" and another Book name "Main Data".
I need to copy the data from "MC" to "Main" based on date.
example : - in MC book Q Coloum i have mentioned date, if Date 1st Aug, the data should be updated in 1st aug of "main date" book, it is possible please help on same.

Sample file has enclosed for reference.

Thanks
Jawahar Prem

 

[rahulshewale1]

hiii,


Please find the attached Sheet.

Try below formula
=IF('mc data'!$Q$1='Main sheet'!$A3,INDEX('mc data'!$A$3:$M$3,,MATCH('Main sheet'!H$1,'mc data'!$A$1:$M$1,0)),"")


Note:just reference as you need

Thanks
Rahul shewale

 

[JawaharPrem]

Hi Rahul,

Thanks its working fine, one doubt when it comes to next day, daybefore data is gone, its any possible to make auto pastespecial value on every daybefore data.

Thanks
Jawahar Prem