Function, Formula or VBA please help

[LadyHarper]

I have a Spread Sheet Columns A through F

In another work book, I need to pull over information.
I need it to look at Cells A1 and compare this to column B in other book, and look at B1 and compare to column E in other book and give me a list of each line from F that meets those criteria's from the other book.

Please help.

 

[LadyHarper]

Both documents are on Sharepoint. My document I open in Excel app, because the sharepoint version can't handle the links... however multiple people work on the master workbook in the sharepoint version.

so when you click on the cell with the formula, and click on the formula bar and hit enter... it then pulls the data over. I have 8 spots per tab that I've set up to pull over data. and 7 tabs.

I tried to do a macro, to click on command button and have it run through and update each one. It will but as the user I still have to click ok 42 times.

Is there a VBA coding or anything that will auto accept the ok button?

 

[KRice]

I'm only guessing at this point, but from your "my document" workbook (that is pulling information from the source data worksheet in a different workbook), you might try going to Data > Edit Links and then click on the "Startup Prompt" button and then choose "Don't display the alert and don't update automatic links", then confirm with OK and Close. That might kill the annoying error message for each attempt.

 

[KRice]

Another option might be to edit your macro and include the following line in your VBA code.
Application.DisplayAlerts = False