Need Help on Next button from one excel to another excel to get data

Hi All,

I have joined this forum. I am expecting help from this forum to improve my knowledge . Thanks to everyone and Happy Christmas.


I have attached data1 and data2 sample excel sheet.

Data1 workbook is source data (example data only)

Data2 workbook is output file means - we are using few formulas and will get our required information from data1 workbook.

I am using vlookup formula from data1 to data2 excel. I am every time copy paste "s.no" and getting data.


Requirement : My requirement is to avoid copy paste. So i have created a next button in data2 excel. So please assistance to get data from data1 excel to data2 excel with using "next button".

* Data should come based on s.no and also "date"


Please Help me.................Thanks in Advance