excel2010

I have recently changed from excel 2003 to excel 2010. And found to my disappointment that I can no longer graphically modify points in the series. In the 2003 version, I could click on the series in the trend and then click at a single point and then drag and drop the point to the desired...

Is there a formula that can count based on dates? Here's the scoop. I created a spreadsheet which I would like for it to track trainings based on days, I added an =COUNTA(A1:A100) formula which counts the amount of people trained but what happens is that it counts people trained all week long...

I need your help, MrExcel. I am using Excel2010. The workspace consists of specific roles that needs to be filled at all times by competent staff. There are more workers than roles, and the workers may be competent in more than 1 role each. For the sake of this example I'll cut the number of...

When I have two workbooks open and running in separate instances of Excel 2010 and one has set Application.CutCopyMode to False then I am prevented from copying and pasting in the other workbook. Is there a way in VBA to use CutCopyMode or anything similar to avoid that workbook's overuse of...

I am trying to use a formula that states the following: If A4 = T Then Vlookup Else Vlookup2 Here is what I have written that it does not like. =IF(A4 = "T","=VLOOKUP(I4,treatlookup,11,FALSE)","=VLOOKUP(I4,itemlookup,22,FALSE)") I tried without the quotes around the =Vlookup but it does not...

Hi All, I have several Excel spreedsheet which use UserForms with calendar controls. As Microsoft has removed this from Excel 2010 (version 14?) When such versions open my spreadsheets, it removed the calendar control and makes them unuseable to following Users. Does anyone know of the code...

Happy 2014 to you all Hi I would really appreciate any help and/or guidance offered to hopefully resolve a custom rounding problem in Excel 2010/2013. The function will be applied to a results column containing numbers with two decimal places. For general layout please see Table 1 <tbody> E...

Hi. I am using Excel2010. My sheet displays values collected from a database via an AddIn. The values are updated by pressing CTRL+G (AddIn function). I have an OnTime macro running SendKeys "^G" to update the values every minute. When the values exceed a certain limit, a sound is played from a...

Hi all I need help with times in excel 2010 I exported a list of mp3 durations, but the column shows minutes as hours. For example, mp3 duration: 7 minutes and 30 seconds in the csv exported files shows as 7:30:00 Plus, those mp3 with duration over 24 minutes, show also wrong For example mp3...

Hi, I have a macro to spell check a protected workbook in excel 2010: Sub Spellcheck() ActiveSheet.Unprotect Password:="Project Delivery" Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=2057 '2053 ActiveSheet.Protect...

Now I want to get the 4 Digits highlighted below. Not Including special character like dots etc. <tbody> C:\Users\sponrmt\Desktop\C05\C05\DVD COPIES\LAC\BRA\167405\167405-2545- JENNIFER YASMIN SILVA M LUZ.JPG C:\Users\sponrmt\Desktop\C05\C05\DVD COPIES\LAC\BRA\167406\167406A2.764...

Hello, Please can someone help me with a question regarding Pivot Tables and GrandTotals. For example I have the data below I am using in my Pivot Table: Name Amount Amount USD Value Jim £100.00 $150.00 Rob £200.00 $250.00 Dave...

I have written this formula below. I do not know the correct part of this formula that will add the numbers I have in Column AB2:AB552 (bold below). As it is, this formula is counting the number of cells in that range that has numbers in it, but I need it to total those numbers as my final...

Same old song and dance-I'm new to VBA, and new to the forum, so bear with me. I have a tendency to be long winded, so I'll try to keep it simple. I've built a userform that has checkboxes on the second tab. I want the user to be able to check a box and have that populate blanks in a textbox...

Good Morning - I am new to the forums and spent much of the past two days reading through threads to try and accomplish this but with little success. With little familiarity with VBA (I had to use the Macro recorder to just get this done) - I would like this code which runs correctly for the...

Hi, My first post! Hopefully all inline with Forum rules ... :) I'm a relatively experienced Excel / VBA user, but I've come across an interesting problem. I develop/own a large set of workbooks that contain code, and recently users have been complaining that Excel has been hanging, with no...

i wonder is there possible to not using .copy but still get the value from range and put it to another range and still got same text alignt, text size, font bolt?

Hi ... i have Myspreadsheet.xlsb then i converted to Myspreadsheet.exe . so when i want copy sheet from : Source: Myspreadsheet.xlsb to Destination: Myspreadsheet.exe i faced the source dont see the Dest. as open workbook ,so what shall i do with this ,and can i know from expert why...

Is there a way to create and new macro that i can link to a button that will create an new sheet copy my format of a previous sheet, then apply that to the new sheet, then change the name of the new sheet to the current date (but the date in the macro has to imput the current date so it would...

ok i i am working on my school final exam and i need to make a conditional format useing an if statement that allows the cells that need information to be typed into to be highlighted but i want to keep it clean so i dont want a half of page of highlighted cells. Is there an IF statement that...