data pull

So yeah I used basic cell reference to other workbook, then I deleted this workbook, but numbers stayed ? When I try renter this formula, all it asks me is to find file path, once I cancel it just take numbers from deleted file. I was expecting it to give an Error..

Hello, I have a list of account numbers in the format of "XXXX-YYY-ZZZ- -" in column A, specifically A6-A684. Is there a function in excel, similar to Vlookup, that would pull out any and all account numbers that match a certain criteria? For instance, ideally, I would want to pull out any...

Hi- I am trying to auto update data inputs from OneDrive excel online to my desktop. Essentially- I operate a model on my desktop that has historically used manually inputed data on a per project basis. I am now in need of a way to pull the data from an online source automatically as the...

Is there a way to create a macro for a 3500 line excel file to take the prepopulated weblink, paste into a web browser and then grab a 10 digit code that is always in the same spot? The data I want to grab is also visible when looking at the data in chrome source, so the grab could be like find...

Here's a remarkable problem concerning function behaviour of functions when used between worksheets. I've not been able to explain or solve it up to now, despite looking in several books and consulting this and other Excel forums. It is easy enough to define a macro sub on worksheet S (source)...

Hi I will try and make this as brief as possible. 1 workbook, 2 sheets. Sheet 1 has master listing (about 20K lines) and Sheet 2 has a listing with serial numbers and dates. They both have columns for item code but sheet 1 includes more items then Sheet 2 so I want a formula to look at the...