Dear all,
I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake.
Currently I have the following information:
As you can see, the data for 2016 has already been filled out (through an old and more manual method)...
Hi all,
Worksheet_Change(ByVal Target As Range)
The worksheet change event tells us which Range (Target) was edited but doesn't tell us how.
As we know, the user can change a cell either, by editing it with the keyboard, by pasting a value into it ,by drag and drop or by using the autofill...
Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...
Hi all =)
Here's what I need :
=> I enter a value in a cell (usually, a number, like 141KL540024)
=> There's an autocheck in a folder to determine if there exists a corresponding Powerpoint file (it would be 141KL540024.pptx)
=> If the file exists, a message box will warn us, and ask if we...
Hello, I am trying to make this code work:
Private Sub commandB_Click()
If Cells(ActiveCell.Row, "G") = "Výtah" Then
realita.vytah.Value = True
End If
If Cells(ActiveCell.Row, "G") = "Konstrukce" Then
realita.konstrukce.Value = True
End...
Hi guys!
I created a user form with various checkboxes. I need a code that will write all the selected checkboxes into one cell divided with comas.
For example: If a user checks the boxes "apple" and "pear" I want to write apple, pear to one cell. If the check only "apple" it should write apple...
I have an excel sheet of students with their different subject scores for their tests.
Row: Student Names
Columns: Subject headers and their scores. (Math, Science, Literature.
Is there a excel macro that can automatically help me colour the cells of those in the top 20% green, next 20% light...
I have a Excel table in the form below that was extracted from a separate sheet:
Level1
Level1-Level2
Level2
Level2-Level3
Level3
Level3-Level4
Level4
a
b
c
d
f
i
j
b
a
d
e
g
g
k
b
e
c
h
d
i
The Level1 is parent records, Level2 is child records, Level3 is grandchild...
I have a excel table in the form below:
Level1
Level1- Level2
Level2
Level2- Level3
Level3
Level3- Level4
Level4
a
b
c
d
f
i
j
b
a
d
e
g
g
k
b
e
c
h
d
i
The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on...
Level1-Level2 is...
Good Evening,
I am trying to find a code that allows the filtering of various Pivot Tables located on different sheets within the same active Workbook.
For example, one of the active Workbook have the following pivot filtering conditions:
Sheet Name "Group"
Sheet Name "Purpose"
Sheet...
Does anyone have any idea why this code only searches the first row with a matching header instead of every row with a matching header?
=COUNTIF(INDEX($A$4:$F$360,MATCH(LEFT(L$4,3),LEFT($A$4:$A$360,3),0),0),$J16&", "&LEFT($K16,1))+N16
Array $A$4:$F$360 with header $A$4:$A$360,3 trying to...
Hi,
I am hoping you could assist me please. I have two (2) queries I need some help with.
The first query is that I need selected cells to auto populate based on the Nomination Date (K14).
I need Outcome Date (K15) to auto populate based on the date populated in K14 and plus 28 days;
I also...
Hi,
Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8)
desired results enclosed.
Thanks for the help...
Hi,
Required a formula help to extract a records (at least which contains one number in a cell) contains a numeric values in data set Column A:C,as well same values (at least which contains one number in a cell) to be count their actual quantity from the total data set.
Thanks...
Hello, I've been trying to insert a Sheet reference inside CELL() formula because I want to reffer to another Sheet, not in current Sheet, where I write given formula.
Cell reference that is bold AH$1 and AH$19000 should refer to Sheet named "AAA". Right now I am getting #REF in every case I've...
Not sure why it says cell values are not equal when they are equal. Following is my code and cell values are attached. I need to count cells values first and make sure first coordinate and last coordinate equal . Many thanks.
Sub coggv()
Dim i, j, tn As Integer
Dim a1, aa, ixv, iyv, cxx...
Hello all,
I'm quite new to VBA searching for guidance.
I was wondering if anyone had an idea how to write an excel VBA script that would do the following:
1. Search column B for a cell containing "Checker Plate".
2. And if the adjacent cell (Column A) contains a "6" or a "9" then highlight...
Please help,
Super simply:
I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting:
As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...
Hello everybody,
I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else).
Please see the following snip:
For the blank cells from Cell A135-D135 and...
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.