Видео

Nice bro, I am not a great person myself but you are doing great even though there is a lot of hate you are keep going and I like it. Here are some POV as a knowledge seeker and a viewer: if its about a specific concept people expect the video to be at the point, if its about a full on beginner thingy people expect in depth knowledge and when it comes to beginner videos people expect continuity faster because your will be always unique then others and so people expect your video. I am thinking you are doing this as part time thing but if you still want to grow you can try other communities and magnet people from there. Try to understand like what if I was a new developer then what I would expect then create the video according to it. I am not sure if this will be any help but if you want you can take this as a new perspective. No offence but a little hope 🧡.

awesome i had to do so much mental gymnastics to do this stuff using old excell style comands, the query function does dozens of steps seamlessly that's epic i strated learning mysql but i already know a lot with sheets and it has so many great features, free hosting, colaborating, sharing, publishing, extension library, open source forums and solutions, etc, and integrations with multiple platforms and devices and google services (maps, calendar, text, gmail, contacts, notes, docs, drive, photos, youtube, forms, sites, etc, etc, etc) i'm hoping to one day make automations for my business chat bots reminders, confirm apointment, schedule, faq forms, client intake, employee application, job request, emails, reciepts, invoices, website, client portal, log in, check your bill, documents, scheduled jobs, reports, portfolio, designs, status or projects, etc employee scheduling, routes, project management,

its working but removing the other existing other sheets how to avoid it removing the existing sheets

Thank you, this saved me a lot of hours :)

في حد عربي يشرحلي الفيد؟

I don't see a links to the code for the scripts. Can you please post it?

Why your video voice is so low, not able to hear anything

thiis man took 4 minutes to explain how to click a button

Thanks for the great solution! It was very useful!

Misleading video

Thanks For your video! I subbed

Wonder how to do this with reactjs

Thanks a lot

and if you have multiple pages?

subscribed! thank youuuu

Hello, I was looking at your video channel. We may be helping a company that uses secure images to increase supply chain security and help cloud native development. Would you be willing to help try their software, make a video, and help show devs how to use their tools? This is not an offer, but just to start a conversation about your willingness to take on sponsorship. Please provide me with your email if you are interested. You'd have a chance to look at their technology and decide if it's the type of software that you'd be interested in covering in your channel.

how to make in SheetNames links to every created sheet?

Me funciona el código. Muchas gracias Mark. Lo que ncesito hacer es que cada vez que mi página sea recargada, no se oculte la información, sólo se refresque. Gracias por el apoyo.

Hey how to make it work for long tables

Code if you want to delete certain worksheets. Function delete_sheets() Dim i As Long, LastRow As Long Dim wsDeleteNames As Worksheet Dim sheetName As String ' Set a reference to the "DeleteNames" worksheet Set wsDeleteNames = ThisWorkbook.Worksheets("DeleteNames") ' Find the last row in column A of the "DeleteNames" worksheet LastRow = wsDeleteNames.Cells(wsDeleteNames.Rows.count, "A").End(xlUp).Row ' Loop through each row in column A of the "DeleteNames" worksheet For i = LastRow To 1 Step -1 ' Retrieve the sheet name from column A sheetName = wsDeleteNames.Cells(i, 1).Value ' Check if the sheet exists in the workbook If WorksheetExists(sheetName) Then ' Delete the sheet Application.DisplayAlerts = False ' Suppress delete confirmation ThisWorkbook.Sheets(sheetName).Delete Application.DisplayAlerts = True End If Next i MsgBox "Done deleting sheets" End Function Function WorksheetExists(sheetName As String) As Boolean ' Function to check if a worksheet exists in the workbook On Error Resume Next WorksheetExists = Not ThisWorkbook.Worksheets(sheetName) Is Nothing On Error GoTo 0 End Function

