automate

I have a workbook with a connection. I have gone to connection properties and set it to refresh periodically in the background. But I don’t know if it saves the document after the refresh. I don’t think so because the time of last modification of document doesn’t change. So I’m trying to...

Is there a way to automate the sorting of a row a-z ascending but across not down. I add a new column in once a week and use a script to make it quicker however i was hoping i could always ensure the row is organised ascendingly without having to do anything? For example Row 1 Week1 Week2...

I have a workbook with a number of sheets in it and I need to be able to automate updating one sheet with certain data when another sheet is updated. Here is the layout:- The data is all football matches from around the world, with with A being Date & Time, B being League, C being Match and G...

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

Hello Everyone! I have two files named Purchase Requistion (PR) and Database (DB). PR is in the format of a form which they fill in order to raise a PR request. This file is then "Save As" with a different name so as not to disturb the native file "PR". DB is a table format, which takes the...

Is there a VBA macro that can be created to change all modification dates under a path? example : C:\Users\User\Documents has modification dates dating from 2015-2023 all files are accessed on a monthly bases, instead of going to each file and hitting save since there are 100s of files- and due...

Not a VBA expert, AT ALL. I searched for a code to automatically send emails from Excel through Outlook. However, is there a way to stop the code from automatically sending them, and instead create the email pop-up and if all looks good, then I manually click Send? Sub Send_Bulk_Mails() Dim...

Como protejo automaticamente uma linha com base em uma célula? Exemplo: se você inserir um valor na célula E1, ele protegerá automaticamente as células à esquerda da linha, D1, C1, B1 e A1 E o mesmo se aplicaria às linhas seguintes, se você inserir um valor na célula E2 ele protegerá...

Sub CopyDataAndCreateChart() Dim folderPath As String Dim file As String Dim wbSource As Workbook Dim wsSource As Worksheet Dim wbDest As Workbook Dim wsDest As Worksheet Dim destRange As Range Dim chartRange As Range Dim chtShape As Shape Dim cht As Chart...

So i am trying to make a pivot table that i can create graphs and other reporting off of-- what i need is the first column listed out ( there are more then jus the 2 shown) and the second column to show a number so what i want is it to report like this the total can be on the right side if...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

hello I have a macro that automatically creates column headings based on a Lov list I have within the workbook I also have worksheet2 that contains formulas that I would need copied over to the new columns in worksheet1. example: Each time a new column header is in inserted it is inserted...

i have a list of missing and file names hyperlinks I want to create a button that, when clicked, reads the entire column and if it finds "missing," will collect those rows range and then will go to column A and read the first 2 letters and, based on that, will send an email to the...

I have a spreadsheet with POS SKU numbers and I want to create two rows below each SKU with the same SKU number with one adding cc to the end of the SKU and inserting it before the original SKU, and then below that another original SKU with the same original SkU with c concatenated for 1,000's a...

Hi brains trust I was wondering if someone could help me. I have a folder with over 30 batch files. I need to run them in order but with a 2 minute wait time between running the batch files. I understand I could do this: shell("CMD.EXE /c c:\abc.bat") This might make things tricky as I...

Hello, I am reaching out to anyone for guidance on this one. Here is the detailed scenario I have a Sales Commission Report in excel. There are 5 worksheets plus summary sheet Each Month we add the new onboarded client under reps name for 90 days Looking to have Summary sheet automatically...

My question is this, is there a way to automate power query in vba, for example if I record a macro of me getting data from a PDF I open the pdf in power query I choose the option select multiple in the menu, I choose two pages and then I load it to a table. But when I go back to the macro, all...

I'm embarrassed to ask this question as it should be something I could figure out on my own but here goes: I need to figure out how to calculate a % cap without creating a circular reference. Here is a simple illustration I need to find a formula for to automate my work: 1.) I know that 1 + 1 +...

hello i am trying to get my excel sheet so that each row will show what date that row was edited last and by which user. i can get the two parts to work separately but I cannot get them to work together as it causes the workbook to crash. my code so far is this: Private Sub...

Hi, I have a listFiles named range to return a list of files of a specific folder into Excel. I use the following formula: =IFERROR(INDEX(listFiles,ROW()-ROW(A$2)),"") I was wondering if there is a non-VBA solution to automatically/live update the files list in the Excel named range whenever a...