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

[@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

[@akshaytapadiya2239]

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

[@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!

[@alializadeh8195]

Thank ya

[@razamoulvi8801]

Thanks for the video..😊👌 Appreciate😊

[@ExcelDestination]

My pleasure 😊

[@harinath624]

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

[@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 kzbin.info/www/bejne/qYqplYiIeN6jg5o

[@kapilchauhan8507]

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

[@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.

[@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

[@MohAboAbdo]

Thanks ... Thanks.

[@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