Search results for query: *

Hi, Before I ask, I've got to acknowledge I know nothing about VBA except what I've picked up trying to understand what they do. I recently copied a working macro to a new file and tried to duplicate the process by editing certain lines. Now, the first half works, but the For i= piece to loop...

Hi, Before I ask, I've got to acknowledge I know nothing about VBA except what I've picked up trying to understand what they do. I recently copied a working macro to a new file and tried to duplicate the process by editing certain lines. Now, the first half works, but the For i= piece to loop...

I'm hoping someone has something that already works, or it's a simple thing to set up. I have a file with multiple tabs and a lot of sumif formulas that cause the pc to struggle. I need to send these reports (active sheets only) to other people, but want to send only values/formats. Is there...

Hey everyone. I'm fighting an annoying issue and am hoping to find an answer here. In all office programs, when I right click for the short cut menu, it fades in very slowly. I've been unable to find a setting to adjust for this, but feel sure there is one. One pc works great, the other is...

I'm working on a graph and trying to use the Line-Column on two axis style, but can't seem to get the data to hit the right locations on the graph. Here's a sample of the data: Admissions Friendly Cleanliness Speed January 100,000 75% 80% 85% February 101,000 76% 81% 86%...

Greetings, Someone I work with has a macro problem and I'm trying to help out with it...hoping someone here can shed some light. He has a process set up in his Scheduler to open and Excel file every morning at 9:00 am. When it opens, the current macro triggers, adds a new worksheet, retrieves...

Greetings all, I tried using Record Macro for something simple...I wanted to copy the value of a cell, select the auto filter of a column, select Customize under the filter, Select row "Contains", and paste the value on the right side and hit enter. I have a spreadsheet tool that employees use...

Good morning. This will probably be a simple question to answer, but I'm stumped at the moment. When I'm trying to create a formula in a cell and it's referencing the data on a pivot table, the formula comes up with something like =+GETPIVOTDATA("Average of Mtd",$A$3,"Denom",0.01,"Game...

Hope this is the right forum for this, but if not, maybe someone here will still have the answer. A co-worker was telling me that her Enter key on the keyboard 10-key pad doesn't work at all, but the number keys do. We looked through control panel and keyboard settings to see if we could find...

I'm looking for a little help with sumif statements. I understand how they work, but was wondering if there's a way to use Boolean to evaluate 2 ranges to 2 different criteria, and sum the third range. Here's an example: Players 4 $ Min $25 Players 6 $ Min $10 Players 3 $ Min...

Hello All. I've got an area chart that reflects positive and negative values. I've been trying to find a way to show the areas in different colors, depending on the sign of the data. I need the area with positive data to be blue, and the area below zero to be red. Does anyone know if this is...

Hello all, I've stared at this formula way too long and can't find the error. I'd appreciated some fresh eyes to find the problem. In a cell, I have a 15 digit value that, when broken into sections, represents different information. Here's the break down of parts: Cell E2 = 200002000000000...

Good afternoon all, I was approached with an excel question and got it to work using nested if statments, but if there had been one additional column, that option would not have worked. The request was to return the latest item price used over a series of months (Jan - Sept.) Prices skipped...

Good Day all! I was wondering if anyone knows of an option I can turn off that will allow me to reference cells within a pivot table without creating a formula like the following: =+GETPIVOTDATA("Sum of Coin In",$A$3,"Denom",0.01)+F5 In the formula above, I hit "=", selected a cell on the...

Hello all. I've tried a couple of ways and can't get this to work. I'm hoping someone out there has the answer. I tried to use a SUMIF statement to add data when the range meets multiple criteria. Here's what I currently have: =SUMIF(E7:E180,AND("> 6300034","< 6300501"),G7:G180) where...

Hello All, I was asked for help with something and at this time I can't come up with an answer. We need a formula that looks at a weight in pounds, and compares it to ranges to determine what shipping should be. Here's an example of it. Weight Weight Range Shipping 5...

I have a list of names typed in Last, First format within a single column in Excel. Now someone is wanting to separate first and last name to use in mail merge. It would probably be best to break them out into individual columns. Can anyone help with this? Thanks in advance! Example Column...

Hello all, I have rows of data consisting of between 3 to 6 columns of numbers. The goal is to get the 3 highest numbers of those in each row. For better clarification, the data is a series of test scores, where the top 3 are kept and averaged and the rest (if any-there can be up to 6 total)...