Відео

Thank you

how can you extract data from multiple files based on cell value?

It really saved me sometime. Thanks

Please how can i hide rows or columns that are having formulas but no input yet

Hi, How to add into footer text with pictures, and all this to be dynamic.

if there are 2 criteria if B=0, C>7 if B=0, C<7 Macro

Ok good, but I noticed that when I use only pathname variable; the code runs successfully with no need to foldername variable or DIR function! Dim PathName As String PathName = "C:\Test" If PathName <> vbNullString Then........

Bro, the code keep pasting the same file. Doesn't loop.

Vba excel, sheet1 cell A1 is content need search, if content appears in file word or excel in a folder, b1 is path file result have appears . how ?

Sir how to add company header footer image in vba

Thank you so much

Hi, I have a unique request. What if you had two sheets, Sheet1 and Sheet2, and they are identical. Is there a way to have an active macro that runs without intervention, where rows in Sheet1 is hidden based on a column in Sheet2. Sheet2 cannot be altered with any rows hidden but serve to be the base line. Sheet1 will only show the rows that meet the criteria of <> than 0 based on a column on sheet2. So if row 2 on Sheet2 has a variance <> than 0 then line 2 in sheet1 will be visible. if the cell value of row 2 sheet2 changes to = to 0 then row 2 in sheet1 will then be hidden, without any human intervention. It should happen dynamically and active. Is this possible?

So what’s the keyboard short cut

1:40 bakwas. Initate from this

very impressive work, i have a question, how i can create a table of contents with chapter numbers, headings, sub headings in excel or in word with the help of such code or macro, can u please guide me?

when i make this micro it give me error plz help or copy and paste this vba

Hi, i want to search my invoice value in another workbook and replace the invoice amount with new amount. Can you help me on this, thanks

Excellent 👌

Hello - I also come across error 462: the remote server machine does not exist or is unavailable. This happens after looping (the first run-through works perfectly)

I am running the code but it is not giving any result nor showing error

how to make a frame in a userform transparent so i can see bg image on userform

It should be done automatically using VBA code

How to copy the data of first frame to second frame if condition is match

I followed the same procedure and path but is is fetching data of only one word file. Remaining word file details it is not fetching. Can you help me on this.

Can I use a named range instead of cell range?

Is there the same but to unhide rows?

The code worked but it does not find the last row it copies the subsequent document data just a few rows down and no after the last row.

I want to copy the excel range to send an email respect to the current date. Example: The table range is A1:D20 Column A for Date. Now I want to copy the range A5:D9 to send an email body, A5 to A9 cell value are current date. Please share me the VBA code in this regards.

Excellent work.

What about deleting columns based on a range of cell values?

lol the result @2:17 2:17 is covered by other video blocks how do we see the result?

One of the best videos for showing a beginner to VBA how to delete cols or rows. Many thanks

Hello sir, Very smoothly you delivered the content. Sir can you please me a public function for Text formula Criteria is i have 12345 data len of the cells is 5 or 6. I need output in 7 len =Text(a2,"0000000")

How do you set the column heading if you want all 3 to match before you delete?

Sir, please share border code that determine data itself starting from the given range but ending range to be dynamic depending on last used row...

Thank you sir

I have two column groups. I want to have one expanded and the other one hidden through VBA. How do I do this?

Great

Great

Great

Good Day sir Please let us know the code to spilt all departments data and copy in same sheet one by one

really nice work sir, thanks

Great tutorial. I have a question. If instead of clearing data, can it be used to show another user form.

Awesome! Winning! Thank you!!

How does this work in real life when the first tab isn't the list of names to change? would i then have to add a new worksheet just to have the names? what if the tab names you want to change aren't in the first tabs and start by the 3rd tab?

can i do the same steps but without displaying my password ?

How to hide rows based on value

Hi, I'm trying to adapt the VBA code from this thread into a loop. The aim is to copy and paste a range of cells (Name Range "Output") for each scenario that I'm running into a numbered list (Name Range "Paste.Index"). There are 10 scenarios that are numbered 1-10 (Name Range "NumScenarios") and whichever scenario is chosen is shown in the cell (Name Range "ActiveScenario"). My intention is for the macro to cycle through each of the 10 scenarios and then copy and paste values for each scenario based on the location in the list for that scenario. So for example, if scenario 5 is active, then the macro would copy "Output" and then paste the values next to where the number 5 appears in a list. For some reason the code refuses to paste anything past scenario 6 and it pastes over some of the older pasted values for some reason. Any help would be greatly appreciated.

Hi there thank you wery much. Is there a way to do this only if 2 coloms values are both 0 and not just one

It was superb Sir.. 🙏