How do I create formulas between two workbooks.

[ergonzalez]

I am not sure if this will make sense but I'll give it my best shot.

I have two different workbooks. One is called "Estimator" the second is "Brock Email". I need for "Estimator" to automatically populate the information from the certain cells in "Brock Email".

The only way that I know how to do this is to enter "=" on the cell that I need the formula on and hit "enter" on the "Brock Email" workbook where the information needs to be pulled from.

Is there an easier way to do this?

 

[SkipVought]

Hi,

What easier way would you like, telepathy?

GUI (graphical user interface) is all about point and click with a mouse requiring a minimum of keyboard strokes.

The method you outlined can be performed with ZERO keyboard strokes AND a maximum of SIX point/drag and click operations in a span of approximately 8 seconds (+/- 10%).

Do we have any TELEPATHY SOFTWARE OUT THERE? ;-)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ergonzalez]

It would be easy if I only had to do a few cells, but I've got about over 300 cells that I would need to do that with. Is this the only way

 

[jdhilljr]

Do you have a sheet in the Brock Email that has the data in the format you want?

Jim

 

[SkipVought]

Well, how are the cells related?

If the row and column arder is identical, then you can copy one reference to ALL the other cells.

However, if the relationship is not predictable, it's a manual process.

how is workbook1/sheet1 related to workbook2/sheet2?

Are you doing a lookup from estimator to email? If that's the case, then you have a formula that has a data range that is referenced from the other workbook, something like this...

=VLOOKUP(A1,'[Brock Email.xls]Sheet1'!$C$2:$D$12523,2,FALSE)

where column A (estimator) has values that correspond to column C in Brock Email and column D has the Email lookup value that you want to be returned to workbook Estimator.

Am I on to something?


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ergonzalez]

It has the information but there are several sheets in the Brock Email that I need to transfer to the Estimator. The Brock Email is updated constantly and I need this information to automatically populate to the Estimator. (I also need to transfer 3 other workbooks into the Estimator.)

 

[jdhilljr]

Skip has the right idea but if you create the sheet in the existing workbook the links will be created when you right click on the tab and move it to the other workbook. Then no matter where it goes it will keep the links provided it can reach the path.

Jim

 

[SkipVought]

What are you going to do with all this data?

Its often better to get the specific data that you need, rather than write references to entire tables (especially if you are referencing VAST amounts of data).

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com