automate

  1. 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...
  2. G

    >> Automate Multiple Cells

    Hi all, I'm trying to automate a cell if possible. Your assistance will be appreciated. * Cell C3 can either have a value of M or F * If C3 equals M then get cell J20 value and insert in cell E2 * If C3 equals F then get cell L20 value and insert in cell E2 cheers - Greenbolt
  3. B

    Auto Colour based on answer key

    Hello All, I have this table below. As you can see in the KEY column, is has the correct answer. In this case it is C. Is there a was to make "WHAT" the correct answer highlight in GREEN? And for the next row it would be D (They're) I would really appreciate it. I have over 100...
  4. M

    Dividing across two colums with highlights in Conditional Formatting

    I am attempting to automate errors in data using conditional formatting. My intent is to automate highlighting errors when cell data vary. Highlight cell F2 if F2/B2 > 1.5 I've tried several formula variations and cannot get this right. Any formulas that have worked for you?
  5. V

    Staffing Spreadsheet Hour By Day?

    Greetings! I'm creating spreadsheets to show how many people were "on the clock" at each hour interval for each day of the week. I'm currently adding the information manually, but it's incredibly time consuming, and as with the example below, the data keeps changing so I'd rather have a...
  6. L

    VBA - Click menu button in Frame

    Good Afternoon, I am new to this forum and also very new to VBA. For the past few weeks I have been trying to automate pulling data from a company webpage with no luck. I have got as far as logging on to the webpage, navigating a dealer select drop down and onto the main dashboard. The bit i...
  7. L

    Calibrations

    Hi, I was wondering if someone can help me please. I have a long list of equipment that requires calibrations on different cycles. Some weekly, monthly, semi-annual, and annual. I request some sort of way to automate the process as far as showing what is due. I would like to attach file...
  8. A

    Filter Linked to a Cell Value

    Hi I wonder if anyone can help? I want to automate filtering by applying a macro after inputting a value in a cell, the value of which I would like the filter to apply. While I can automate the cell value by using Combo boxes and I can apply a macro of my choice, I do not know how to link a...
  9. R

    Automatic Zoom to Width, while using Grouping.

    Hi All, I'm sitting behind a corporate firewall so posting pictures is not possible, so i'll counjour the image with words and copy/paste....maybe. Oh, I'm using Excel 2016. I hold a data table, these headings, all in their own column. (This is a sample, my actual data table is 23 columns...
  10. H

    Creating a specific table using VBA

    To Whom it Concerns, I’m looking to create a 3 layered table which to start withwould look like follows: <tbody> Table Design Construction Delay </tbody> The table should link to 3 fields within the spreadsheet for Design: Construction: Delay: Once the values are placed into...
  11. I

    Inserting user ID and password

    Hi Guys, I've been trying to auto certain processes and i'm trying to automatically login to a certain website. Below is my VBA code and the java script of the website. Until the line when its suppose to insert the userid and password, an error appeared. Appreciate any advise <form...
  12. Y

    Copy Paste Automation

    Hi all, i'm not very good with VBA. Will it be possible to copy and paste as values data from 1 workbook to another? Made a table as an example, both Workbook have 8 identical Sheets except for the data. Workbook1 contains actual data(with formula) while Workbook 2 contains projection(values)...
  13. V

    Use formula in VBA

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

    output 2d array in vba

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

    Advance date by one after each printed copy

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

    Formula for Pulling Data - Help

    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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top