automate

  1. G

    Automated checking if file exists in source folder & destination folder, If file does not exist in destination folder, copy it.

    Hi all, I currently have this problem at hand. I need to check if my source folder and my destination folder has exactly the same files by comparing it. If files that are present in the source folder is not present in my destination folder, the macro is able to copy and paste the file that is...
  2. V

    VBA Macro to paste values from a list in multiple separate worksheets

    I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...
  3. R

    change a cell value and corresponding sheet/tab color based on value on button click

    Hope everyone is having a great weekend! Ok...here we go. I have a button on several sheets in a workbook which is supposed to call one function. The function is supposed to look at a sheet named "CONTENTS" and search column B for matching sheet name. Eg. If the active sheet I'm working on is...
  4. O

    How to automatically run VBA code between specific hours for each week in MS Access application

    I have a MS Access application that is used in multiuser environment. I want to make maintanence every thursday between 15:00 and 16:00. At this point I have two issues to consider. Firstly, The users who may entered to application before 15:00. Secondly, the users who will be entering between...
  5. A

    Need macro that Populates usage end date in column T

    Dear All, Please see below image, i have this job i need to do this manually everyday, if this can be automated it makes my life easier. I need macro that Populates usage end date in column T i hope i made instructions clear in Image, if anything more reuired please ask. Many Thanks for your...
  6. N

    VBA Email Automation

    Hello Guys Im new here and seeking some help in VBA okay so I have a report that I usually do, and I already made a macro that splits the report to pages depending on the country name. I want a vba that reads the sheet name, and send the sheet only to the assigned email for this sheet, the...
  7. A

    Automate history

    Hi. Is it possible to make Power BI, every week, save data in a table, in order to create a weekly history? Thank you, Afonso Mira
  8. D

    Week/Month/Year to Date Automatic Growth Rate -> NEED HELP PLEASE!!

    Hi all, So I am currently working on creating an automated dashboard that updated every time a new file is added to the source folder. I have been able to successfully get excel to update the new data every time a file is loaded. I have a 'date' column so I can extract, day of the week, year...
  9. H

    Macro for automatically linking Multiple ActiveX Checkboxes in one cell

    Hi Enthusiasts, I have one excel cell with 25 ActiveX check boxes. I have manually associated each checkbox in row 3 with a cell (i.e. the Microsoft Word checkbox in row 3 is associated with CF3, the Microsoft Excel checkbox is associated with CG3 etc). I have dozens of rows of Official Record...
  10. R

    Unable to automatically pull data and perform custom modifications to a table from a query whose source is a dynamically changing link

    Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead of manually typing out the inputs into the link, putting it into power query, performing transformations, and...
  11. M

    Vlookup with workbook in a same folder

    In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark) Name Mark Class Grade John 50 Post Graduate A Peter 50 Preschool A Andera 100 Nursery S In the another Workbook B, is the fixed Existing report...
  12. T

    Automatically copy cell formatting based on the formatting of another cell

    It's easy to copy the value of a cell. If you want to automatically copy the value from A2 to B7, then in B7 you type =A2. But can something like this be done with cell formatting? I use a spreadsheet to track our work, and we color each item based on who is handling it (every person is...
  13. E

    Would like to automate my spreadsheet.

    Hello everyone. I'm running Windows 10 and Office 365. I'm looking for a formula or formulas to automate my spreadsheet. Right now this is what I have. <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color...
  14. E

    Excel\VBA automation software

    I have been looking at the www.automateexcel.com to help me automate the creation of my coding. I am a poor code writer and a lot of these tools would improve my abilities, but I am curious if there are any other software that compares to Automate Excel. Does anyone have any suggestions or...
  15. R

    How to Click a link on webpage

    I am unexperienced when it comes to navigating websites using VBA (or any code). I have been able create code to open the desired websites but now I am trying to automate "clicking a link" to save additional time. I have an excel file full of various patent numbers. I have been able to...
  16. P

    Auto applying a formula

    Hi, I have a spreadsheet that updates daily that has a combination of entered data and formulas that are applied to that data. I'm looking to see if i can automate some of my process. eg; Column A is a unique identifier that is applied to the data and increments by one for each row. Columns...
  17. VBE313

    Cant Click or Change Value SeleniumBaisc VBA

    <inputname="ri_tl_entry_web_ri_date_worked$0" tabindex="49" class="PSEDITBOX" id="RI_TL_ENTRY_WEB_RI_DATE_WORKED$0" aria-required="true" style="width:71px; "...
  18. D

    Automate the Comparison of 2 excel workbooks

    Hello!! New user and beginner to VBA. I'm trying to automate the comparison of 2 excel workbooks and have a message box in the masterfile pop out, telling me if theres a math between the total sum of items in "Books-Raw Listing" & "Raw Listing" workbooks. Here's the tricky part, the...
  19. J

    Excel Power Query Automate Import of File Navigation

    Good morning; I receive a few text files that needs to be imported and parsed. I wanted to automate this process but my company does not allow us to use VB. Is there a way to automate this process, especially the file navigation, using power query (and not VB)? Thanks
  20. gheyman

    Copy the data in a Pivot Tabe to another tab

    I want to have a button that copies the data from a pivottable to a new tab as data (not another Pivot tale). can you automate this? Can you use the Pivot table name in the code instead of having to select it manually? PivotTable1

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top