how can we do the same method but for a particular folder
@ExcelWithBrainBell3 күн бұрын
To make your custom default worksheet template open when you insert a new worksheet, or to have your custom worksheet templates available in the Insert dialog box when you right-click on a sheet tab and choose Insert, you need to save your templates in a location recognized by Excel, such as the XLSTART folder. Once your template is saved in the XLSTART folder, it will automatically open when you insert a new worksheet or appear in the Insert dialog box when you right-click on a sheet tab and choose Insert.
@mostainbillahАй бұрын
Add in program
@mostainbillahАй бұрын
Dear Sir , I have try to Make a Add ins , But Add Ins Not Show At Toolbar . Others Add ins Show But My Created Add Ins Not Show ,
@ExcelWithBrainBellАй бұрын
Sometimes, Excel needs to be restarted for new add-ins to appear correctly in the toolbar. Close and reopen Excel to see if your add-in shows up. Here are a few things you can try to resolve the issue: 01:45 Ensure the Add-In is Enabled: - Go to the Developer Tab (or File > Options > Add-Ins). - Click Excel Add-ins. - Make sure your add-in is checked in the list. If it's not in the list, click Browse, navigate to where you saved your add-in, and select it. - Close and reopen Excel. 02:04 Check if You Created a Button for the Add-In: Creating an add-in alone doesn't automatically create a button for it in the toolbar. To create a button for your add-in on the ribbon, follow these steps: - Go to File > Options > Customize Ribbon. - Select Macros from the dropdown on the left, find your macro, and add it to a new custom group on the right. 3. Go to the Add-Ins menu, remove the add-in, then add it again.
@mostainbillahАй бұрын
Dear Sir , I am proud to see The important Add ins Tutorial ,
@mostainbillahАй бұрын
Dear Sir , I am proud to see The important Add ins Tutorial ,
@mostainbillahАй бұрын
I have set a button by the tutorial code, very nice working, so sorry, I have add ( application screen update False) after multiple select file code,
@ExcelWithBrainBellАй бұрын
Thank you for your feedback! I'm glad to hear the code is working well for you with the button setup. No problem at all regarding the addition of "Application.ScreenUpdating = False" that's a great improvement for optimizing performance when working with multiple files. It's always helpful to reduce screen flickering during operations like this.
@mostainbillahАй бұрын
Thank you sir
@mostainbillahАй бұрын
Dher sir, Excel is my pleasure learning, I am study Excel vba for my pleasure , presently I am searching a tutorial for = Status bar tutorial video, that's show file name on status bar when multiple excel file opening in data consolidated , as per progress bar , I hope I will find the tutorial from KZbin, Thank you,
@ExcelWithBrainBellАй бұрын
Are you looking to display the name of the currently active file in the status bar while multiple Excel files are open? If so, are you referring to updating the status bar dynamically as you switch between files, or is there a specific way you want this information presented?
@mostainbillahАй бұрын
important tutorial for basic Excel learner
@ExcelWithBrainBellАй бұрын
Thanks! Glad you found it helpful!
@CouriosityАй бұрын
Nice❤
@ExcelWithBrainBellАй бұрын
Thanks 🔥
@mostainbillahАй бұрын
Dear Sir , It is High Quality & scholars type Video Tutorial , I am proud To getting The Tutorial , I am grateful to you , The Video Tutorial Helpful For me , Your Code & tutorial is Ok , So , A Small Request To You , To Develop Some Option : My request Is : 1-Set source range (in each workbook) from - Row 17 to 24 in Blank cell between Two data (End(xlUp).Row + 1) from Row 17 to 24 (Note: Rows 17 to 24 are blank cells and there have Data in rows 25 to 28 , ) 2-when blank cell ( 17 to 24 ) will fill up then paste will in last offset row ( Present code destination is will okay ) it is your free time ,Non Emergency , so important Thanks Mostain Billah Dhaka, Bangladesh.
@ExcelWithBrainBellАй бұрын
Here’s how you can modify the current VBA code: Sub CopyRangeFromSelectedWorkbooks() Dim wb As Workbook Dim sourceRange As Range Dim destRange As Range Dim selectedFiles As Variant Dim lastRow As Long Dim activeSheet As Worksheet ' Set active sheet Set activeSheet = ThisWorkbook.ActiveSheet ' Ask user to select workbooks selectedFiles = Application.GetOpenFilename( _ FileFilter:="Excel Files (*.xls; *.xlsx), *.xls; *.xlsx", _ MultiSelect:=True, Title:="Select Workbooks") ' Check if the user selected any files If IsArray(selectedFiles) Then For i = LBound(selectedFiles) To UBound(selectedFiles) ' Open each selected workbook Set wb = Workbooks.Open(selectedFiles(i)) ' Set source range from Row 17 to Row 24 in each workbook Set sourceRange = wb.Sheets(1).Range("A17:D24") ' Check if rows 17 to 24 are blank in the active sheet If Application.WorksheetFunction.CountA(activeSheet.Range("A17:D24")) = 0 Then ' If rows 17 to 24 are blank, paste there Set destRange = activeSheet.Range("A17:D24") Else ' If rows 17 to 24 are filled, find the next empty row lastRow = activeSheet.Cells(Rows.Count, "A").End(xlUp).Row + 1 Set destRange = activeSheet.Range("A" & lastRow & ":D" & lastRow) End If ' Copy source range to destination range in active sheet sourceRange.Copy destRange ' Close the source workbook without saving changes wb.Close False Next i Else MsgBox "No files selected." End If End Sub
@mostainbillahАй бұрын
@@ExcelWithBrainBell Dear Sir , Many Many thanks for Try to support , your Code not success work , Thank you . May Allah bless you .
@ExcelWithBrainBellАй бұрын
I apologize that the revised VBA code did not meet your requirements. Based on your previous comment, here's what I understand you need: 1. You want to copy data from rows 17 to 24 in Sheet1 of each workbook (e.g., workbook1.xlsx, workbook2.xlsx, etc.), and then paste that data into your active worksheet (e.g., Main.xlsx). 2. The data should initially paste into rows 17 to 24 of the active sheet (e.g., Main.xlsx). If rows 17 to 24 are already filled, the next set of data should be pasted into the next available rows, starting after the last filled row. I’ve tested the code on my system, and it works as described above. However, if this still isn't matching your expectations, could you please clarify your requirements further? This will help me better understand the specifics of your request and provide an accurate solution.
@mostainbillahАй бұрын
@@ExcelWithBrainBell Dear Sir ,Please See The Video Of my working file , Need Two Destination : First 17 to 24 Rows . Second : After 30 rows , present Destination code is okay for second option , I am lucky to your feedback
@mostainbillahАй бұрын
whole day in free time i have exercise your code . need Practical file
@ExcelWithBrainBellАй бұрын
brainbell.com/?p=3695#download
@mostainbillahАй бұрын
@@ExcelWithBrainBell Dear Sir , It is High Quality & scholars type Video Tutorial , I am proud To getting The Tutorial , I am grateful to you , The Video Tutorial Helpful For me , So , A Small Requiest To you , to developing Some Option : Your Code & tutorial is Ok , but My requiest Is : 1. Set source range in each workbook from - Row 17 to 24 in Blanck cell . (End(xlUp).Row + 1) from Row 17 to 24 2. when blank cell will filup then past will in last offset row ( Present code destination ) it is your pleasure & free time ,no Emargency . thanks Mostain Billah Dhaka, Bangladesh.
@mostainbillahАй бұрын
@@ExcelWithBrainBell Dear Sir , It is High Quality & scholars type Video Tutorial , I am proud To getting The Tutorial , I am grateful to you , The Video Tutorial Helpful For me , So , A Small Requiest To you , to developing Some Option : Your Code & tutorial is Ok , My requiest Is : Set source range in each workbook from - Row 17 to 24 in Blanck cell . (End(xlUp).Row + 1) from Row 17 to 24 (Note: Rows 17 to 24 of my workbook are blank and there have rows 25 to 28 with data, ) when blank cell will filup then past will in last offset row ( Present code destination ) it is your pleasure & free time ,no Emargency . thanks Mostain Billah Dhaka, Bangladesh.
@mostainbillahАй бұрын
Dear Sir ,Could you please help me to provide Practice file . It Will be help for me ,
@mostainbillahАй бұрын
Many many Thanks for Making tutorial For My request
@ExcelWithBrainBellАй бұрын
You are most welcome
@mostainbillahАй бұрын
May Almighty Bless you.
@mostainbillahАй бұрын
It is important tutorial for excel learner
@mostainbillahАй бұрын
Thank you
@ExcelWithBrainBellАй бұрын
You're welcome
@BenjyBooАй бұрын
Could I ask if we could get more information at a glance on Sheet 1 that would show in the next column "how much the difference in stock is" and perhaps "How much is in stock on sheet 2 (the warehouse)". This would make stock checking easier when say sheet 2 has more entries and in a different order, to save searching back and forth. Thank you so much for all your help an making these tutorial's so easy to follow.
@ExcelWithBrainBellАй бұрын
You can add more information directly on Sheet1 to make stock checking easier. Here's how: 1. In the next column, you can display the stock from Sheet2 (the warehouse) using this formula: =INDEX(Sheet2!C:C, MATCH(B2, Sheet2!B:B, 0)). 2. In another column, you can calculate the stock difference between Sheet1 and Sheet2 with this formula: =C2 - D2. This way, you can easily see how much stock is in the warehouse and the difference, even if Sheet2 has more entries or is in a different order. Thanks again for your kind words!
@BenjyBooАй бұрын
@@ExcelWithBrainBell Thank you so much, the formulas work a treat! Keep up the good work 👍
@goodman-it2qyАй бұрын
Thanks
@ExcelWithBrainBellАй бұрын
Welcome
@mostainbillahАй бұрын
Dear sir, Need a Tutorial to get Specific range Data to Active Sheet , I have seen Many kinds of Video tutorials From your channel ,But i haven't Found As a Tutorial . I Have a need : get Specific range Data as a Range (A29:D29) to Active Sheet From All selected Workbooks . And Past Active Sheet ,Destination Range (A29:D29) .xldown Please help To get Tutorial or Code. Please see my Request. Best Regards Mostain Bangladesh
@ExcelWithBrainBellАй бұрын
Will upload soon
@ExcelWithBrainBellАй бұрын
kzbin.info/www/bejne/h2W1i5l_hLaJoJY
@goodman-it2qy2 ай бұрын
Thanks a lot sir.
@ExcelWithBrainBell2 ай бұрын
You're welcome!
@mostainbillah2 ай бұрын
Dear Sir ,I have Need a code for Extract string In specific Cell . Please See My Apply. Range("C5") = W5606 ENG 04 03 11 -BANGLADESH-DHAKA.ord 1. Need first Word of Line “ W5606 “ 2. Remove Frist word & Before First Dash part -“ENG 04 03 11” 3. After Dash “ BANGLADESH” 4. Last Word After second Dash “ DHAKA “ Extract Range: Range("A29") = W5606 Range("B29") = ENG 04 03 11 Range("C29") = BANGLADESH Range("D29") = DHAKA Delete = .ord From C5 cell
@ExcelWithBrainBell2 ай бұрын
Thank you for your question! You can achieve this by using VBA: Sub ExtractString() Dim fullString As String Dim firstWord As String Dim secondPart As String Dim thirdPart As String Dim fourthPart As String Dim dashPos1 As Integer Dim dashPos2 As Integer ' Get the string from C5 and remove the ".ord" part fullString = Replace(Range("C5").Value, ".ord", "") ' Extract the first word (W5606) firstWord = Split(fullString, " ")(0) ' Find the position of the first dash dashPos1 = InStr(fullString, "-") ' Extract the second part (ENG 04 03 11) secondPart = Mid(fullString, Len(firstWord) + 2, dashPos1 - Len(firstWord) - 2) ' Extract the third part (BANGLADESH) dashPos2 = InStr(dashPos1 + 1, fullString, "-") thirdPart = Trim(Mid(fullString, dashPos1 + 1, dashPos2 - dashPos1 - 1)) ' Extract the fourth part (DHAKA) fourthPart = Trim(Mid(fullString, dashPos2 + 1)) ' Place the extracted parts into the specified ranges Range("A29").Value = firstWord Range("B29").Value = secondPart Range("C29").Value = thirdPart Range("D29").Value = fourthPart Range("C5").Value = fullString End Sub To use this code, follow these steps: 1. Press ALT + F11 to open the VBA editor. 2. Go to Insert > Module to insert a new module. 3. Copy and paste the code above into the module. 4. Close the VBA editor. 5. Run the macro ExtractString from the Excel workbook. This will extract the string as you described and place them in the specified cells (A29, B29, C29, and D29). I hope this helps!
@mostainbillah2 ай бұрын
Thank you very much, I am grateful to you, may Allah bless you ❤️
@nikosmakrymanolakis30422 ай бұрын
a much better improvement: =IF(AND(COUNT(A1:A10)=COUNTA(A1:A10);COUNTBLANK(A1:A10)=0);SUM(A1:A10);"Fill with numbers")
@ExcelWithBrainBell2 ай бұрын
=IF(AND(COUNT(B2:B16)=COUNTA(B2:B16),COUNTBLANK(B2:B16)=0),SUM(B2:B16),"Fill with numbers") Thank you for your suggestion! The formula you provided is indeed a great improvement. By using AND along with COUNT and COUNTA, it ensures that all cells contain numeric values and that none are blank. This adds an extra layer of validation, making it even more robust. I appreciate your input and will consider including it in future tutorials. Keep the ideas coming!
@BenjyBoo3 ай бұрын
Can I ask if it would be possible to extend the formula to check the two lists (sheets) by the product code before highlighting the quantity differences. An example being the lists are in a different order, not match-able due to more items on the warehouse sheet? Thank you again.
@ExcelWithBrainBell3 ай бұрын
Yes, it's definitely possible to extend the formula to check the two lists by the product code before highlighting quantity differences! Simply use the MATCH function to find the corresponding product code in Sheet2 and then use the INDEX function to retrieve the quantity. Here's how you can do it: 1. Select the quantity range on Sheet1. 2. Go to Home > Conditional Formatting > New Rule. 3. Use the formula =C2<>INDEX(Sheet2!C:C, MATCH(B2, Sheet2!B:B, 0)) to highlight differences. This way, you can accurately compare quantities even if the lists are in different orders. Let me know if you have any further questions!
@BenjyBoo3 ай бұрын
Thank you so much for doing a tutorial on this after my question on your last video. Your content is very well produced and easy to follow. I can't thank you enough. Keep up the good work.
@ExcelWithBrainBell3 ай бұрын
Thank you so much for your kind words! I'm really glad to hear that you found the tutorial helpful and easy to follow. Your feedback means a lot to me and motivates me to keep creating content. If you have any more questions or topics you'd like me to cover, feel free to let me know. Thanks again for your support!
@BenjyBoo3 ай бұрын
How could I do something similar in using a colour to highlight differences in stock levels on two sheets. Sheet one like the above has an item name and quantity including a product code. The second sheet has the same columns but could have different stock quantity as its what is available in the warehouse. Basically I'd like a green to show in the quantity cells if the stock level is the same on both sheets and red if they are different.
@ExcelWithBrainBell3 ай бұрын
Thanks for your question! To highlight differences in stock levels between two sheets in Excel, you can use conditional formatting. Here's how: 1. Select the Quantity Range on Sheet1 (e.g. C2:C20). 2. Go to Home > Conditional Formatting > New Rule. 3. Choose "Use a formula to determine which cells to format" and enter =C2=Sheet2!C2 for matching quantities, formatting with a green fill color. 4. Add another rule for differences with the formula =C2<>Sheet2!C2, formatting with a red fill color. This way, matching quantities will be green and differing quantities will be red. Check out the video I created on this topic: kzbin.info/www/bejne/jHTQd5KpltSnrZYsi=U4-BMpISpcitzkfP
@MR-SK-BOXER3 ай бұрын
Ap na agli video apni asal awas ma daalo ai ki na dalna
@RhinoGaier4 ай бұрын
Brilliant!! Love it
@ExcelWithBrainBell4 ай бұрын
Thank you so much! I'm glad you enjoyed it!
@RhinoGaier4 ай бұрын
Love the short and sweet info video - thank you!
@ExcelWithBrainBell4 ай бұрын
You are so welcome!
@briancowan29504 ай бұрын
How can you protect the formulas that are in a cell that you need to enter data.
@ExcelWithBrainBell4 ай бұрын
If you need to protect formulas in a cell where data entry is required, one approach is to use separate cells for formulas and data. Place the formula in a different cell and reference the data cell. Then, lock the formula cell and protect the worksheet as shown in the video. This way, users can still enter data without altering the formulas.
@realm-code4 ай бұрын
Never knew about this feature very interesting ! Thanks
@ExcelWithBrainBell4 ай бұрын
Glad you found it interesting! Thanks for watching!
@許傑豪-h1i4 ай бұрын
Is the voice produced by AI? sounds good
@ExcelWithBrainBell4 ай бұрын
Yes, the voice is generated by AI. Glad you liked it!
@VanWinkle24 ай бұрын
Amazing work, I really enjoy your VBA solutions, I have lots to learn..
@ExcelWithBrainBell4 ай бұрын
Thank you! Happy to hear you enjoyed the VBA solutions.
@basictechskills38224 ай бұрын
Thats a great idea. Thanks
@ExcelWithBrainBell4 ай бұрын
Glad you liked it!
@godsontc2435 ай бұрын
Direct to point really appreciated the content creator May I know your name pls
@ExcelWithBrainBell5 ай бұрын
Thank you for your kind words! I'm glad you found the video helpful.
@briancowan29504 ай бұрын
@@godsontc243 my name is Brian
@briancowan29504 ай бұрын
@@godsontc243 and thank you very much I will give it a try!
@canandarao3545 ай бұрын
Does not work in Excel 2021
@ExcelWithBrainBell5 ай бұрын
Thank you for your feedback! The methods shown should generally work in Excel 2021. If you're experiencing issues, here are a few things to check: For Hiding Rows and Columns: - Ensure that you've selected the correct rows or columns to hide. - After selecting, right-click and choose 'Hide' from the context menu. You should not be able to scroll beyond the visible rows and columns. For VBA Scroll Area: - Make sure you have saved the workbook as a macro-enabled file (*.xlsm). - Check that the code Me.ScrollArea = "A1:H13" is placed correctly in the Worksheet_Activate event of the correct sheet. If these steps don't resolve the issue, it could be specific to your Excel setup or configuration. Please let me know more details about the problem you're encountering, and I'll do my best to help you troubleshoot it!
@SitzeCАй бұрын
Before hiding the Rows and Columns I will “freeze the panes” in the lower right cell so the view cannot be scrolled off screen.
@ExcelWithBrainBellАй бұрын
Great tip! Freezing the panes is an excellent way to lock the view and keep the important part of the sheet visible while restricting scrolling. Thanks for sharing that suggestion!
@nikosmakrymanolakis30425 ай бұрын
To the point explanation and illustration. Well done
@ExcelWithBrainBell5 ай бұрын
Thank you so much! Your feedback means a lot!
@seetharam5 ай бұрын
How to remove the limit of scrolling area, means how to unhide?
@ExcelWithBrainBell5 ай бұрын
Press Ctrl+A or click the small triangle in the top-left corner of the worksheet to select everything, then - Right-click on any column letter and choose "Unhide." - Right-click on any row number and choose "Unhide."
@naeem0795 ай бұрын
It's amazing 👏
@ExcelWithBrainBell5 ай бұрын
Thanks a lot 😊
@evolutionclouds5 ай бұрын
One question. How do you "undo" the script. I noticed if you put it and delete it still won't remove the script.
@ExcelWithBrainBell5 ай бұрын
If for some reason you need to clear the scroll area limits, you can remove the restriction with this statement: Me.ScrollArea = "" Or simply create a standard macro that will reset your scroll area back to the full sheet: Sub ResetScrollArea( ) ActiveSheet.ScrollArea = "" End Sub For detail, please visit: brainbell.com/excel/limit-the-scrolling-range.html#macro
@ExcelWithBrainBell5 ай бұрын
The method described at 00:56, "Automatically initializing the context menu with Workbook_Open," incorrectly displays the custom context menu in all opened workbooks. To fix this, use the Workbook_Activate and Workbook_Deactivate event procedures. For more details, please watch the section on "How to create a submenu": kzbin.info/www/bejne/gJmofoyBoJdmbs0
@teigenxayden5 ай бұрын
thank you ! you are so great!
@ExcelWithBrainBell5 ай бұрын
Thanks a lot! Your support means the world to me!
@silvestrecamposano63175 ай бұрын
Thank you!....
@ExcelWithBrainBell5 ай бұрын
You're welcome!
@guigo29175 ай бұрын
Would this prevent users from copying the workbook file to another directory, without using the save as command, but rather just copying and pasting?
@ExcelWithBrainBell5 ай бұрын
The VBA method shown in the video prevents users from using the 'Save As' command within Excel. However, it doesn't stop users from copying the workbook file to another directory by copying and pasting. For full protection, consider protecting the workbook by activating Rights Management Services (RMS) if you're using Office 365. I've briefly explained this on brainbell.com/excel/preventing-users-from-printing-a-workbook.html
@MohAboAbdo5 ай бұрын
Thank you so much
@ExcelWithBrainBell5 ай бұрын
You're most welcome
@mjunaidmaster06 ай бұрын
Awesome
@123Usamababar6 ай бұрын
Very informative
@ExcelWithBrainBell6 ай бұрын
Glad you liked it
@shoaibmughal24825 жыл бұрын
Make a video on how to use unity plz
@Kevin-jc1fx5 жыл бұрын
Nice Tutorial, clear and concise. May Jesus bless you and your channel. I also like your php tutorials a lot. Cheers from Cameroon.