automation

Hi everyone. Thanks in advance for any help you might provide. I'm looking to automate the creation of a PDF report which is based on an Excel file that I created. This Excel file (source file) generates figures which I intend to copy into another file (destination file) based on a condition...

I have next table (growing each day). In each date/time moment (row), I have some event which may be repeated within one day (or not). Problem is ID column: I am entering IDs values manually and making mistakes of course. How to make some kind of automation: a) within one day (date), b) within...

Hey guys, Looking to try automate my rostering process. Attached is a template of all drivers rostered days of work, and then a finalised roster showing what truck route they are driving. I would like to manually input the A/L (annual leave), then have a button on the left of their names that...

A while back, I used bits and pieces of code to cobble together a macro that selected, not highlighted, the current column and row of the active cell as I needed any range customizations to be unaffected. It involved, of course, the Worksheet_Selection_Change event. But it also involved a Class...

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

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

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

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

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

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

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

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

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

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

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

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

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

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 !

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

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