efficient

I definitely need a faster way to accomplish this so any help would be appreciated...for examples sake I have a userform with 50 textboxes and the control sources are A1-A50...Now I need 10 more of the exact same UserForms except the control boxes will be B1-B50, C1-C50 and so on and so forth...

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...

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...

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...

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...

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...

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...

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...