linked documents

These 2 Workbooks are linked. I want to delete the blank rows of Table 2 (Right side) so that the filled rows get sequentially arranged. Need a function/vba to run through Table 1 (left) each time from start to reassess this and delete the blanks of Table 2 because some 'Approved' may be...

Hi all, - I keep all my information in "document 1" (protected with password) - A second file "document 2" will be accessible for other people as well. In document 2, I have linked a column to a column in document 1 (a column that does not contain private information). Now, when the other...

Hi there, I need some help please! I'm linking with another document to find dates for when people need to attend refresher courses. The other document was created by someone else, and I don't have permission to modify the other document to change the format of the dates, so the dates that...

Our company has recently transitioned to Excel 2010. I have a worksheet that links to and pull data from multiple worksheets on a network drive. This worksheet needed to be transfered to 2010 and reformatted in order to work properly. My concern is that all the files it links to are still in...