I am looking to see if this can be done as a formula but if it has to be VBA code then I can try and get it to work.
Basically, This file will track the Ins ( Column E) and Outs (Column F) of Totes. The outs will go out every day but the ins will only be delivered if the route is scheduled for...
Hi I am trying to save the data into the MainInventory but unable to do as I keep getting this error
When my sheet is empty and insert the second row as my first row is headers row the data is inserts fine everything works fine but as i enter the third row this pops ups and my vba closes and...
Hi Mr Excel,
How to get result in Column Q & S?
Given number of range to check for Column Q in M , Column S in O
The Range to check in Column G.
Example : Cell O6 show 2 number of range , then check how many value < -0.6 in Column G and the result is 1 in Column S.
Same goes to Column M for...
Hi
I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates.
The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...
Remote* Cell values in a named range "MyNamedRange"** have following structure:
"U. HeaderName - KeyWord"***
Filters and HeaderName row is in row 10
Objective - Upon Right Click on a cell in above named range:
- Filter in Column U using the "KeyWord"
* Remote - as in it is not part of the...
Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table.
I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code?
Sub...
When I type past the end of the cell my text is spilling into the next empty cell. When I add a sum to the cell, it wont spill into the next cell and just cuts off at the end of the first cell. Any reason why this may be happening and how to fix it?
Things to note:-
The next cell is definitely...
Hi guys,
I really need help to set up a logical solution to this.
In 'Value' column I want to have a value based on time interval. If a time interval in a cell in Sheet 1 falls inside a time interval in Sheet 2 then take the values shown in Sheet 2, otherwise 40.
See image. THANKS FOR HELPING
XERROR allows for conveniently generating most of the Excel errors as output to functions
With XERROR, it is very easy to generate all but four of the Excel errors as output to functions. Error types 0, 1, 2, 3, 4, 5, 6, 7, 8, 13, and 14 (i.e. #EXTERNAL!, #NULL!, #DIV/0!, #VALUE!, #REF...
Hello everyone.
I need a VBA to compare two sheets and highlights the unique values.
I have this VBA, but it also highlights if a cell changed it´s position, which I don’t need. I only need the VBA to highlight which cells have different values and the unique cells in each sheets.
Sub...
Hello everyone,
I'm having difficulty with how to make a VBA, which compares all the values of a worksheet in another.
I tried to do it this way, but it didn't work:
Sub CompareSheets()
Dim RowSheet1 As Long
Dim RowSheet2 As Long
RowSheet2 = 1
While Sheet2.Range("A" & RowSheet2).Value <>...
Hi,
Specific Value = 0.1
BCD1DataNumberResult20.430.140.250.13260.570.11180.590.1100.2110.2120.1130.1140.3150.1160.284170.9Description:
1. C5 number is 3, so count 0.1 in B5,B4,B3
2. C7 number is 1, so just count 0.1 in B7 only
3. C16 number is 8, so count 0.1 from B16 -> B9
No count if there...
Hi Gurus,
Good day!
I was looking for some codes on how to create a prompt if the data is not the same.
I saw this which is workable but I need to apply the condition that if the cell is blank, it should ignore it:
=========================================================
"= Existing Code...
Hi all,
I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why?
Thank you!
How do I enter sequential numbers based on cell value start with D9 and end with D7 (30 years term) and I would like to calculate in range Q3:V14.
If I change D7 value to 10 years, in range Q3:V14 should count only 10 years and stop. See my attached XL2BB file.
Thank you so much for your help...
Hello,
This is my first attempt at Xl2bb.
Could you please help me with a formula that can get value only from December month from year given ?
Need to calculate year-end balance which is in each year December month. But value can be YYYY format only in L3 column.
For example, in Q3 result...
Hi,
Does it possible to generate result in Column H?
From the past data, the max positive value appear (>=0) is below 100 row.
My data range between 250k-750k row...
Hi all...I have a query that I'm struggling with, I'm not too sure if I'm going too technical too quickly tbh!
I have some values laid out in a table similar to below, I need a formula that can automatically calculate the position of the value in % form.
Min
Max
Value
Position %
50
100
75...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.