added

Is there a way to automatically update axis bounds when new data is added to the chart? Thank you. David

I am creating a pricing template for services, a section of which is based on an hourly rate. The rates, are by level of seniority which need to be added together then multiple by the number of hours. I would like the option of only selecting the level of seniority and adding the hours, then...

Hi Everyone , I created a pivot table using macro recorder for this month but for next month arrear-basic is not their in the workbook means error occurs, so any solution for that With ActiveSheet.PivotTables("PivotTable6").PivotCache .RefreshOnFileOpen = False...

I want to add a control so depsite the user holding down the shift ket, macros still run (assuming macros are enabled of course)! This article indeed does this: http://pixcels.nl/disable-shift-key-on-open/ However it mentions this code needs to be added in the Ribbon module: Sub...

In column A I have an amount (ie Cell A1 £100) In Column B I have a percentage (ie Cell B1 100%) In Column C I have + or - In Column D I would like the result so, for example =A1*(1+B2) This works fine if I just want a value added, but I want it to take into account whether it is a minus or plus...

I want to know 1) if it is possible, 2) how to create a spreadsheet that is always "live". I want to create a job priority list that i can update and then other employees on the network can have it open and see what was added, if they add notes or sign off completed i want to be able to see it...

Hi all, I'm having a mental blank. I have created a very simple food tracker that I can vlookup the nutrition details from a sheet that has the USDA export of all this information. My end result is a few manual columns including date, food item, grams, and then a vlookup for each nutrient...

I have created a pivot table which I added to the Data Model so I could perform distinct counts. However, I want to now be able to go to Show Report Filter Page but it is grayed out. Is there a way to now break out my pivot table by a filtered field?

Hi There, I have Some times ("hh:mm:ss") format in A column. In B column Have added a formula. It means i have added 8 hours based on A column data. B Column Formula : (=A2+time(8,0,0)). Requirement: A column time will not cross after 8 hours. If it will cross After * hours Column should be...

I have an advanced filter & based on the filtered information entries needs to be manually added eg based on a value per customer a comment next to it. However the information manually entered must not be lost / misaligned every time the filter is updated Is Avanced filter still the best...

I have a macro enabled spreadsheet that I do every week. The normal size is about 2-3MB The spreadsheet contains 6 tab of 26 rows, and about 700 lines, with formulas on every tab. I recently added another macro, but not a huge task. All of the sudden the spreadsheet is 30 MBs, and I can...

Evening, I have a button which when pressed just opens a userform. I press the button & straight away i see the outer border etc of the userform quite some seconds etc before the button,form color etc etc is even shown. Im not sure what code you need to look at so i have supplied some below if...

Hi I have a file that uses the solver function called from a reference. This works well. The issue I see is that my users can have Solver in different locations e.g. ForExcel 32bit program The solver can resides in sub-dir C:\Program Files (x86)\Microsoft...

Hi All I have a total in a cell using the following formula: =SUM(INDIRECT("W97:W"&ROW()-1)) The formula is written that way so that if extra rows are added after 97, the total would include the added rows. The problem I have is that I have a link from another spreadsheet which references...

I have added a checkbox in a cell. I want the character " ' " to be added to to another cell if I check the box. The other cell stays blank if the box is not checked...Thank you

Hello I have an excel where I want to link/group name in D1 and value/formula in Q1,R1,S1,T1, together were if name in D1 moves to cell D5 bc another name are added to D1- D4 than move Value/formula in Q1,R1,S1,T1 to Q5,R5,S5,T5 any suggestions would be greatly appreciated thanks

I want it to take the difference of one 1 column minus a certain box and add together only 1 unique value since theres multiples of the same entry. I had SUM(E8:E50)-L4 Which worked until column E had several entries with the same value. Then it added column E together so the number was...

Please see the file attached I want to input a formula in cell C5 which will sum data from C2 through to G2. If Mar is selected in C4 then cells C2 to E2 should be added https://drive.google.com/open?id=1g38lnSEv13xtBiWygeUWddjIRLmTPzLP The second argument of the sum function should be...

hi.. i need add data to sheet from userform like this image if in Combobox Kecamatan value = Kecamatan B then new data people in cell Kecamatan B will be added and so do other data (Kecamatan A, Kecamatan C and Kecamatan D) thanks

Hi, Totally new to making graphs in excel - wondering if anyone can help. I want to make a line chart with multiple lines and with date value on the X axis. So I have sheet1 - range z2:z5001 as dates. (this is a list of dates that is dynamically added to - what I want to use is any dates on...