multiple sheets

I have two sheets, "Operation" and "EHSQ", I want to be able to hide and unhide certain columns on these sheets, I am thinking of using a a shape and assign the macro where the user can press, like Q1, Q2, Q3 etc. So the user hits Q1, if the columns are unhidden, then the macro hides it and vice...

I am trying to write/find VBA code that can consolidate multiple workbooks that have multiple sheets into 1 larger file. Each file/workbook is called by the month it was generated in. Each sheet (and there are 12) are called in numberical order: 1, 2, 3, 4.... 12. Each sheet has different...

I am very new to VBA. I have been trying to find the right VBA stuff to use to be able to copy over colors from another sheet. There are 6 different sheets in which I want to change the colors on the first sheet and want the designated cells in the next 5 sheets to change colors. I feel like I...

Hi everyone, Could anyone please tell me how to write a VBA to do this simple task (but not easy for me ^^!, sadly)? I have a workbook that contains many sheets (maybe 30 sheets or more) which their names are quite random. Then I will create a sheet named Master and calculate very simple...

Another problem with VBA and charts.... I need to populate a chart with data from multiple worksheets, only where the InRange value is True. I don't want several different overlapping data, the result should be summed, as if in one sequence. So for example 5 sheets each with 1000 cells, there...

I have a document with 37 sheets. Each sheet has a table with an identical list of thousands of products in column A, with different metrics associated to the products in columns B through G on each sheet. I'm not sure if this is even possible, but what I want to have happen is: - Delete any...

Hi all, I need assistance with a VLOOKUP formula or if you know of another formula that can do the job, that would be great. I have a workbook with two worksheets. sheet1 and sheet2 Both worksheets each have one table. sheet1 has table1 and sheet2 has table2 Both tables have different data and...

Hi Everyone, I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...

Hi Good People. I have an excel workbook with 5 different work sheets. First work sheet is the Master sheet and others are customer data sheets . I want a VBA loop to go through all 4 customer data sheets >> then copy a specific range in each individual sheets >> paste it to master sheet...

I have been working on this macro for what seems like forever and I just can't get it to work. I have a data set and when employees are terminated their names are removed from the spreadsheet and I need any monthly sales data to also be deleted. Employee names all "feed" from a main...

I am trying to build a macro that will hide or show a group of rows in the Options sheet (shown below) based on the Yes/No responses from the Questions sheet. Essentially, someone will fill out the Questions sheet to narrow down what they actually need to see and then further define their needs...

Hi all, trying to sum up across multiple sheets. Caveat: the cells being added up are all the same cell address as the active cell, just on different sheets. My troubles: I'd like to be able to insert rows or columns across all tabs and have the formula adjust to always be summing the equivalent...

Can someone please help me copy a specific range from multiple worksheet and paste it into one worksheet? The worksheets are formatted identically. I need the ranges B11:B24 and C11:C24 of each worksheet to be pasted on a new worksheet. Also, I need D5 of each worksheet to replace C11 in the new...

I have a macro that I'm using to alphabetize an attendance list and then delete the 'Blank' rows (the cells actually return "" so, when sorted in descending order, they appear above the sorted list of names) Below is the code, that seems to work perfectly - but it currently only runs in the...

Hi! I'm a beginner with VBA and would greatly appreciate any help or advice. I have a command button set up on Sheet1 that when you click the button, 3 different worksheets (all in the same workbook) will print, but will only print a certain number of pages from each worksheet. The code I have...

I have created an example version of the spreadsheet I am attempting to create. Each months sheet looks like what I have posted below. I am looking to use one of these sheets each month. I would then like an analysis tab where I can look at; -Overall Average of "Test Scores" - (I can and have...

Hi, I am struggling to make a hyperlink into a picture into a comment. I am exporting checklists to excel where the user has to take pictures for some of the checkpoints, and when I export them, they appear as hyperlinks in excel. Now, I want to transform these hyperlinks into images placed in...

Hello! I am trying to count items but they are linked across tables. Sheet 1 - Has the schools listed by city Cities Schools Boston Maple Elementary Boston Elm Middle School Boston Cedar Elementary Los Angeles Bamboo Elementary New York Pine High School New York Ficus High...

Hello, I'm looking for suggestions on the best way to get this routine to loop itself through every sheet after Sheet2. So, starting with Sheet3 and on, I'm wanting this routine to go through each Sheet and copy the values from the following ranges, ("P6:P"), ("R6:T"), ("V6:V"), and then paste...

Hello all, happy to be a new member here and looking forward to becoming an active member of the community. Here's my problem: I have a workbook that contains 230 sheets which are essentially forms that are pulling data from the first master sheet. Each sheet is named after a specific...