Not hard to understand you. Obviously, your first lang is not English, but I can 100% understand this versus some other vids where they bait you with Eng titles and speak H instead. 🙄I think the people who do not understand probably are not at this level of PHP understanding. This was explained well, but perhaps not for a novice or the person who wants to criticize the way a person chooses to talk/present their tutorial. Keep making tuts and ignore the negative comments from people whose personal issues affect their ability to comprehend what you are saying🙃🙂
Thank you for this video. It's from a year ago but I'm hoping someone might know how to adjust this code so that when you click the "submit" button it submits the data to the sheet and move the person on to another page.
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,
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.
Are you dumb, if you want to give an offer contact him directly don't put it in here. And you are saying "We may be helping" like what?, you are doing it or not say it correctly, bruh. Judging by your talk, your account created date some one like me suspect you as a shady one you know just saying.
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.
Hi @josecarlosvalenzuelasalaza6661, You can hide it via CSS. For example, let's say you have div container: <div class="my_stuff" > <h1> code with mark </h1> </div> <button id="btn_click" >Click me</button> You can hide it like: <div class="my_stuff" sytle="display:none;" > <h1> code with mark </h1> </div> Then use have jquery to show like this: $(document).ready(function(){ $("#btn_click").click(function(){ $(".my_stuff").hide(); }); }); You can learn more about jquery here: www.w3schools.com/jquery/jquery_hide_show.asp Happy Coding 🙂
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
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.
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
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?
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 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
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?