code

Hello The below code moves rows of data to an archive sheet when they become 6 months old (as of the current date). Could someone help me change it so it moves the data as values, rather than formulas? Private Sub Workbook_Open() Application.ScreenUpdating = False 'Set...

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 have recorded a Macro to re-arrange my table with color and to sort row by date Ascending but later I needed to add 03 rules to remove all filters in the table to show all data then to go to the last row in table and to save the workbook but it seems that they need to be set in a professional...

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 /...

Greetings, I have an excel document that tracks items on a "to-do list", I have an active and historical tab. Active for anything that is still outstanding and the historical for anything that has been completed. I am running a code that will automatically transfer my active tasks to my...

I have this spreadsheet with 255 RGB Codes. I need a code to convert them to the Natural Color System (NCS). I've tried AI solutions, which gave me VBA codes but they don't seem to work. Example of AI generated VBA code: Function RGBtoNCS(r As Integer, g As Integer, b As Integer) As...

I have a macro that I run daily, after the macro runs I manually go and update what I do not how to code. Effectively there is information in a cell of a workbook, Cell G2, always G2. The thing is each week the file name changes by week number and the week number comes from Excel...

In the last few years, Excel seems to like to hide my subroutines. I open developer and whether I select VBA or macros -non of my functions are displayed. They exist -the spreadsheets are making calls to the functions and they are working. But where the heck is Microsoft hiding them? See...

My code deletes all but the first row of my table, tblETS. But when the code runs I get prompted with "Delete entire sheet row?" I've deleted rows like this before but this is the first time it's prompting me. How can I keep that prompt from popping up? Private Sub PrepMyTable() Dim wsCopy As...

I know this has been asked many times here and in so many different ways before. Still unable to figure out a way to achieve this as per my needs. So, I'm looking for a VBA code to insert multiple photos and arrange them in specific manner(not inside the cells) and resize with custom width...

Hey everybody, The goal is to clear the cell in column G if I put an x in J. (I have another sheet where all workers are listed and it's supposed to show a worker as busy if he is mentioned in this sheet. Have problems with this one too, but thats for another day🥲) I've been working with the...

Hello guys, I'm new to VBA coding, so I used an AI to generate a code for me, but it didn't work as I intended. I have a workbook with dozens of worksheets, my idea was to put a button with this macro to copy the same cells range of the active worksheet and to paste this values as a new line...

We have the following data, and want to copy and paste as per result sheet, Data ABCDE2070986SHUTBJTNEFT10/30/21987453.0021FDSFJDSFLDSJFSDKLSDHFDSHFHASDFDSFDSFSDF1-Dec-211-Nov-2222TELDFDSFS23980874AHDFDFPUM11/1/2198765.0024DFSFD FDSFSDF 4335353535351-Dec-211-Nov-2225Email...

Hello everybody, I'm new here and also fairly new to Excel VBA. My problem is that I have two subs 'combined' in one sheet, but only one works. The first part of the code enables me to select more than one worker in column G from a drop down list and is working just fine atm. The goal of the...

Hello All I created this code. evrithing seems fine but ALL THE TIME error 5 Sub Exportar_Imagenes() Dim img As Shape, tempChart As ChartObject Dim sPath As String, sName As String Dim imgEncontrada As Boolean ' Ruta donde se guardarán las imágenes sPath =...

Hi, My Excel file freezes,stop working and took a very long time (15 minutes) to finish when apply the formula in G3 to the last row then loop next column. CDEFGHIJKLMNOPQRSTU1Point...

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...

we have the following data and we have copy the sheet1!B2:C2 and pasted on Sheet2!B2 and transposed it, again we have copied the data from Sheet1!B3:D3 and again pasted on Sheet2!B3 we will copy the data and check last filled row in sheet2 and paste transposed data in sheet1 data may be long...

Hi, we have the following sheet where we want to split in row wise instead of column wise, can we do this from macro or any formula, its a large database query sheet...

help please, We have the following data where in data sheet we have multiple entry, we have also recored a macro and want to it will run in whole sheet, help please we are copying the data Sheet1!C3:C6 and pasting as transpose on Sheet1!C2 and after that copying the Sheet1!G6 to Sheet1!G2 and...