link between worksheets

Hi, I have an excel sheet which people use to list the samples requested for each potential client on each day, so this sheet will have multiple entries under the main column headings, product code, description, quantity, client and date. A simple columnar format. I want to link this main...

In my summary file, I need to link to a cell in a second file. If the second file is named "East Coast.xlsx", I simply type: +'[East Coast.xlsx]Sheet1'!$B$1 But in my summary file, I want to type in the name of the file I want to look up and all my formulas automatically point to the...

Not sure what the best way to accomplish this is but I have a master database table which has all the information I want on an employee. I want to create a new sheet which only includes certain parts of the master spreadsheet data. I want the data on Sheet 2 to change when new data is entered or...

Hi, Read about the Dfunctions and SUMIFS/COUNTIFS not working between linked objects and think my error is the same. If not can someone please let me know why. SYMPTOMS: Formulas wont work unless linked workbooks are open. Once open they work and as soon as the sheet is altered after they are...

Hi; I am having some problems and would really appreciate any help I have column A of workbook B linking to data in column A of workbook A; then column B of workbook B has independent data values. When I sort column A of workbook A the data points move in workbook B; and then columns A and B...

I have a workbook with 2 worksheets. I know I can link 2 cells between worksheets, therefore if I change the contents in Cell A1 in Sheet 1, it will then show the updated value in Sheet 2 where I have entered that I want the value in Cell “Sheet 2:Z1” is the same value as “Sheet 1! A1”...