excel 2010

Due to my disability and medical problems, I have to use Windows dark themes. And therefore the font colour that I use is white on dark background. However, the people with whom I shared my files are usually using light themes which means they need dark font on white background. This issue...

I'm using Microsoft Excel 2010 and had a few useful add-ins like flex find installed. https://www.jkp-ads.com/officemarketplaceff-en.asp.However, I do not use these add-ins frequently. Since it seems that Microsoft excel 2010 loads, these add-ins at start-up and it significantly increases the...

Hi, I've had some code running in outlook for about 6 months at least now and been working fine however since about a month ago it stopped working and i cannot figure out the reason why... It keeps telling me that the file doesn't exist..., i've changed application visible to true and i can...

I have a computer program that frequently creates new files in a given directory. I then have to open the latest file in Microsoft Excel in that directory and work on it. Whenever I do Ctrl+O and bring up the file open dialogue box, it brings up the list of files in the given directory with...

I have an Excel 2010 workbook that includes the detail for a portion of the population of data. The portion was selected based on certain criteria. Research was completed to test compliance. The results are displayed in a pivot table. I need to calculate error rate based on a second report that...

Hi I have a Client running Excel 2010. [They will not install PowerPivot :(] In a workbook they have two Tables - each on a separate sheet. The Tables have a Customer Field in common. I want to be able to combine both Tables into a Pivot Table. I am a Advanced Excel user (20 years). What...

Hi, My Excel Spreadsheet has: a Shape which is intended to act as a button Column D is hidden Cell F5 is formatted as Time and is currently set to 00:05:00 (i.e. 5 minutes) Cell Range E12:E21 where the user is going to enter values (e.g. answers to questions) I would like the user to be able...

Hi there, The "Centre Across Selection" is very helpful in avoid having to merge cells and in my case, use the "Auto Fit Row Height" function. However, I would like the Text to align left across the selection, not centre. Is this possible? My input data is being entered across cells C32:G32...

Hi, I am trying to get all the values from rows with VLOOKUP. I have data which has seller name in merged cell and Product is in differrent rows.For Example: Adam seller has Bananas,Oranges And Lemons... <tbody> Seller Product Adam Bananas Oranges Lemons Robert Apricotes Lemons...

I am not a frequent user of Microsoft Excel. So I'm hoping that I have describing the problem correctly. I have been sent several Microsoft Excel worksheets to work upon. Each of these contain pivot tables with each row summarise some financial transaction for a particular month. So, I will...

I have the below Pivot table (it goes through to zone 8), The data in the columns is number of people in an area at a given time. I would like to add a scroll bar connected to the pivot to filter this table (a total of 17 positions) i.e. position 1 showing 06:30 and position 2 showing 07:30 etc...

Hello! I’m trying to find a formula for an Excel 2010 workbook that will identify the number of unique ids in one column that meet a condition in a second column then returns a count of 1 in the cell for the first instance then 0 for each recurring instance. Ultimately the count columns will be...

Hi All! I am in dire need of all your expert advise. I have already searched through google and previous forums here with similar problems but none of the answers in those forums seemed to indicate why my code is not working... I have even compared to the docs.microsoft.com example and it is...

Hello, I'm trying to find a seamless way to change the data source file in a pivot table without manually going in and editing the text via Pivot Table Tools -> Options -> Change Data Source. Ideally, I would somehow build a reference using a HYPERLINK-CONCATENATE formula that I build, either...

Good morning, I have been working on recording a macro for a concatenate function, but I keep getting a "Run-time error '1004': Application-defined or object-defined error". Here's what my code looks like: Range("G6").Select ActiveCell.FormulaR1C1 = _ "=CONCATENATE('List from...

I have a workbook with a large number of sheets (100+) Ihave a button for administrator/high level user use which unprotects the wholeworkbook which works OK, BUT when the code runs it shows/flashes through allthe sheets as they are being unprotected which is very annoying (and may evenbe a H&S...

Hi, I am doing my head in with this formula and was wondering if someone could help me please?? :confused: <tbody> Description Code Rent for Store - April 2015 123/001 Rent for Apartment - April 2015 123/001 Office Room Hire - April 2015 123/001 Client payment on account 123/001...

Hi there, I would like to have a column which only accepts the following two formats to be entered; ### or ###/### Example; 499 or 499/001 I'm guessing I can do this under Data Validation??:confused: Thanks for your time!

I have an excel 2010 workbook which has a number of sheets whichhave two stages of protection 1 Fully locked for viewing only – Viewing Mode 2 Some unprotected areas for editing data - Edit Mode,selected by password protected button. I have a button for adding rows whilst in Edit Mode I wantto...

I am trying to add a column to a score board, in which I can write custom comments which I want to appear as data labels on a graph (e.g next to June entry, "New manager starts" and such information I have found a way I believe in Excel 2013, but this doesn't work in 2010 as there is no option...