automate

Hi, I want to use below formula in VBA for automatic calculations. As there are lot of formulas in the sheet, I want to automate the sheet using VBA. =COUNTIFS('Workflow-csv'!$AL$2:$AL$65000,B21,'Workflow-csv'!$AM$2:$AM$65000,">="&'Monthly...

Hi, I have an array that is xx(1 to 121, 1 to 121) as double and I want to paste the array to the worksheet. So I did... Range("DM2:IC123").Value = xx But what if the size of xx changes? Is there a way to automate the output maybe using the ubound? I'm thinking I would have to set a...

Is it possible to have Excel advance the date by one for each copy of the workbook I print? I have a workbook with names on it, used to sign out equipment. The workbook has 6 separate sheets in it. I have the date in one cell on each sheet (it's the same cell on each sheet). Currently I...

Hello, So I would like to be able to enter a date and have that weeks worth of data pulled into a location. See Image. On the left hand side, there is the raw data with dates and info. I would like to be able to enter date into right hand side box and have the following 5 days auto populate...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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