VBA IF else with For Loop - Excel VBA IF ElseIF Else Using Loop

Thanks for explaining with clarity. Can you please add the code dynamic if more than 101 rows are used. Thanks

Tks for sharing this video 📹 , Can anyone help me if condition met how copy data one cells another to cells

Here is a much easier and simpler way to write this code:

For i = 2 To 11

If Worksheets("data").Cells(i, 3).Value = "Saturday" Or Worksheets("data").Cells(i, 3).Value = "Sunday" Then
Worksheets("data").Cells(i, 4).Value = "Holiday"

Else: Worksheets("data").Cells(i, 4).Value = "Workday"

End If

Next

End Sub

Thank ya

Thank you sir!
How do you apply this vba code horizontally rather vertically?
What I mean is that if cell in column B =value then auto fill cells on the active row (not sequential columns for example cells in columns: F-L and M-v) with “N/A”
Thanks in advance!

Sir I ko aapne declare nhi kiya fir kaise code run hua

Thanks for the video..😊👌 Appreciate😊

What if our data is in different sheets

Thank you very much sir for all ur videos learning a lot !!!😊

Hello sir, maybe you can help me with a rather complex problem, can help me with that.
In the worksheet "Menu" I have in cell "E2" I have data from 1 to 3, now I have cell "B4" and "B10" I have an ID reference to names, what do I want to do now, Eg. if E2 = 1 I want to go to worksheet "1" then look at the IdNr then put the data in the right place. It contains date for "B4" = cell "C6", "E6", "E8".
for "B10" = cell "C12", "E12", "E14".
So with flea cup and a loop, maybe the next formula.
if "E2" = 1 then
Workbook 1
if B4 = 1 then and B10 = 2 then
Hlookup (B4, workbook 1 (A1: CV21), 1)
lookup (B10; workbook 1 (A1: CV21), 3.3)
C6 = workbook 1 (places in column 3 row 3) for each number in b4)
E6 = workbook 1 (places in column 5 row 3) for each number in b4)
E8 = workbook 1 (places in column 4 row 3) for each number in b4)

if B10 = 2 and B4 = 1 then
Hlookup (B10, workbook 1 (A1: CV1), 1)
lookup (B10; workbook 1 (A1: CV21), 3.3)
C6 = workbook 1 (places in column 8 (is also colmin 3 of "B10") row 3) for each number in b4)
E6 = workbook 1 (places in column 10 (is also column 5 of "B10") row 3) for each number in b4)
E8 = workbook 1 (places in column 9 (is also column 4 of "B10") row 3) for each number in b4)

So maybe it is useful to work with a loop loop
It would be useful to (search on both B4 and B10) than put the data in the right place, is this possible?
There are 20 names, I do not know if this formula is correct.

Thankyou for this informative video... please suggest...what if we want macro to auto pick last row
Or let say, if we keep on adding data and we want macro to automatically consider it as a repetitive process

Thanks ... Thanks.

instead of ElseIf you could have used Or

God bless you sir... Please ..copy row from one sheet to multiple sheet for different data information...example Monday one sheet , Sunday one sheet, Tuesday one sheet