-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
indexing row
-
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...- Grawill
- Thread
- Replies: 6
- Forum: Excel Questions
-
A
Index Match along with SMALL and COUNTIF
Hello Guys, I got a three formulae that return results from another worksheet. One of these is working alright - the one that returns the dates. But the two other are not working. I am posting a portion here. Any help is appreciated and THANKS in advance. Excel WorkbookABCD1LAST NAMEFIRST NAMEDC...- asad
- Thread
- Replies: 5
- Forum: Excel Questions
-
K
Transferring Data from Excel into a Database
I am trying to export data from Excel and import it into a database (resultsplus!). I don't have much experience with databases (or excel) and really need help. I feel like I have set everything up right but every time I try to import the info into the database, this message pops up: "An update...- kd3330
- Thread
- Replies: 0
- Forum: Excel Questions
-
R
Help Needed with big spreadsheet
I am new to VBA I am designing a spreadsheet that is used in sports It has a list of players names down a columns with the different skills going across in rows divided in to halves Attack and Defence It has 16 players and 10 skills in Attacks section and 16 Players and 11 Skills In the...- Red02003
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy dates from one sheet to another in range if date is old than 11 months
- Started by DanSMT
- Replies: 35
I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is... -
Date and reference number being inserted into footer after the first page
- Started by dpaton05
- Replies: 36
How do I put things into the footer on all pages after the first using vba? -
Highlight Adjacent Cells in a grid
- Started by JLEMS
- Replies: 33
Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get... -
Calculating lost hours per week
- Started by gd6noob
- Replies: 26
Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start... -
VBA Open .txt file with a string
- Started by ItalianPlatinum
- Replies: 25
I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the... -
Invalid qualifier
- Started by dpaton05
- Replies: 24
I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...