linking data worksheets

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")...

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...

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...

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...

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...

<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...

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...

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...

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...