automate

Hi all, I currently have this problem at hand. I need to check if my source folder and my destination folder has exactly the same files by comparing it. If files that are present in the source folder is not present in my destination folder, the macro is able to copy and paste the file that is...

I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...

Hope everyone is having a great weekend! Ok...here we go. I have a button on several sheets in a workbook which is supposed to call one function. The function is supposed to look at a sheet named "CONTENTS" and search column B for matching sheet name. Eg. If the active sheet I'm working on is...

I have a MS Access application that is used in multiuser environment. I want to make maintanence every thursday between 15:00 and 16:00. At this point I have two issues to consider. Firstly, The users who may entered to application before 15:00. Secondly, the users who will be entering between...

Dear All, Please see below image, i have this job i need to do this manually everyday, if this can be automated it makes my life easier. I need macro that Populates usage end date in column T i hope i made instructions clear in Image, if anything more reuired please ask. Many Thanks for your...

Hello Guys Im new here and seeking some help in VBA okay so I have a report that I usually do, and I already made a macro that splits the report to pages depending on the country name. I want a vba that reads the sheet name, and send the sheet only to the assigned email for this sheet, the...

Hi. Is it possible to make Power BI, every week, save data in a table, in order to create a weekly history? Thank you, Afonso Mira

Hi all, So I am currently working on creating an automated dashboard that updated every time a new file is added to the source folder. I have been able to successfully get excel to update the new data every time a file is loaded. I have a 'date' column so I can extract, day of the week, year...

Hi Enthusiasts, I have one excel cell with 25 ActiveX check boxes. I have manually associated each checkbox in row 3 with a cell (i.e. the Microsoft Word checkbox in row 3 is associated with CF3, the Microsoft Excel checkbox is associated with CG3 etc). I have dozens of rows of Official Record...

Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead of manually typing out the inputs into the link, putting it into power query, performing transformations, and...

In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark) Name Mark Class Grade John 50 Post Graduate A Peter 50 Preschool A Andera 100 Nursery S In the another Workbook B, is the fixed Existing report...

It's easy to copy the value of a cell. If you want to automatically copy the value from A2 to B7, then in B7 you type =A2. But can something like this be done with cell formatting? I use a spreadsheet to track our work, and we color each item based on who is handling it (every person is...

Hello everyone. I'm running Windows 10 and Office 365. I'm looking for a formula or formulas to automate my spreadsheet. Right now this is what I have. Book1ABCDEFGHIJKLMNO11234529/1911022282940200My data is in cells A1:F250.39/1861011162540200Numbers in row 1 goes from...

I have been looking at the www.automateexcel.com to help me automate the creation of my coding. I am a poor code writer and a lot of these tools would improve my abilities, but I am curious if there are any other software that compares to Automate Excel. Does anyone have any suggestions or...

I am unexperienced when it comes to navigating websites using VBA (or any code). I have been able create code to open the desired websites but now I am trying to automate "clicking a link" to save additional time. I have an excel file full of various patent numbers. I have been able to...

Hi, I have a spreadsheet that updates daily that has a combination of entered data and formulas that are applied to that data. I'm looking to see if i can automate some of my process. eg; Column A is a unique identifier that is applied to the data and increments by one for each row. Columns...

<inputname="ri_tl_entry_web_ri_date_worked$0" tabindex="49" class="PSEDITBOX" id="RI_TL_ENTRY_WEB_RI_DATE_WORKED$0" aria-required="true" style="width:71px; "...

Hello!! New user and beginner to VBA. I'm trying to automate the comparison of 2 excel workbooks and have a message box in the masterfile pop out, telling me if theres a math between the total sum of items in "Books-Raw Listing" & "Raw Listing" workbooks. Here's the tricky part, the...

Good morning; I receive a few text files that needs to be imported and parsed. I wanted to automate this process but my company does not allow us to use VB. Is there a way to automate this process, especially the file navigation, using power query (and not VB)? Thanks

I want to have a button that copies the data from a pivottable to a new tab as data (not another Pivot tale). can you automate this? Can you use the Pivot table name in the code instead of having to select it manually? PivotTable1