automate

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. https://ibb.co/SmWGk4L Is this possible to automate via VBA? If so, kindly help me on this. I...

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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