Code to automatically determine how many rows in the Names worksheet: Function create_sheets() Dim i As Long, LastRow As Long Dim wsNames As Worksheet, wsTemplate As Worksheet ' Set references to worksheets Set wsNames = ThisWorkbook.Worksheets("Names") Set wsTemplate = ThisWorkbook.Worksheets("Template") ' Find the last row in column A of the "Names" worksheet LastRow = wsNames.Cells(wsNames.Rows.count, "A").End(xlUp).Row ' Loop through each row in column A of the "Names" worksheet For i = 1 To LastRow ' Copy sheet from template wsTemplate.Copy After:=Sheets(i) ' Rename the copied sheet with the value from column A Sheets(i + 1).Name = wsNames.Cells(i, 1).Value ' Update the value in cell B2 of the copied sheet with the new sheet name Sheets(i + 1).Range("B2").Value = Sheets(i + 1).Name Next i MsgBox "Done creating sheets" End Function

No Developer option in Excel for me :(

TypeError: Cannot read properties of null (reading 'copyTo')

Very useful video. Iam new to coding. my code works with static table, but fails when the table is from mysql database in Python Flask. Any idea what is missing. Thanks for your time.

thank you Mark... so cool and easy to follow... ! it worked very nicely for me.

will this work without internet connetion?

Advance Macro Video:: ruclips.net/video/BuK2bdqPTag/видео.html

Sir, how to make this website work on mobile phone? Please help 🙏🏻

I wish you would just focus on the process from A to Z instead of going sideways and mentioning other things every 30 seconds, great video tho thanks!

Im rocking with Mark!

Copy link please for code

I'm not sure what I'm doing wrong, but I keep getting a "Run-time error '9': subscript out of range. I am trying to use this same method, but instead of names, with dates. I have created a new sheet with my dates in a row (named Date). I want the date to change each time adding 1 day to be placed in F1 in my original template (named Template). The code highlights "ActiveSheet.Name = Sheets ("Name"). Cells (i, 1) and gives me a 'debug' option as well as 'end' This is how I entered the code: Function create_sheets() Dim i As Long, LastRow As Long, ws As Worksheet Sheets("Date").Activate LastRow = 31 For i = 1 To LastRow 'copy sheet from template Sheets("Template").Copy After:=Sheets(i) ActiveSheet.Name = Sheets("Names").Cells(i, 1) 'update dc number ActiveSheet.Range("f1").Value = ActiveSheet.Name Next i MsgBox "Done creating sheets" End Function

THANK YOU SO MUCCHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I love this idea - but when I run the Clone Menu, it is blocked. And when I go to App & Services, there aren't any "apps/services" to review. Thoughts?

Is there a way to revise the script so that we can use the attachment feature and post the files to an API?

change page without reload page in anchor tag is possibal??

Thank you Mark ! One quick question: is it possible instead of coppying the whole "template" sheet to copy a specific line that is gonna be different for each new tabs. Like the first new tab will have only line 3 of the template, second new tab wil have line 4, and so on. Thanks

how to disable copy paste in froala editor

You're a genius! Thank you so much for this video. It was super easy to follow, clear, fast, and just right on!

how can we add images in the excel from this library, can you please tell, I am doing some work and I didn't find the way to add the images in the excel, Please Help

Thanks!

Great job

Hello! Can you share your email? I want to ask some question that cannot be explained well here! Please! it is my project and it is a dead end for 3weeks :( already

Hello. This is really amazing. How can I run a similar script in order to create a new google sheet for each row. This is NOT a new tab but a whole new sheet?

I'm getting an error - TypeError: Cannot read properties of null (reading 'getLastRow')

Hi. I want to create multiple worksheet with every worksheet has details of quantity of my stock inventory. Can you create code for me. for example C9 is column I want to add the quantity from my data.

ugh, I only have the home version I guess, cus I don't have the Developer tab, and I searched for Visual Basic and got nothing. bummer

Hi there. This code was working fine a few months ago. But now the print button is not working properly. Please Someone helps me

Hi there. This code was working fine a few months ago. But now the print button is not working properly. Please Someone helps me

The title is misleading. This is about how to put TinyMCE on your website, not about any WYSIWYG editor of html files. The video is literally using non-wysiwyg VScode to edit html files...