[SOLVED] Excel Macro for linking data between 2 sheets

[Kevin_122]

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

 

[Ralston18]

What you are describing is a "one to many" relationship between Excel File 1 and Excel File 2.

Generally those sort of data structures are more readily addressed by a database.

However, since it is Excel you do have some database like functions built in.

Rows matter but so do columns.

What is(are) the key column(s) that link the rows in Excel File 1 to their many counterparts in Excel File 2.

So when you make a change to a row within Excel File 1 how are the corresponding rows and columns in Excel File 2 identified and the changes being written into those rows and columns?

Are you able to provide the structure of the two Excel Files (no data just the structure/columns)?

For the most part you will probably need to take a look at the bigger picture and the specific requirements that need to be addressed in order to link the spreadsheets in the desired manner.

Start here:

https://www.wallstreetmojo.com/database-in-excel/

 

[Kevin_122]

The names of certain things are the same in excel file 1 and file 2 and i only need to change some number values(prices etc)
I'm gonna add a link to the excel test file i have made to try this out ****

( MODERATOR NOTE - LINK DELETED LED TO A SITE WITH PORN ADS)

This is a smaller version of the actual thing .

But thanks for the help, i will study your given link as well maybe i can make some sense in my problem.

 

[Ralston18]

Not sure what happened but the link was via an inappropriate website.

Seemed to indicate that some download was available but I immediately left the webpage and deleted the link you provided.

 

[Alabalcho]

I doubt you'll find ready-made macro for what you need, so roll your sleeves:

• VBA (Excel Macro Langugage) is quite powerfull;
• For simpler tasks, LOOKUP() and variants can do plenty of your job.

 

[Kevin_122]

Thanks for every thing guys!

I'm gonna try to mess with lookup and maybe i can do something with it, VBA seems kinda out of my league.