efficient

  1. A

    Non-volatile substitute for INDIRECT function

    Hi All, I'm currently working on a very large file and excel is consistently crashing on me. I believe this is largely due to the number of indirect functions I'm using. I have 31 sheets, named D1 - D31, for each day of the month. I then have a data sheet and 6 sheets analysing the monthly...
  2. K

    Can anyone speed up my slow code to delete repeated rows?

    The small section of code below is part of a much larger sub and works fine, however for some reason it takes very long to run (longer than the rest of my code). I have no idea why it is running so slowly, perhaps something to do with the 3 nested IF loops; Is there anyway to run it more...
  3. K

    What is more efficient?

    I have several tabs that break out specific data for different locations. </SPAN> I am creating another tab summarize the data. What I am wanting to know is it more efficient to subtotal the data on each location tab and then total the sub totals on the summary tab or is it better to total...
  4. J

    Need ideas on copying columns from one workbook to another

    The reason I am posting is to find an efficient (read quick) way to copy a pair of cells from one worksheet to another using matching unique values in "A". Essentially, data is coming from two different databases into two spreadsheet reports with one having two cells per record that need...
  5. G

    Help with something more effcient (CPU usage high)

    I have this performing the tasks needed, however when ever data is changed or the file is saved, Excel takes 30-60 seconds to complete the task. I'm sure there is a more effcient way of performing the same task, but I'm at a loss. I've linked to an example with 50 rows of fake data to...
  6. A

    better way? - sumifs question

    i am currently using sumifs to selectively grab data from one tab (29000 rows) for display in several other tabs. On any given destination tab, there is between 2000 and 15000 individual formulas, with four sets of criteria within each of these sumifs formula. Is there a better (more efficient...
  7. S

    Calendar and SUMPRODUCT

    I am trying to maintain a list of classes and use the data to create a calendar. The data includes a teacher, classroom, class name, start date, and end date. I am open to manipulating the data, but ultimately want it to create a visual calendar similar to a Gannt chart and that will identify...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top