code & vba

Dear Mr Excel, I have a huge spreadsheet that downloads from our data system with staff initials. I need to add all the actual names onto this (firstname, surname), is there a VBA code that I could use to assist with ease? I would be very grateful if someone could assist me with this. Please let...

I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...

When I run the code code below which copies the files name, date and size to my worksheet I am having a couple issues. I believe the code is suppose to be putting them in date modified from newest to oldest but for some reason it is not showing up like that. Also im getting a run time error 1004...

Hi, I am trying to copy from one sheet to another but when I do the red text below contains a formula and brings that across instead. I have tried Paste Special but can't seem to get it to work does anyone have any help please? 'Copy and paste data from the Highlight Report worksheet to the...

Hi, we want to print on label through excel, we have the following data which is not set for print label, how can we format the data and print on label (for example we have set the data in sheet2 we have the printing sheet (12 labels) A4ST12 100S (100X44.1)mm Data Sheet P CT...

Hey Everyone! So I am getting a bit stuck here - I have a timer that works (for the most part) the issue is when the userform is hidden and re-opened the "Continue" feature doesn't work anymore. Meaning the timer doesn't continue counting. Hope I can get some help please see my code below and a...

Hey everyone, hopefully a simple question - can I code a way for the [x] button to Hide the userform instead of unload/reset my code?

Hi Experts, I cannot upload the excel file as I am using office computer. I have made a sample below table: First four Coolum is my definition where the start / end date along with start and end time is mentioned. From Column 5 I want to do a plotting of 1 based on first 04 columns. If the...

Below is the code i use i need a check to see if column i is greater than 5, if it is then send the email if not do not send the email Sub Send_Bulk_Mails() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("sheet1") Dim i As Integer Dim OA As Object Dim msg As Object Set OA =...

Hi im looking for a vba code that will separate the client and applicant solicitors onto new workbook and save them atm i have to filter client sol copy and paste ona new sheet then filter app sol then copy paste that on a new sheet , i need all Test law to go onto a new workbook from applicant...

Hi Everyone,I followed a youtube tutorial to copy data from one sheet into another sheet in the same workbook. Mind you, I have no experience in VBA. Everything was working fine until I noticed that when i add a new entry it overwrites the previous row. I want the code to find the last empty row...

I hope someone can help me! I want that when I enter a value in cell B3 (or B4), the triangle in cell F3 (or J4) moves along. Likewise, when I enter a value in cell C3 (or C4), the triangle in cell J3 (or Q4) will also move. And how to program when I have many TASK to do. It's too hard for me...

Hello, I have a spreadsheet where I want to replace the contents of a cell with the contents of another cell based on a table. I've written a VBA code that'll work if the replacement content is less than 255 characters, but gives me an error is the replacement text is longer than that. Can...

I need help changing a piece of code that @JoeMo came up with on this forum. Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim n As Integer Dim calcState As Long, scrUpdateState As Long calcState = Application.Calculation Application.Calculation = xlCalculationManual scrUpdateState...

Hi everyone, I am wanting to set focus on the last entry in my listbox, after I have added to the database. Currently my listbox only displays when an entry has been made. The listbox shows the complete database which is fine, but I am wanting to set focus on the lastline as this is the...

Hello, I am looking to create two separate buttons using VBA and have not been able to successfully write a working code for either. I am trying to have both these buttons edit every Excel file in the same folder as the excel workbook containing the button and every sheet within each Excel...

I am looking to make a Macro in VBA that when run: creates a new sheet called "results" after the first sheet (to the right) on the original sheet search Colum B for if any of an array of words is present in a cell if it is to select the row and move it to the sheet called results delete the...

Hello, I need help to hide the column "O", but it can only be hidden IF it has the value "XYZ" in one of the cells of the column "K" AND if the cells of the column "M" has nothing or i.e. be different from 0. I tried this but it didn't work; Dim C As Range Dim ABC As Range Dim DEF As Range...

I have this code to click between two cells back and forth every minute for an hour but i'm trying to make it into two buttons so i can have it run continuously and click a stop button when needed. This code i've pasted gives the blue wheel and doesn't allow me to click anything with excel. Help...

I have a code that copies data from column C or E if there's no data on column C from all sheets on the workbook except the master sheet But this code is not completely mine, I asked a colleague help to make it for me What I know is that it also depends on column G Can someone please explain to...