help - macros

The code helps me to merge files. Excel auto changes the formatting of dates after merging the files. I have to use text to columns to format the dates again. Is there a workaround to keep the original format? I am using excel 2016. The dates changes from DD/MM/YYYY to MM/DD/YYYY after the files...

I have 3 sample csv files and I want to open/select 2 of the files and copy only the matching data between them into a third Master csv... I have included pictures of the 3 csv files with random data & timestamps. I am new to VBA so my code prolly isn't great but... 1. MasterCSV = the csv i...

Hi there, These are some screenshots of what I'm trying to do: I am trying to split the Alias names into in new rows. There can be 1+ alias names which are separated by semicolon (;). The name format is LAST, FIRST MIDDLE; LAST, FIRST MIDDLE..... Then I need to duplicate the DOB and...

Hello all, I am using the following macro to assign UniqueID from one sheet into a judges table sheet Sub AssignUniqueIDs() Dim sourceSheet As Worksheet Dim destinationSheet As Worksheet Dim judgeSheet As Worksheet Dim lastRowSource As Long Dim lastRowDestination As Long...

I created a workbook with multiple time cards (1 for each employee on different sheets). I need a vba code to copy and paste from each sheet into a compiled master sheet ("Data") The first line of data in each timecard sheet is in B8:H8. Some timecards could have a variable amount of lines from...

guys i made a macro in excel i want to copy the table when i run this macro the table area duplicating itself please help me, thanks Sub screenshot() Dim w As Worksheet Range("D1:F7").Select Selection.Copy Range("C4").Select ActiveSheet.Pictures.Paste.Select 'when i remove this...

Hi, I'm trying to create an Inventory Count Database in Excel using a Macro/VBA. The concept is for the Count Team to enter in an Item Number and Bin Number (which I have Data Validation on to prevent typos/errors). The Item Description is a formula that will pull the description associated...

When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...

Afternoon all, Firstly I'm not even sure if this can be done, so I guess that is the first hurdle. Secondly, If it can can I have some help with even starting the coding/recording a macro as I can't even think how to start this. what I'm trying to do: Using the below table when I enter a new...

I've been working on a report that I clean and collate using PowerQuery, and it's been fantastic. However, I'm facing a slight issue when it comes to taking the output (which has been split into worksheets, with one worksheet for each work group) and creating a new workbook for each sheet. My...

I want to disable print for all users manually, Just print only from the macro assign button (want to use for small office billing invoices) Sub PostToRegister() Dim WS1 As worksheet Dim WS2 As worksheet Set WS1 = Worksheets("INVOICE") Set WS2 = Worksheets("DATABASE") WS2.Unprotect...

I would like to consolidate columns A2:I2 based on the criteria that A2:D2 are the same on the next row. I have attached photos of the whole document to provide how this is supposed to work. I cannot seem to figure out consolidation and I maybe overlooking it. I have the code pasted below...

Hi, I'm trying to create a macro that will replace all the "1"s in a column with a value in Range "A1", then move onto column 2 and replace it with the value in Range "B1" and so on. this is what I have so far Sub Macro2() ' ' Macro2 Macro Dim X As Integer X = InputBox("What column...

Hello, So, I have a question if you have ever encountered this, if it's normal or how to solve this problem. I am new to macros, and for my project in work I have a table with information. However, this table is important for three different departments, and every department needs different...

Hi All, I am wondering if anyone could help me please? I have been given a folder called "CPET" which contains an number of workbooks which all of which have unique data but on the same rows and columns for each work book (please see the picture below). I have been asked to put all this data...

I'm currently creating a sheet for some weekly workouts and I wanted to create a randomize button, using macros, that takes an x amount of exercises from a list and assigns them to their respective place - this way the workouts wouldn't get repetitive over time. I'm veeery new to VBA coding, so...

Hello all I'm trying to set up a new spreadsheet for compiling quotes for my company. I've next to never used VBA before so this might as well be Greek to me. I'm trying to get two buttons to work The first, being the "Save Workbook As". I found the code below and copy/pasted and it seems to...

Hi! I am new here and just started learning vba codes. I was wondering, I have searched alot but Could not find a specific code where I would be able to sum the A column of the duplicates of B to D columns and deleting the duplicates. The original Data would be like QTY UOM ITEMS...

Howdy dear Excel specialists, This is my first time on any Excel forums. I've tried to look at other threads before posting this one, yet I don't seem to be able to apply it to my own situation, nor can I understand a thing of that VBA witchcraft. So I have this main table that regroups all...

Dear Patrons, Newbie here. I want to append/combine the highlighted worksheets- 5 int & 7 lql (screenshot Item 1) from multiple workbooks - 20220601, 20220602, 20220603.........(screenshot Item 2) into two worksheets in a new empty workbook - Master File (screenshot Item 3) . Any help is...