[SOLVED] Excel Macro for linking data between 2 sheets

Kevin_122

Reputable
Apr 7, 2016
15
0
4,520
2
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

Titan
Moderator
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

Reputable
Apr 7, 2016
15
0
4,520
2
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.
 
Last edited by a moderator:

ASK THE COMMUNITY

TRENDING THREADS