increases

Hello, I need some guidance on executing this formula. Essentially if there is no match on the 2020 Contracting increases schedule we then return a value on the trigger tab, if there is a match on the 2020 tab but there is no value it should search for the match on the 2019 contracting...

I have a shared workbook that is 614 KB. I need to unshare it briefly so I can make some changes and when I unshare the file size increases to 12,158 KB. How can I unshare and not change the file size?

Hi, I have this number 000153/19 which indicates Chit No/ Year. I need that every time I save, the Chit No increases by 1 and the year increases by 1 after 31st December. So for example if I save today, it becomes 000154/19 and if the next save is on 1st January 2020 it becomes 000155/20...

Salary increments will be given once in a year at random times as fixed amount. Increments are given randomly, so if 5000 rs increment is given this month, it should be added to allowances (increases to 14500), so it increases gross salary to 40,000, but next month there won't be any...

Hi First of 2 questions today I've got a macro setup to import data from a database. I think it's a "nice to have" for the cells where data is supposed to arrive to be higlighted to the user. Or similarly, how far down the workbook a named range goes. The annoying thing is that if you...

Does anyone know how to make a text box where you can type things that will increase downwards in size to fit the contents? It needs to be at the top of the document, so when it increases in size, it will push other things down.

<tbody> 2010 =vlookup($B1,'Sheet1'.$A$1:$D$4,2,0) 2011 2012 2013 </tbody> This is the ideal formula I'm using and it returns what I need. Is there a way to drag this down where the Sheet reference increases as well? ('Sheet1' will automatcially...

Hi there, I have a UserForm with 50 Text Boxes that are named TextBox1, TextBox2 etc etc through TextBox50. Is there a way I can refer to the boxes using a counter? So I have a Integer Variable that increases by 1 based on some other code. Can I have something like TextBox(Counter).Value or...

I am making a calculator for my website (i make the calculator in the program excel), but i don't know which formula i must take and how to fill it in. It is a formula where the answer depends on the input and bandwidth of the input. Below the input en output: Input: ≤30.000 --> the answer...

I am making a calculator for my website (i make the calculator in the program excel), but i don't know which formula i must take and how to fill it in. I have 2 things i don't know, the first formula is: - By input of numbers lower, or equally to 200.000, the answer must be 725.(So input...

Hiya all, As per the title, I would like VBA to run different macros if the sum range of n6:w200 increase's call Macro1, if it decreases run Macro2. Many Thanks

I have several files in folder C:\sales increases for eg Increases BR Aug 2017.xls, Increases CABM Aug 2017.xls etc I would like to amend my code, which does nothing when activated so as to open a specific workbook containing BR appearing after the text increases I think that this section...

I have several files in Directory C:\Sales for eg increases BR.Aug 2017.xls, increases CABR.Aug 2017xls I have tried to write code to open a specific name after the text increases contained in the name of the workbook for eg "BR" that is after increases when running the code below nothing...

Bitcoin calculator - Google Drive Hi guys, I'm new to the forum and need some help. Above is the link to a calculator a friend has made however it's not quite finished. How it works: I start with a number of packs (B10) which is determined by the starting balance (B3) and each day the...

I have been a long time lurker of MrExcel, but have always been able to find the answer to my question within the forums. However, I am stumped. I am trying to create a pivot table that will show incremental goals by week, when I have a set goal for the month already. However, I don't want to do...