fixed

Hi Im looking for a VBA/macro that will create tabs with numbers from C1 to BZ1 and then using the data in the master sheet populate the tabs as well as some fixed data and fields I have invoice number C1:BZ1 Invoice description C2:BZ2 Product description in A3:A88 Product Code in B3:B88 and...

I am working on building a formula that calculates a bonus based on multiple criteria: number of units, total volume and fixed cost per unit. I can easily create one based on the volume and fixed cost per unit, but adding the units portion is giving me difficulty. Below is the chart in which the...

Hi All, First of all thank you for you're help, your about to cure my head ache I have this running (see below) and I am trying to run the macro but it's telling me I need to unprotect the sheet, but it's not protected, im not an expert when it comes to all this but it has been working fine...

I have a report of revenue data in GBP and want to be able to convert to USD at a press of a button, and back again, with a fixed exchange rate. IS this possible and if so how? Thanks

Multiple times per day I update a sheet within a workbook. A second sheet in the same workbook has a reduced number of cells linked to the "master" sheet I edit. I would like a macro to copy the limited data sheet to a network location from where it will be viewed by general users who do not...

Hi all, Is it possible to speed up the following routine: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("a12") = "UAN" Then Range("z12") = "Variable" ElseIf Range("a12") = "" Then Range("z12") = "" Else Range("z12") = "Fixed" End...

I created a simple VB program in Excel 2010 that imported 5 fixed width text files and saved the data on 5 separate tabs in a workbook. We recently migrated to Excel 2016 and now the VB program creates a column break whenever there is a column in a text field. Is there some VB code that...

Hi all, Currently using: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("b12") = "UAN" Then Range("z12") = "Variable" End Sub But I need to modify so if B12 contained any other word other than "UAN", I need Z12 to display "Fixed". I'm unable to get the syntax/code...

Here's one I haven't seen: How do you, using VBA, create a fixed number of x-axis tick marks (say, 10), even if the data range varies? I have the following, but it doesn't seem to work: objChart.Axes(xlCategory).CategoryType = xlCategoryScale...

looking for some help and hopefully solution please folks 2 sheets 1st sheet data entry 2nd sheet display 1st sheet in column A some cells blank some contain a dropdown selection selections are example OP or TA or OC up to about 10 selections column b will have a name against this...

Hi Guys, in cell B1 is this statement =IF(E1="OK";NOW();""). The range for now() values will be in B1:B1000 and OK/NOK values will be in E1:E1000. But I need to have now() as a fixed value (non updating everytime I open the file). Thx in advance!

I want to find the values of a,b,c,d and e if a*5+b*4+c*3+d*2+e*1 = 70 (or any other input value) and a+b+c+d+e = 20 (fixed). any solutions preferably a worksheet function or else a macro is also OK ravi

This is a Hire purchase with fixed monthly Repayments. I have tried to create an Amortization schedule on this (showing the monthly interest and principal repayment portions) but have not yet succeeded in doing so. This is because there is a balloon payment sandwiched in between the fixed...

Hi all! I have a series of columns on a sheet with data in, running down the page. I'm trying to come up with a formula which does the following but I'm struggling: - if the value in row 41 is the same as one in fixed cell $B$38, then multiply the value in this column, row 63 with row 66, and...

Hey, I created a 2d column graph that’s dynamic based up on a drop down list. My only problem with it is each individual graph looks completely different as the height I believe is fixed. What I need is for it to be dynamic so it doesn’t try to scale to said height adjustments. Having a fixed...

Hi, I tried searching but couldnt find what I needed. I have missing buttons from the ribbon in Excel 2013 (Shown Below). It's happening for all my spreadsheets. I have tried the following and still have no luck - Repair office 2013 - Add / Remove Excel - Uninstall and reinstall Office...

Hi clever folks, Is there a way to name a range that will work when calling other macros? By this I mean that in the example below, if I run "rail4_megacalc" then it errors when it finds 'cantilever' as it doesn't seem to have a name associated. I'm just trying to reduce the amount of times I...

I am using the table below to fill in the right value from another worksheet called "Call Rates". <tbody> A B 1 Type Convesation Fonzer 2 Belgium, Fixed € 0,02000 3 </tbody> The Worksheet Call Rates looks like this <tbody> A B C D 1 Fonzer Fonzer+ Fonzer++ 2...

Good day all, I had this working fine, Then I fixed a problem where my reports page retunred a lot of 01/01/1900 date lines that were not needed. I fixed the formulas so that those cells would just be blank. And now my button doesn't work. It goes to the debugger and gives me this error...

Hello there. I was wondering what formula to use to calculate compound interest where the interest rate is not fixed each year e.g. investment of £400k interest rate months 1-12 @ 3% interest rate month 13-24 @ 3.5% interest rate month 25-100 @ 3% etc Hope that makes sense. I am using...