Search results for query: *

Also posted here: https://stackoverflow.com/questions/50614124/excel-conditional-formatting-fo-when-any-cell-in-usedrange-changes-value down vote favorite I have to send workbooks off to managers in different departments and in each workbook, the managers might amend/change certain fields...

I have 3 xlsm workbooks with a bunch of macros inside of them.. When each one is opened, the user is presented with a pop up that asks if they want to execute the Call_All macro which would run them all. If the user clicks yes, then it executes, and if no then nothing happens. The reason I have...

Also posted here: https://stackoverflow.com/questions/50294190/vba-remove-duplicates-across-multiple-sheets-in-workbook?noredirect=1#comment87610856_50294190 I have multiple sheets in a particular workbook, and n each sheet there are Employee Numbers. The sheets have already been sorted in a...

Originally posted here: https://stackoverflow.com/questions/50248746/vba-apply-filter-across-multiple-sheets-if-column-header-is-a-match I have a macro that renames certain headers, deletes certain columns and inserts a row on specific sheets. I need to apply a filter across the sheets IF the...

Also posted here: https://stackoverflow.com/questions/50251293/vba-find-lastcolumn-and-check-if-first-row-is-empty Some of the sheets in my workbook do not have headers, so I use the below code to insert a blank row and assign a header to column A - I know column A will always be employee...

Hi All, I am trying to create multiple sheets in a single workbook from the file names of all the files in a particular folder. Example: 1) A folder has 4 .xlsx files and their names are: MyFile1, MyFile2, MyFile3, MyFile4 2) There's a workbook that has only its default sheet inside 3) The...

Hi All, I have 1 main workbook with one sheet only containing user data This worksheet has 11 columns The column headings are as follows Main wbk1 wbk2 wbk3 .... etc I have another workbook with 10 sheets; each sheet also containing user data Each worksheet has 2 columns - Employee Number &...

Hi All, I have a folder that receives many csv file extracts which I need to convert into xlsx files instead. I have the code below which I found on one site, but I receive an error at line 3 Dim CSVfolder As String Error: I haven't been able to test it yet, so I actually have no idea if...

Hi All, I have what seems to be a huge task and as I am not at all skilled in VBA it seems even more daunting.. This is the scenario: 1) Everyday there are 3 csv files exported; Each of them come from the 3 tools that manage employee records 2) These 3 csv files contain the TERMINATIONS of...

I had a previous question where I needed to search a single folder for the 3 latest files in that folder then copy those 3 files to a new folder - this question got answered and the thread can be found here...

Hi all, Everyday around 7 AM there are 3 csv exports extracted into a specific folder and the file names are exactly the same each day except everyday the prefix of the file name is amended to the current date. Example: 16-02-2018_Test1 will change to 17-02-2018_Test1 16-02-2018_Test2 will...

Hi All, I have some code that creates worksheets based on a cell value in a column and then I have the below code which will scan the same column and move the entire row of that sheet to the matching sheet name. Sub CopyRowData() 'Declare variables Dim x As Integer Dim y As Integer Dim i As...

Hi All, I have some code that creates worksheets based on a cell value in a column and then I have the below code which will scan the same column and move the entire row of that sheet to the matching sheet name. Sub CopyRowData() 'Declare variables Dim x As Integer Dim y As Integer Dim i As...

Hi all, This is my first post, forgive me if there are any issues, I will be happy to rectify them if need be. Please note, I am not a VBS or VBA programmer, I am learning as I go and at the moment I have been stuck on this for 3 weeks. I am aware that there are dozens of threads all over...