1. Y

    Data Update using VBA

    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...
  2. R

    change modification date for ALL files under a folder

    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...
  3. P

    Stop code from automatically sending Email through Outlook

    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...
  4. M

    row protection based on specific cell

    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á...
  5. A

    Automation of Copy and Merge Data in Column A and B of all files in a folder. Order of Data Differs

    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...
  6. R

    Help with pivot table or other solution

    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...
  7. H

    How do I create a table that then considers whether or not clients appear in other tables?

    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...
  8. K

    Copy formulas from one worksheet to another macro

    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...
  9. D

    Send an email with "missing" text range rows VBA

    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...
  10. SOLTEC


    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...
  11. J

    VBA to run BAT sequentially every 1 minute

    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...
  12. J

    Not sure how to move forward

    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...
  13. N

    PowerQuery Automation

    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...
  14. G

    Calculating % Cap

    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 +...
  15. C

    trying to combine automated date and automated user

    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...
  16. R

    Named file folder range live updated and sorted

    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...
  17. A

    Hi, I am new here and would like some help

    hi there everyone, i was hoping for some help here. I have 13 departments and 121 employees and want to assign them departments (which have fixed spots) for a month randomize department for the given employees , I have been doing this manually and would like to use excel to automate the process...
  18. K

    Excel Automate Copy Paste based on rule

    I hope you are doing well. I would like to know code available to automate my process to copy one file to another in excel using VBA from two different folder First folder contains excel (.CSV) file with name 01-04-2022_Day.csv, 01-04-2022_Night.csv, 02-04-2022_Day.csv, 02-04-2022_Night.csv, &...
  19. N

    Have sum total at the bottom of a column regardless of the number of rows

    Hi all, I am not sure if this is possible the way I want it, but figured it was at least worth picking the much smarter brains in this forum. I want to put a sum total at the bottom of a column. But, the number of rows in that column will change daily. Lets say it's in column A. One day there...
  20. H

    Automate calculations when adding new column of data

    Regularly, I get a excel file with P&L monthly actuals. I create 7-8 columns at the end of the spreadsheet that does calculations based on the data that is provided. Is it possible to create a macro that will calculate the data set when I copy and paste new columns?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back