multiple tabs

I am looking for a way to populate a summary table. I export multiple sources of data, which all have the same information but arranged in a different way. The constant would be the date that I keep on the far left. So what I am looking for is a way to use the date then look up the column...

Hi, I'm new to VBA and Macros so apologies for that! What I have managed to achieve so far based on online forums and guides, is to hide or unhide a column and 'rows in a different sheet' based on a data validation selection in a cell. Example: <tbody> Stages Yes or No Stage 1 Yes Stage...

I have a multi tab template which has been significantly revised. I need to migrate the data from about 500 files of the old template to the new one. This would involve copying and pasting multiple ranges from multiple tabs in old workbook to multiple tabs in the new workbook. (probably about...

I have a workbook with multiple sheets of data and all are in the same format (data with the same headers in columns A:I). However, the number of rows with data is a variable - different for each sheet. I want it to sort column A ascending and column I descending, and then remove duplicates -...

Hi all, I am currently working in a spreadsheet with multible tabs, where the format is the same: a table where values (text) from column 5-row 3 (and down), column 6-row 3 (and down) and column 7-row 3 (and down) should be transferred into a PDF with a table consisting of the three columns...

Hi there, Below is a formula I’m working on. I want, if possible, for excel to look in tabs "acctg" through "RM finish Bundling" for the text that i have in '2015 Consolidated!A96'. The formula works if i only use one tab, but if I could have it look through all those tabs, it would help me...

Hi I have a workbook that contains numerous tabs. Each tab is a new vendor and contains information in a table format. Every tab/table is the same. I would like to find an easier way to get all of the data into one sheet rather than copying the table from sheet 2 paste into cell A1 of sheet 1...

Hi there! I have multiple tabs - all formatted the same. I'd like to combine all of my tabs onto one master sheet. Each tab contains payroll data for that period. I would like all periods to show up on one sheet. Thank you!

I have a massive amount of data in an excel spreadsheet that spans about 500 different tabs. How can I consolidate those into one single tab without the copy paste function which would take an entire working day for me?

I am using Excel to store database items for university classes. Each class has 4 groups each with a TA (teaching assistant). There are about 30 students / class. Each group has 7 to 9 students. Every week there are 2 or 3 scores for each student. Every month there are an additional 2 or 3...

Hi, I have put together a spreadsheet that shows all the holidays booked for the people in my department with each month on a separate tab. I am also in the process of creating a central shared spreadsheet where anyone can go in and have access to this information, I would like to know if there...

Hello All: I am looking to extract data (k-12 registration data) from a large spreadsheet and parse it out to smaller tabs (by grade levels). I've tried reverse engineering a formula from Mr. Excel YouTube #789, but I can't seem to wrap my head around the formula. For example: Student ID |...

Hi all The formula =SUMPRODUCT(SUMIF(INDIRECT("'"&"Tabs"&"'!A:A"),$B$348,INDIRECT("'"&"Tabs"&"'!S:S"))) is not working, it returns #REF Tabs range is defined as =OFFSET('Tab List'!$A$1,0,0,COUNTA('Tab List'!$A:$A),1) Can I reference entire columns in SUMPRODUCT??? I have to do this really...

I currently receive a report every week on maintenance costs. Each week a new tab is made with the total costs for that week. I would like to make separate sheet that takes the weekly total every week and adds it to the data list for graphing. I am assuming there are 2 parts to this. I would...

Hello, I currently have a workbook where I have two tabs. The second tab is a copy/paste from an export where the columns will remain the same though the length may differ. I have the following formula that works great for getting the hours an employee worked on a certain project. =SUMIF('ADP...

I have a sheet that has day-wise data. Each day in September has one tab and they are named as Setember1, September2 etc. I wish to consolidate the data in a second sheet where there is a column with dates from 9/1/2011 through 9/30/2011 by using vlookup. =VLOOKUP(R[-2]C,'[Website...

Hi everyone, I'm a newbie to this whole Excel thing, but now I have a huge headache trying to figure this puppy out, so any help you can offer would be awesome. I have an excel sheet with 6 tabs, all containing different data, some text and some numerical. I need to perfect this formula to...

I would like to take a list from one tab and display that information into a calendar on a second tab as well as highlight those dates using conditional formatting. The tasks will always remain the same, but the dates will be variable. For example List: Task Start Date End Date Task 1...

Quick question about pivot tables. I have an Excel Spreadsheet with multiple tabs (for various locations) with revenue detail for a 12 month period. I would like to distribute the tabs to their respective managers but would like to remove the option for them to select other locations. I want...

Not exactly sure what this is called or what is needed, so I apologize in advance if there is a thread devoted to it (please direct me to it if that be the case!). But what I am trying to do is populate one worksheet (in the same workbook) with data from many (ie 500) separate tabs. An example...