multiple sheets

  1. D

    creating multiple PDFs by looping through number list

    The code below is part of a macro being used to create a list of numbers and then loop through those numbers one at a time, place the number into cell I1 which is linked to numerous other sheets. Each of those sheets has a formula in cell Z1 that sets to "Yes" or "No" depending on if the...
  2. J

    Formula will not automatically adjust for different rows?

    I could use some help with this formula: =(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B11:K11"),"<>"))) This formula is counting the amount of times a value appears in cells B11:K11. The cells A32:A34 refer to the names of different worksheets – Week 1, Week 2 and Week 3. The formula itself...
  3. J

    Countifs formula across multiple sheets

    I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the dates on Sheets2 (Column I) is more than 7 days later than the date on Adds Drops (Column B) for...
  4. J

    Countifs formula if date is greater than 7 days for student IDs across multiple sheets

    I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the dates on Sheets2 (Column I) is more than 7 days later than the date on Adds Drops (Column B) for...
  5. K

    On Multiple Sheets Convert Formulas to Values

    Hi all, I'm trying to make a button click change all cell formulas on 5 different sheets to the cell values. The code I have below is perfect for the currently active sheet but I haven't had any success with specifying which sheets I want it to affect. Any help would be so greatly appreciated...
  6. J

    VBA code to hide/unhide rows that have a "1" in column A - 32 sheets

    Greetings - I have learned a lot over the years from reviewing these threads. I'm hoping someone can assist. I have a workbook with 33 sheets. Two summary sheets and 31 data sheets. The first sheet "Monthly" has data within that will be changed regularly. All other sheets have an A column...
  7. C

    Multiple sheet printing based on cell value in each sheet

    Hi All, despite much searching and trials I almost have what I need but cannot work out the last bit. I have 7 sheets as part of a training course session for each day of the week and two other sheets that have various stats on them drawn from the formula on the Monday to Friday sheets. The...
  8. S

    VBA Sort By 2 Columns On Certain Worksheets Within A Workbook

    I created the following code to sort one sheet by 2 columns, but I would like to change the code to include other sheets (but not all the sheets w/in the workbook). How can I do that? All the data will be in the same columns and cells on each sheet. Also, can I still use the sheet names or...
  9. M

    How to add identical slicers to multiple sheets with identical Tables headers on each sheet

    Hi all I'm new here, and have been unable to find a solution to my specific query online or in forums, so I hope somebody can help me. The problem is with Slicers. I work in construction, pricing up potential projects. We produce a 'Report' from our software and I have manipulated this data...
  10. K

    Vlookup formula that returns multiple answers by searching through multiple worksheets in a single workbook

    Hi, I am trying to determine if I am using the correct type of formula and figure out why I am getting an error with the formula I am using (maybe I should use a different formula completely.. such as an index or some sort of array or a if... IDK). I need to search column C row 1:556, on...
  11. X

    Find a max value across multiple sheets and return sheet name

    I would like to find the largest value across multiple sheets and return the sheet name where the value is located in. The issue is that each week a new sheet is added so I can't create a static list of sheet names. The data are located in the same cell across sheets in cell B10. I have hidden...
  12. F

    Extracting Data From Multiple Sheets into 1 Sheet

    I'm working with multiple worksheets in one workbook and want to find a way to extract data from the multiple tabs into one sheet. Each tab has different headers, see below. I only want to pull out certain data. Each worksheet would be updated weekly. TAB 1 HEADERS: <tbody> Shoot Date Air...
  13. M

    VBA to Hide/Unhide Worksheets using Checkboxes (FormControl or ActiveX) and IF statement

    I have been trying to create a code that would hide/unhide certain worksheets based on the value formulated in Column R resulting from the Checkbox control value in Column Q indicated by TRUE or FALSE. See below- <tbody> COLUMN Q COLUMN R Checkbox () Control Formula Sheet() Formulas...
  14. J

    Help needed, data input

    Hi all, was hoping someone could offer some advice/help. Trying to devise a way of logging payments using a simple userform. I was hoping to have individual sheets for individual jobs with a dropdown on the userform correlating to each sheet - hope is that user would have to select job...
  15. C

    VLOOKUP from Notepad to Excel (Two sheets)

    Hi, I have been looking at VLOOKUP threads across the forum and could not find specific to my needs. I tried to adjust the code elsewhere to my needs, but I am pathetically unsuccessful. I hope somebody could please help me here. Thanks. I have a notepad file (I could make it excel also if...
  16. C

    sumif across multiple sheets

    I have sheets named Jun 2012, Jul 2012...to Mar 2015 I want to sum (across all sheets) s:s if r:r =q2 I have seen this formula =SUMPRODUCT(SUMIF(INDIRECT("'"&Z1:Z212&"'!B3"),99,INDIRECT("'"&Z1:Z212&"'!G3"))) But cant seem to tailor it to my needs I have a list on the sheets running from...
  17. K

    using same filter in multiple sheets

    This is my scenario. - I have close to 20 worksheets in my Excel file. They have the same header columns. - I need to filter column C, the criteria being a text ("ABC") - This filter needs to go in all the sheets. Can anyone suggest a VB code for this? I am not familiar with VB and codes...
  18. P

    How do I populate a change on a template across multiple sheets in a workbook?

    I have an excel spreadsheet with the first sheet that acts as a “template form”. I complete the form, and then run my macro that creates a copy into a new sheet and then clears the data and selections from the template.<o:p></o:p> <o:p></o:p> Every now and then the template needs to be updated...
  19. B

    How to Return into Single Cell the Text from Multiple Columns Same Row.

    Hello, This is my first post so please excuse me if I do something wrong. I have a workbook that contains approximately 260 sheets, uniquely named. Each sheet contains a row, say row 22 that is labeled in column A "Review Comments:". Column C through Column Z "MAY" contain text comments i.e...
  20. B

    Index and Match - Gathering data from columns with no headers

    Hi guys, I am having some issues with Index and Match for a project that I am working on. I have a list of employees where I wish to gather data to calculate their targets. Where I get stuck is the source table is not setup the way a typical index table would be. Column A has the employees...

Some videos you may like

This Week's Hot Topics

Top