Forum Discussion

Mrinal1996's avatar
Mrinal1996
Copper Contributor
May 22, 2020
Solved

A doubt in merging two Excel Sheets

Hi ,      So I have been facing trouble in merging two Excel sheets. I have two sheets, which are lat_long.xlsx and Producer_Network_Weighted_w_Coordinates_Subset(1).xlsx. I need to incorporate the ...
excel
Excel on Mac
Formulas and Functions
office 365
bhushan_z's avatar
bhushan_z
Iron Contributor
May 23, 2020

Mrinal1996 

 

https://www.youtube.com/watch?v=XwL6RpAk8k8

Go through this video, it will give u fair idea.

 

Note: This is not my video

Mrinal1996's avatar
Mrinal1996
Copper Contributor
May 23, 2020

Hi bhushan_z .I undertstand the material.But how do I use this concept  when there are two .xlsx files .What is the link between them both?

  • bhushan_z's avatar
    bhushan_z
    Iron Contributor
    May 24, 2020
    ohhh, i have copied the data and kept in one excel file only.
    You can do the same with 2 excel file as well.
    • Mrinal1996's avatar
      Mrinal1996
      Copper Contributor
      May 26, 2020
      Gotcha! Thanks for getting back to me , bhushan_z.

Resources