external workbook

I have a workbook, workbook A, with lots of cells that link to a source workbook, workbook B. I copied workbook A from my hard drive at work to do some stuff at home, but I did not copy workbook B. I can't figure out how, but when I open workbook A (at home), the links to workbook B appear to...

I have an excel file that opens two seperate excel files, copies all the tabs from a pre-existing xls to a template xls, saves them both with new names and then closes both. Everything is working fine, except I need to delete a pre-existing worksheet in the original file and then hide the...

Hello, After two days of googling (since om still a beginner) I have yet not found a solution to this (probably easy to solve) problem. I will firstly try to explain the problem and afterward the whole idea of the solution (if anyone wants to comment). I am trying to copy values from two...

I'm building an excel report consolidating data from various other workbooks and worksheets using cell references ( i.e. =[Book2]Sheet1!$E$5). Since these referenced workbooks are built by an external organization, I'm concerned about formatting changing. I'm familiar with using "&B1&" in...

I have coded a macro that takes a data export from a companies proprietary system, manipulates some fields, and then saves as a new sheet to be parsed back into the system. The problem is that I just found out that the format of the data export, as in column order and extra columns, will change...

I have several workbooks. One contains references to various cells in each of the other workbooks. Everything seems to pull through quite nicely except for cells containing text. Cells that refer to another cell containing numbers pull through to my spreadsheet but text does not. Any help is...

Hi, I am using the indirect funciton combined with the match funciton to look up cells from external workbooks. All the workbooks are open however I am faced with a sheet full of #ref cells :mad:. Yesterday the same thing happened, although the sheet decided to work an hour after my...