Hello everybody!
The deal is that i have 1 excel file that has 2 sheets with alot of data and i need to make a link from 1 sheet to the second sheet.
So when i change data in the 1st sheet the corresponding data will change in sheet 2.
But the thing is linking needs alot of manual work and the 1st sheet has like 20 or so rows but the second sheet has like 15k rows.
I need to find a solution to link these 20 rows to corresponding 15k rows and manually it would take hours if not days.
If someone has done this kind of macro or something similar, please let me know.
Thanks,
Kevin
The deal is that i have 1 excel file that has 2 sheets with alot of data and i need to make a link from 1 sheet to the second sheet.
So when i change data in the 1st sheet the corresponding data will change in sheet 2.
But the thing is linking needs alot of manual work and the 1st sheet has like 20 or so rows but the second sheet has like 15k rows.
I need to find a solution to link these 20 rows to corresponding 15k rows and manually it would take hours if not days.
If someone has done this kind of macro or something similar, please let me know.
Thanks,
Kevin