CODEWITHSUNDEEP
excelvba
user3074433
user3074433

Reputation: 11

Automate data transfer between workbooks in Excel

I admit to not being very technical and my limit up to now has been using paste links to connect data between sheets. I now have a requirement I cannot figure out.

I have 2 workbooks I wish to automate sharing data between.

Workbook 1 contains multiple rows of data manually entered.

I need a button against each row so when it is pressed data from certain cells on that row in Workbook 1 are transferred to cells within a worksheet in workbook 2

I would be very grateful for any guidance on how to achieve this.

Many thanks!

Upvotes: 1

Views: 9528

Answers (1)

Youbaraj Sharma
Youbaraj Sharma

Reputation: 1295

Though you can deploy VBA to achieve this, but the same is also possible with simple formula like. 

   =[1.xlsx]Sheet1!$A$1

Lets say you have two workbooks 1.xlsx and 2.xlsx and you want sheet1/column A1 value from 1.xlsx to be auto populated in sheet1/column A1 in 2.xlsx, you can simply link it with a formula like =[1.xlsx]Sheet1!$A$1 in second workbook 2.xlsx.

So as soon as some entry is done in first cell, second cell is auto populated

However if you are looking only for vba solution do write back

Upvotes: 1

Related Questions