❤❤❤❤❤❤❤❤❤

You rock man. Excellent. I tried and it is working ovesome.

are you still alive my friend?

Thanks for the video, Very Nice! QQ: Which Formula would work when you are searching for GE in GE but not GE in MGEX?

❤

How can I format a cell if is greater than 360, then subtract 360?

Is there any type of work around of when you use this on office 365 (Excel on Browser)?

Aos brasileiros que as fórmulas estão em PTBR, fica: =SE(NÚM.CARACT(coluna de descrição)>0;1;0).

15 years, and still helpful.

great tutorial!!!

15 years later, and this is still useful!

Thanks soo muchhh

Your way of explaining sounds like a football commentator, thanks it was an enjoyable lesson

great sir, really very nice.

Dear I would like your email address; I want to send something to you. Thank you

Nice video. Welcome back

Thank you...

Was desperately searching for this. Thankyou man..

Please help us is finding the middle text only. Your video shows last text for all examples. In my case for eg if it is T12-74-150-B2 and I want only 150 then how i can get this. Please help. Thank you.

Thanks, question; is there a way of using a specific cell say A1 to send 0/5 volts through a specific pin number in the serial connector or via USB ? Or reading a 0/5 volts through a specific serial pin number and show results in cell A1, possibly a loop because status can change

Thanks, question; is there a way of using a specific cell say A1 to send 0/5 volts through a specific pin number in the serial connector or via USB ? Or even read a 0/5 volts through a specific serial pin number and show results in cell A1, by looping over reading pin number continuously and updating cell A1 continuously.

I love you!❤❤❤ Your tutorial is easy, comprehensive, everything is well explained and most importantly you have just solved a great problem of mine and I can't wait to make my spreadsheet

How do I start my 0 higher up on the vertical ?

thanks

I am new to analytics, so I want to just say, excellent and very helpful. Thank You

Thnx so much

Thank you! You just saved me so much time modifying this spreadsheet. 😀

Thank you so much. You saved my time a lot❤

Hallo, this video was very amazing and helpful on my Workbook. But I have some question, what if i want to show ****** when typing the password?. Looking for your response. Thank you so much.

How can I disable autofilling of formulas in a table so it won't interfere with automated entries? This only works for user entries

The Networks are bombarding the CaesarKing with verbal attacks, noted, anti- science things, bombard attack the networks with your corresponding Antis. Let it be!

I re-verified my macro multiple times but the "get the next empty row is flaging on me and not allowing to macro to not work as intended. Any recommendations?

Thank you for your help, and thank you for your time and dedication in making and posting this video on YT, for everyone to learn something new about Excel.

Yaeh! after 14 years still you receive a LIKE. That's legacy... Thanks you

Thanks but macros dont work in online excels do they?

Very stressed with a huge project and Your video was the best!!! Not too wordy, direct to the point!. I really appreciate that.

you are a blessing! thanks!!

Another example of how shitty excell truly is.

When I follow the very first step I get a value error

Thank you. This is the best solution

