Excel

[Smoakstack]

Besides Macros, is there a way to link one workbook to another?

 

[crook_101]

Hi,

Many, many ways, what are you trying to achieve??

Ian

 

[Smoakstack]

To put simply, Company cannot use macros. Looking to link from one workbook to another. I am looking to pull certain information (ie range C3:C10).

But I think I just figured it out by establishing a connection and choosing the correct table.

Thanks anyway!

Unless you know of a quicker route because this is slow?

 

[Smoakstack]

Sorry I did not explain. I am linking three workbooks to contain one set of information. If any of the info changes on the three workbooks, I need the final to update as well. Reason I have so many workbooks is that the source is coming from some other software that limits user controls.

 

[crook_101]

If you could post a bit more detail would help immensely...if you are pulling data that has the same fields in both tables you can use a vlookup or Index/Match or if it is just a case of C3 in Sheet1 is the Same as C3 in Sheet3, just use an "=" sign.

As above, a bit more detail would help a more detailed answer

Ian

 

[Smoakstack]

Ok. Workbook one well call WB1. Then I also have WB2 and WB3. Each of these Workbooks has 10 sheets. 9 of the 10 pulls data from the tenth. That tenth sheet of each workbook pulls the data from some other software. What I am trying to accomplish is to make a new workbook (WB4) and have data from range (C3:C10) on sheet 1 of WB1 and sheet 1 of WB2 and Sheet 1 from WB3 show up on sheet 1 of WB4.

I hope you follow. I figured it out, but its rather slow. maybe just need some tweeking.