multiple tabs lookup

I have a spreadsheet with 30+ tabs. All tabs have the same columnar setup I need to pull out all rows across all tabs which contain a single value found in a column cell (in this case; column C) Ideally, the report should include the tab name Some customer order numbers exist over different tabs...

Hello, This is my first post and I'm somewhat new to Macros. I'm currently working on fixing a Macro for my manager and it is currently fixed and doing what we want but there is one "cosmetic" that we would like to fix. Currently the macro is looking at a template to get column headers and...

I am trying to link several workbooks together so that I may provide my work with an easy way to calibrate tools. I have the main interface excel workbook which takes user entry and I want it to populate data based on different dropdown selections and I them want to save data to different files...

Hi Everyone - I am stumped on building this formula out to incorporate multiple criteria across multiple tabs. I have spent hours searching for a similar problem and I cannot find anything that works. I hope someone can help. Currently, I have 2 criteria and only 2 tabs to look through, BUT...

Hi! I have a bit more than 100 tabs in my Excel workbook. All have peoples names in A column. Can I copy with some formula or script names of all those tabs to new Summary tab? Some names may appear on several tabs. I do not care if those names come to Summary-tabs several times. I can later on...

Hello all, I'm new around here and already you guys have been awesome with helping me get better at Excel. I am learning a lot and am very grateful for this forum and its members. So, I have a column of ten values on a tab called HOF in Cells B51:B60. Each of these values represents the ten...