I think combination of FileDialog and FileSystemObject Library would be better choice to go for as it provides more flexibility to the end user as well as the VBA Developer. I may be wrong, but what I want to say is that what if someone tries to open up the each and every Excel File that are located in the Main Folder and its Sub Folders and its Sub Folders and so on? Here, I'm sharing my Code below, hope you'll like it: Option Explicit Option Base 1 Option Compare Text Sub RetrieveFilesInfoUsingArray() Dim FD As Office.FileDialog ' Select Files to copy from File Dialog Set FD = Application.FileDialog(FileDialogType:=msoFileDialogFolderPicker) With FD .InitialFileName = "D:\003 Learning\002 Practice\001 Programming\001 VBA\000 Test Folder\" .AllowMultiSelect = False .Title = "Choose Folder" .ButtonName = "Select Folder" End With Dim ButtonClicked As Boolean ButtonClicked = FD.Show If ButtonClicked = False Then Exit Sub Dim MyArray() As String Dim ColumnArraySize As Long 'Here, instead of taking RowArraySize, I've taken ColumnArraySize Variable to resize the Column of MyArray. It's because, when you try to expand the Array Size on running basis, you've to use Preserve Keyword to retain the Values stored in the Array. But, if you use Preserve Keyword, you're limited to redim only the Last Dimension on running basis. Otherwise, VBA will give you "Subscript Out of Range" Error. And, here the Last Dimension refers to Column. That's why, I've taken ColumnArraySize. ColumnArraySize = 1 ReDim MyArray(1 To 1, 1 To ColumnArraySize) MyArray(1, 1) = FD.SelectedItems(Index:=1) Dim Counter As Long Counter = 1 Do While Counter <= ColumnArraySize Dim FSO As Scripting.FileSystemObject Set FSO = New Scripting.FileSystemObject Dim MyFolder As Scripting.Folder Set MyFolder = FSO.GetFolder(FolderPath:=MyArray(1, Counter)) Dim MyFile As Scripting.File For Each MyFile In MyFolder.Files Dim FileExtension As String FileExtension = FSO.GetExtensionName(Path:=MyFile.Path) If Strings.Left(MyFile.Name, 2) <> "~$" And FileExtension Like "xls*" Then Debug.Print MyFile.Name End If Next MyFile Dim MySubFolder As Scripting.Folder For Each MySubFolder In MyFolder.SubFolders ColumnArraySize = ColumnArraySize + 1 ReDim Preserve MyArray(1 To 1, 1 To ColumnArraySize) MyArray(1, ColumnArraySize) = MySubFolder.Path Next MySubFolder Counter = Counter + 1 Loop Set FD = Nothing Erase MyArray Set FSO = Nothing End Sub

Hello, what if a cell has any value or text? For example, if a box has any Text like Algebra, Global History, or Geometry, then I need a cell to identify how many credits it has. In this case, it would be 1 or blank.

I am trying to paste cells into each worksheet. It does it for one sheet but not all could you explain what I am doing wrong? thanks Sub copy_worksheets() ' Goal: to copy sheets(1) to other worksheets within 'the same workbook. ' clear the worksheet Application.workbooks(1).Worksheets(1).Select Cells.Clear Cells(1, 1).Select workbooks(1).Worksheets(1).Name = "Sheet1" 'For Each work_sheet In workbooks: 'If Worksheets.Count > 1 Then 'Worksheets.Delete 'End If ' Next work_sheet 'variables Dim ws As Worksheet Dim start_cell As String Dim end_cell As String ' activate the current workbook Application.workbooks(1).Worksheets(1).Select ws_name = InputBox("Enter sheets(1) worksheet name") Worksheets(1).Name = ws_name start_cell = InputBox("Enter starting cell") end_cell = InputBox("Enter Ending cell") Range(start_cell).Value = "Ninja Turtles" Range(end_cell).Value = "Donatello" ' loop For Each ws In Worksheets 'select the selection Range(start_cell, end_cell).Copy For j = 1 To 2 Worksheets.Add After:=Worksheets(1) Worksheets(j).Select Worksheets(j).Range(start_cell, end_cell).PasteSpecial Next j Next End Sub

Thanks

Thankyou bro

Added a row to address the formatting question when there is a Year value and a Day value but no Month value: =IF(DATEDIF(A2,B2,"Y")>0,DATEDIF(A2,B2,"Y") & " Years","") & IF(AND(DATEDIF(A2,B2,"Y")>0,DATEDIF(A2,B2,"YM")>0),", ","") & IF(DATEDIF(A2,B2,"YM")>0,DATEDIF(A2,B2,"YM") & " Months","") & IF(AND(DATEDIF(A2,B2,"YM")>0,DATEDIF(A2,B2,"MD")>0),", ","") & IF(AND(DATEDIF(A2,B2,"Y")>0,DATEDIF(A2,B2,"YM")=0,DATEDIF(A2,B2,"MD")>0),", ","") & IF(DATEDIF(A2,B2,"MD")>0,DATEDIF(A2,B2,"MD") & " Days","") You can add a couple of IF statements to differentiate Singular from Plural also. (So it will show 1 Year instead of 1 Years) Just makes the formulas a bit longer.

Cannot get it to work in Office 2021

I'm very thankful. i was struggling on how to import data into a master sheet. the video is very clear. Keep going. Thanks

But along with one cell the adjoining cell also gets bigger.

Can someone tell how to edit back them hidden macros,?