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

[@akshaytapadiya2239]

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

[@1112GT]

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

[@venkateshchellakannu4227]

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

[@razamoulvi8801]

Thanks for the video..😊👌 Appreciate😊

[@ExcelDestination]

My pleasure 😊

[@alializadeh8195]

Thank ya

[@MrWmo1975]

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!

[@ashishsachdev6154]

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

[@ExcelDestination]

Thanks Ashish! You can take help from one of my another tutorial. Link is th-cam.com/video/sYFdURCypM8/w-d-xo.html

[@harinath624]

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

[@kapilchauhan8507]

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

[@nmeofdst8]

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

[@gerardvaneggermond9967]

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.

[@swetaawasthi7036]

What if our data is in different sheets

[@ExcelDestination]

then little different code would be required along with activating different sheets using looping statement

[@MohAboAbdo]

Thanks ... Thanks.