Create a management table in the Excel calendar, and work on the moon
I manage.
Every month, we manually enter work days etc., but automation
I received a request to form a VBA because I wanted to do it, but I'd like to know because there are many things I do not understand as a beginner.
* Until now, there was only one condition I wanted to do
I created it with an IF statement.
I made it as follows!
= IF ($L16 = S $13, IF ($A16 = "Complete", "●", "◎"), "×")
.
1.Enter the work day (16 in L column)
Marks the target day of the calendar next to it (from column N).
2, Mark, but it is divided into the following patterns.
* Make sure that the mark matches the conditions.
Condition 1
If the production (16 in G column) is not completed (16 in status A column), ◎
Condition 2
●
Condition 3
△
Condition 4
If the test (column G) is complete (status), ▲
If none of the conditions apply,
* There are several statuses other than completion.
Example: Completion, request, periodic, emergency etc.
I want to mark with ◎ and △ except for completion!
The Excel file used is as follows.
-
Answer # 1
-
Answer # 2
I don't know the conditions for a while, but if there are more branches, it seems better to use
SWITCH
VLOOKUP
+IFERROR
seems to be good if there is a status list and you can add some data to the sheet -
Answer # 3
I did not understand well, but if you prepare answers for multiple options, you can use the LOOKUP function.
If G16 prepares an answer for ("production completed", "test completed", "testing"), write as follows.
= IFERROR (LOOKUP (G16, {"Production complete", "Test complete", "Testing"}, {"●", "▲", "△"} ), "×")
Related articles
- conditional branch does not work with vba
- php - conditional branch does not work
- [java] conditional branch of if does not work
- vba - does not recognize errnumber
- conditional branch of sheet search&creation from vba cell value
- vba - application_newmailex event does not fire
- formula embedded in vba does not work
- conditional branch when there is no deletion record in excel vba
- i want to perform a conditional branch with a vba if statement
- vba: function doesn't run !? trap on conditional branch?
- conditional branch of if cannot be performed with cookie value obtained with javascript
- ruby - unicorn_rails does not start
- apache does not start
- sublime text goto_definition does not work
- html - max-width does not work
- linux - crontab does not work
- html - position absolute does not work
- i don't know the conditional branch of a two-dimensional array
- gem rename does not work [ruby]
- nginx - container does not start
- Excel does not display pictures
- vba - [excel] conditional expression to exclude when dividing the line with the start and end points
- excel vba causes automation error when duplicating sheet
- working with windows apis in vba:about the type in the 64-bit version
- vba - i want to use a class module to link checkboxes of any number of automatically generated ole objects
- i want to switch the vba specified range cells vertically and horizontally
- conditional branch when there is no deletion record in excel vba
- vba - i want to display the last day of the newest month from multiple dates
- vba - dir function open a file with an arbitrary number of digits using a wildcard
- vba - post specified value to specific cell range
Register the following macro (function) in the standard module.
And N16 cell
= SetStatus (N16)
And copy to the right up to 31 days with AutoFill.
Copy down as many lines as you need.
This completes.
The status is set automatically when the date is entered after L16.