I want to pull Data from a workbook with a contract on (with no set name as diff contracts have different names) into another workbook with a table on. This table then converts into an email (which I am able to do). However I'm having trouble trying to get the vba to copy the ...
I want to create an additional tab where I can generate a full week timetable for a teacher or a class but pulling the data from the 5 daily tabs (Im aware it will be slightly different lookup formula for each tab) but is there a way I can make find all the times CMC...
Re: Pulling data from one spreadsheet based on unique identifier Here is an example VLOOKUP formula for you that references another file to retrieve values starting in A1 of the workbook with the formula Formula: Please Login or Register to view this content. <---If you like someo...
Pulling data from multiple Excel Sheets to a Master I have a workbook with multiple sheets designed to track sales activity. Currently it is set-up so only one person could realistically use it to track their progress. I would like to have individual workbooks for the Sales Associates t...
I have an excel file where when I try to pull data from a cell from one sheet to another, I get a major stall. It only happens from one particular...
I was pulling data from one tab to another using =, then going to the tab I want to pull data from, selecting the cell, then hitting enter... So it looks like this: =Active!D41.. (Active is the name of the tab, D41 is the cell I am referencing...) It's worked over ...
I have one file that uses data that is contained in one of several different files. I specify which file I want to access in the first column of a row, such as DEAL#1 (to retrieve data from file DEAL#1.xlsm). Then I want to put a formula in a different cell that pulls in whatev...
I have a main workbook that I am using, and need to pull in data from other workbooks into various cells. I have atonof other workbooks that I am pulling from, and going into each one is onerous, particularly because the cell reference never changes,...
I am trying to get information to pull from one tab to another and having issues. I believe it is because there can be multiple responses. I am trying to pull information based on table number. I hav... FILTER function Let me refer you to theFILTERandSORTfunctions (which will need...
Hi all, I am looking to see if it is possible to Automatically pull a sheet from another Excel workbook on startup. So i currently have a work...