sheet

Hello, This one has the potential to be quite complicated, as UK holiday law is governed under the Working Time Directive. I have been trying to make a calculator on Excel which calculates holiday entitlement and can also take into account if someone starts employment part-way through the...

I have ~50,000 usernames in Column A on Sheet1. Many of those usernames repeat. On Sheet2, I have the same usernames in Column A, followed by their employee IDs in Column B. But on Sheet2, there are no repeats. I want to copy over the IDs from Sheet2 into the corresponding place in Sheet1...

Hey guys! I have been working on a project for a while to automate a task for my work. Final steps now, but for some reason my code is not working as it should, even if I try different versions. Sub InsertColumnsAndLabel() ' Select the "YT" sheet Sheets("YT").Select ' Insert 4...

Let's say I have 2 workbooks and i have to create 1 wb1 = workbook with the macro wb2 = worbook with the info so I have an activeX button in wb1, when I click it it should copy the KeySheet from wb2, create a new workbook (wb3) and paste the sheet onto this new workbook Idk if i explained...

Hello All...please someone help a VBA code that can automate copy of sheet from open workbook and paste to other but closed workbook. Then overwrite if sheet name exist. Example as follows: Open File1 = main file, have the sheet name "report". Consist macro that copy the sheet name "report" to...

Hello guys, I picked some extra classes this semester and am now trying to create a weekly schedule of my classes. At first I made a table with all activities from my classes, but I noticed some overlaps. I have some kind of ranking system where I put colors near the class (as you can see in...

I am trying to create a code that can create Namelist amount of emails. Each email should include some specific cell variables such as name and email AND a table in which i need the header from the excel sheet and a specific row. I have tried to incoporate a take one row at a time approach but...

Hi, I would like my code to show on an additional sheet when I run it. When I try to run my code, my excel just bug. Can you help me please? Thanks Sub Question4() Dim mA(1 To 100, 1 To 100) As Integer Dim i As Integer Dim j As Integer For i = 1 To 100 For j = 1 To...

Hello everyone. I need a VBA to compare two sheets and highlights the unique values. I have this VBA, but it also highlights if a cell changed it´s position, which I don’t need. I only need the VBA to highlight which cells have different values and the unique cells in each sheets. Sub...

Hello everybody, I would like to change the colors of certain sheets, which meet this condition => If Left(cell, 1) = " " Or Right(cell, 1) = " " Then cell.Interior.Color = 65535 Sub Select_All_Cells_with_Data() Dim sht Set Rng = ActiveSheet.UsedRange Rng.Cells(1, 1).Select For i = 1 To...

I have been searching a solution and cannot seem to find one, is this possible, What I am trying to do is write a macro that will create a pivot table onto another tab. The sheet that the data is on is titled with a customer reference number which changes from workbook to workbook. Is it...

Thought I would be able to do this one, but I over-estimated my abilities. In my workbook I have one sheet, the title of the sheet changes dependent on the customer reference. -e.g. Cust250885-ref-A485FR etc. I would like to run a macro for creating a new tab ( when created - it can stay named...

Good Afternoon I have a vb statement in my excel macro that I need to dynamically change the workbook sheet just created as the macro loops. the current statement is [Sheet1!A1:J1].Resize(N).Value2 = S after that i have a line that adds a new sheet to the workbook...

I have a table of workstreams that on the go. There is a main page with all the workstreams on at the moment, and then sheets name depending on the reference for ease of tracking. So 'Home', 'ABC001', "ABC002' etc. Could I create a macro that would make a new row and record the next available...

Hello, I'm new to vba, i saw a post when i was researching to: how to copy all the details from one sheet, copy this and save it in csv format on a specific folder. Then luckily I saw the code @Georgiboy posted and tested it: Sub Print_Test() Dim FSO As Object Dim TextFile As Object Dim rCell...

Hi all, I have a program that inserts various square images onto the same size cells, on one particular sheet. From the code on a form, I want to disable all the images, to remove the grab points thus obviously preventing them from being moved, resized, etc. I also want to be able to click...

I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...

I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if...

HI! I got a new problem. I have 10 sheets and 800 rows per sheet. I want to duplicate each row 1200 times in every sheet and I want do it on go. can anyone help me? P.S each row has a formula, format, and value.

How do I do the code in the sheet itself in the "view code" when the value in column K (any row in the column) is less than 10, a message will pop up to the screen that says - "10 days left until expiration" I would appreciate your assistance!