linking data worksheets

  1. M

    Reference to Data of a cell from another excel sheet - Increment Automatically

    Hello Sirs, I have an excel file as log showing the details of drawings received - such as Reference Number, Attachments details & Drawing Titles etc. (Say the file name name as "Register1"). I wanted to make transmittal for each item in another excel file (say file name as "Transmittal1")...
  2. R

    Linking data from one sheet to another and editing

    Hi All, I have a master data sheet where information about multiple users is present in columns A - Z with column A being the user name. I then want to create a separate sheet for each user and extract the information specific for that user on their sheet. Next, I want the user to make edits...
  3. A

    working with macros: keyword search into a new sheet from my basesheet with 1000 entries.

    hi..i am very new to excel and with macros as well..but i want to know if I am having a spreadsheet with around more than 1000 products in a single column and a corresponding column with another value and i want to create a list of 10 products from the base sheet into a new worksheet by only...
  4. E

    Get Data from other excell files

    I have 12 excel files that contain a column with dates. The dates occur multiple times. I need to count the number of occurances of each date on all 12 files. Is there a way to do this with a formula or array? Example, <tbody> Date column on file 1 6-1-2015 6-1-2015 6-3-2015...
  5. D

    Linking Multiple Files/Multiple Sheets

    Hello! First time posting here, though have come often searching for help. This time I couldn't find it just using the search engine. I hope someone can help. I have one master excel spreadsheet displaying jobs daily. Every day has a new tab. I have 5 other files that are distributed to...
  6. C

    Need help determing functions, programming needed for Worksheet (to help a cancer patient)

    <tbody> First of all, thank you in advance for your help with the four questions I have below! Background: I am trying to help a doctor communicate to a cancer patient about her medications, and for the patient to have a worksheet to check off all the meds she is supposed to take each time of...
  7. J

    Linking cells from multiple sheets into one "summary" sheet

    Hi, I have a work book that has about 20 pages in it. Each page has the same kind of data on about different products I want to sum them up in a final worksheet that groups them all together in one table. If on the final worksheet I link to the first sheet cell A9, i.e. Sheet1!A9 is there a...
  8. A

    "#REF!" or other errors when linking two files

    I have two Excel files open. One contains a table of data. The columns represent months; the rows represent sales and expense figures for various regions and business units. The other file contains formulas which link to the data in the first file. The formulas include VLOOKUP or HLOOKUP. For...
  9. S

    linking data from two spreadsheets

    I have exported customer data from two separate files in our accounting system to Excel. The "masterfile" worksheet contains the customer number, company name, address, city, state, zip information. The "contact" worksheet contains the customer number, contact name, phone, email. The one...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top