automate

  1. E

    VBA Help: Extracting website information with Internet Explorer

    Hi all, I'm a VBA rookie and I have only just begun my dive into this deep realm of new learnings due to the limitation of formulas. I’m attempting to use VBA to open internet explorer, click a search button, then extract the tabled information presented. The website is...
  2. M

    VBA with PivotTables

    I have two workbooks, each containing a pivot table. The two pivot tables contain the same fields, but the values are different. What I'm trying to do is use VBA to add Fields to "Rows", one at a time. So let's say the pivot tables have 5 fields: Dollars, Account, Activity, Category, Category 2...
  3. S

    combining 2 excel sheets into 1

    I want to combine my weekly reports into one master file. After I copy paste them into one sheet, I have to go through them manually to match all the rows. There can be 7000 plus rows and it takes all day to manually fix them. What can I do to automate it? V lookup only work on one column. I...
  4. D

    VBA to change date in Data picker on web page

    Sub getdata()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> Dim ie As New InternetExplorer ie.Visible = True ie.navigate "https://app.scheduleonce.com/Home.aspx" With ie While .Busy Or .readyState <> READYSTATE_COMPLETE: DoEvents: Wend...
  5. U

    VBA Query - Outlook/Excel

    Hi All, I was wondering how I would go about extracting data from an Outlook Email to Excel. Say for instance I receive an email with a table of data and I have 10 of these emails which I have to many copy and paste into a blank excel table, how could I go about creating a VBA macro that will...
  6. 5

    Automating a workbook

    I have a workbook that has multiple worksheets. One of the worksheet is a summary where I want it to to automatically pull employee median and employee location data coming from another worksheet. I tried linking the worksheets and it doesn't seem to work. If that can be automated the way I...
  7. V

    VBA Macro to Copy Paste and Autofill

    I have to go through excel files with multiple tables within one sheet, one after another, and copy and paste the name and unique ID of the table then paste, autofill to the side of it. To lay it out more clearly, this is what I do manually. Copy the name and id of the first table in A3 and B3...
  8. J

    Automate the Hyperlink process for multiple cells to folders?

    I want to make a hyperlink for these cells going to folders of the same name. I would like to automate this process as I have over 250 individual cells to link to folders accordingly. Is this a possibility? 201712001 <= i.e. to folder D:/2017/12/201712001 201712002 <= i.e. to folder...
  9. L

    Copy data from report header to each transaction.

    Hi VBA SuperUsers, I've converted a txt file to excel and as many of you know the report headers are repeated in my excel document based on each change in page number on the original txt file. What I would like to do is take one piece of information from the header (the bank lockbox) and paste...
  10. D

    Automate current method

    Hi All, I have a .xlsm workbook that I use to create invoices for an organisation. The workbook contains 2 worksheets: Kliente - this is tabular list of client and their details. client (row) details (columns) Faktuur - a form that is populated using data from the "kliente" worksheet. I...
  11. W

    How can I automate double clicking the bottom right corner of all of the cells in a list/table?

    Hello, Thank you for considering my question. I am making a spreadsheet that involves a lot of double clicking the bottom right corner of cells. It would save me, I think, a few days to be able to automate doing that. To be more specific I made examples below of before and after of what I would...
  12. S

    Need some help to automate a laborious process please

    Hi all, I'm not sure if this is possible but I'm looking for some help to automate a process that I have to repeat week in week out on numerous spreadsheets. Let me explain how I currently do things: Each week I get long spreadsheets full of data, these spreadsheets are always the same layout...
  13. 0

    How can I make sure people are using the latest design excel file?

    We collect data from companies on an annual basis. The spreadsheets may have subtle changes from year to year so not always easy to tell immediately if the file they sent is using the most recent model. I am developing some VBA to automate data upload to Oracle and I want to be able to determine...
  14. T

    Automate Power Query

    hello, i have a query that i want to apply it to an excel file. ¿it is possible to automate it? thank you
  15. H

    Automatically include added rows in complex formula?

    Hi all, Hoping someone can answer this question for me. I have a dashboard on one tab and a raw data sheet on the other. The dashboard has COUNTIFS() formulas pulling data from the raw data sheet, but my issue arises from when I add rows to raw data sheet and the COUNTIFS() do not include these...
  16. S

    Macros running beside each other taking same data.

    Hi, I have an issue where I created a workload distribution tool in excel that quite simply, when you click "next case" (button that has macro assigned) it cuts the data from another workbook where a table of cases are sitting ready to be worked. The problem I have is that when 2 people have...
  17. M

    Median of the last 7 non-blank values, offset from a cell

    All, I've scoured the internet looking for an answer to this problem, but am left unsatisfied. Maybe i'm over complicating things, & I hope someone can help me out. I currently have a spreadsheet that is updated on a monthly basis where I need to calculate the median of the last 7...
  18. T

    Append Data with Custom Hashtag, Automate with VBA & Button

    I'm looking for a bit of help for a pretty straightforward small project. I'm fairly familiar with all the basic functions of excel, VLOOKUP, pivot tables, etc., but clueless when it comes to VBA. I realize it can probably be done manually pretty easily, or using helper columns or similar, but I...
  19. K

    Automatic rolling dates in an embedded chart

    I am looking to create a Gantt Chart with date/duration data. The setup is that each column header is a milestone, each row is a different project, and the data in between are a mix of dates and durations in order to build the Gantt Chart. I have embedded this chart in SharePoint but was hoping...

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
Back
Top