1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. E

    Excel\VBA automation software

    I have been looking at the 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...
  6. 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...
  7. 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...
  8. 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; "...
  9. 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...
  10. 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
  11. 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
  12. H

    Pasting image at the end of cell

    Hi All, In the below link of my data, I have to compare the values of the two cells side by side. Now I have to place an arrow(image) for the values in column A which are greater than that of B. Is this possible to automate via VBA? If so, kindly help me on this. I...
  13. M

    How to access external add in to click some buttons

    Hi, I have a Facebook Ads Manager for Excel (FAME). I need data daily in my Excel how can I automate to Click Refresh button daily and store values some other location into CSV file or directly into AWS S3. I have been struggling from some time to control that refresh button. Any kind of...
  14. D

    Assistance Needed to Create Auto-populated List

    Hi Would like to create a sheet that automatically pulls info from two separate tables when they are pasted into a file. To clarify, two different tables are pulled from a system, pasted onto two separate sheets in an Excel file. I then have to add the two lists together onto another sheet...
  15. Domski

    No more VBA

    Quiet in here these days isn't it? Anyway, the orgaisation work for is considering moving to Office 365 and a cloud based infrastructure. As part of this we are potentially going to lose VBA. This is a bit of nightmare scenario for me as I use it almos daily to automate processes or in add-ins...
  16. P

    limiting SUMPRODUCT to a certain value

    So, i have this formula =sumproduct((H2:H500,"Job 1")+(K2:K500,"200")) Problem is sometimes K says 200, others its 200/tire, etc. Is there a simple way that anytime it see "200" that it will count? Basically i have MX events to also track and trying to automate the tracking. I did try "*200*"...
  17. M

    Need help with simple Macro to assist with children's colors!

    Hi, to any Macro coders out there, I am trying to create a basic spreadsheet with a macro that does the following: On the first tab, there are two columns. A1 reads "Name" and B1 reads "Code". As an example, cell A2 contains "Billy Bob" and cell B2 contains the number 5236. On the second...
  18. R

    Row Number of Last Numerical Cell

    Hello All, I am having a bit of trouble, and am hoping someone can help me. I have a table below containing two columns: One with a planned submission, and another with an actual submission. If the submission isn't submitted, I input "Not Submitted" and if it is not required I input "Not...
  19. N

    Create Initials list from a list of names

    Hi Is there a way to either extract just the Capitals from a name list, or use the space to extract the first letter of each name? In cell A1 Paul Jones In cell A2 Adam Simpson In cell A3 Jan Van de Valt In cell A4 Tony Tile Can I automate: C1 = PJ C2 = AS C3 = JVV (or JVdV) C4 = TT Any...
  20. M

    Macro to copy data to another tab, save as pdf and send as email attachment

    Hi! I have a nice little challenge for you's (ok maybe it's not a challenge for you but it is for me! :confused:). I'd like to create a code that will 0) will go look if there is a certain value in a column cell, 1) if there is a 'Yes' in that column, copy values from certain cells to blank...

Some videos you may like

This Week's Hot Topics