automation

  1. B

    Error on Closing PowerPoint Presentation from Excel-VBA

    Hey Everyone, so i have the following code in order to open a powerpoint presentation which i have embedded into excel, save that powerpoint under a new name to a filepath and then open that powerpoint (so that the new saved powerpoint copy is edited and not the embedded object) Sub...
  2. A

    VBA code giving error for VLOOKUP

    Hi, I'm trying to implement automation in my office attendance workbook and for that i've written this code in between 2 sample sheets, attached are the 2 sheets in which i'm trying to take value from RAW_Data Sample Sheet from unique HRMS Id column and match that with Shrinkage_Sample Sheet...
  3. V

    Vba for making a calculation based on condition

    Hi, we have a large data where we want to get some result, we have formula but want to convert it to in vba Our Steps are 1. First time we are checking the value in T column if we have got the value then second step 2. We have got the value in T8, now we have put the formula...
  4. N

    Need to constantly monitor for data update from sources for changes & alterations Is power BI right tool?

    Hi Experts, Please can you suggest if power BI is a right tool for this: Integrate data from various sources, match addresses (Removing all spaces, characters and comparing and highlighting the differences) Add columns where relevant and update the sheet based on different sources for each...
  5. M

    How to fix a messed Excel sheet and make a proper format?

    I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by...
  6. M

    How to fix a messed Excel sheet and make a proper format?

    I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by...
  7. I

    Excel Automation From Horizontal to Vertical

    This is the horizontal format This is the example of vertical format I am looking for, is a there faster way (automation/vba) for me to use? I have been doing it manually
  8. M

    Add new rows to table based on another table value

    Hi All again! I am stuck again in a pickle and I have no idea how to get out of it. I am a newbie and this forum has been a life savior. I want the orange table to add a new column and fill it with check boxes each time a new member is added in Blue table. and If a new row is added in the...
  9. D

    Get the correct dates according to selected quarter and year,

    So here goes, I have been playing around with a workbook (trying to automate it as much as possible. But I seem to be struggling with this part here. I have a basic table where the date, salary amount and the pay period go in. Now in the date boxes as the pay date is always the last working day...
  10. R

    Command button to send/display email to corresponding email address if condition is met

    Hello VBA experts, I have a spreadsheet that I would like to add a command button to that would populate an email to the corresponding email address, but only if a condition is met (an upcoming due date). I have tried several versions of code, but none have worked so far and I'm also a beginner...
  11. Elaszat

    Labeling tool hiccups

    Hello, there is a problem I have with my labeling tool I wrote for Excel. I'm afraid I have to go a while back on that. I'm working in an office where we have to print labels for our articles that we sell. It used to be a tedious process with lots of folders of examples on how to write the...
  12. S

    Unable to find element after clicking submit button in VBA using Selenium

    I have an issue with the loading of web page after the whole form is filled neatly. The next page is where i need to do data extraction. This is the website: https://enquiry.icegate.gov.in/enquiryatices/sbTrack Please find sample data here : SELECT LOCATION : HYDERABAD ICD (INSNF6) ENTER...
  13. J

    The attempted operation failed. An object could not be found. Excel and Outlook VBA

    Hello Everyone, I have created a macro that gathers all the timings from a specific subfolder on a specific date from a shared mailbox and personal sent folder. When checking the timings from the personal sent folder there is no issues, but when checking from the subfolders from the shared...
  14. G

    Code for inserting 300 rows

    Hello, I was wondering if someone could help me develop a code to insert 300 rows after a specific row. For example I would like to add 300 rows right after row 80 000 in my data set. :) Hope someone will get back to me soon !
  15. J

    VBA scraping of the date (of e.g. post issue issue)

    Hi guys, Just wanted to ask for a help related to scraping of data from the URL. I have previously used the following script (function) to extract Article/website title from the URL. Now, however, I need to extract the date of issue; e.g. when the article was published. Could you please help...
  16. G

    Transpose every X rows to columns (Automation)

    Hello, I would like to transpose a range of data (A1 to KJ1) from every second row (row 1, row 3, row 5, until the last row) under one single column (e.g. column C) in the same sheet. I am having difficulty creating a macro with a loop that will help me do this. I tried following some...
  17. reasem

    Download PDF from URL in Excel VBA

    looking to download a PDF from a URL. I can't seem to get past the login screen as the pdf that is downloaded only contains the code for the login page if I open it in NotePad. I examined the post request after logging in manually and pasted it after "FormData." I'm not sure if it matters what I...
  18. S

    1-4 strategy formula

    Hi everyone, I need some help with a formula for an automated excel sheet I have. The formula is for a Recovery strategy called 1-4 recovery. It’s goes like this: 1x your bet amount first attempt If that loses; 2x your bet amount If that fails; 3x your bet amount If that fails 4x your bet...
  19. R

    Paste Value from List into Separate Sheets

    I need some help - google hasn't led me to anything useful :( In my workbook, Sheet1 is a template used to analyze some data. Sheet2 is a list of values. My current macro asks a user how many times they need the template copied, and then copies Sheet1 as a new tab at the end of the workbook the...
  20. B

    Code for TEXT gets Bold When its get typed anywhere

    Dear All Experts. Please forgive my english as its not my native language. I am in a situation where i want to get a certain word " Pending" as bold and italic whenever i type it on that particular sheet. All the text contains in one cell with many other words , but everytime i type pending i...

Watch MrExcel Video

This Week's Hot Topics

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
Top