code

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

Hi, we have the following sheet, where we have some data and want to format them in a fix problem is that, there is two type of questions, one have four option and other have some statement and after that option, please check and update Data ABC11Supreme Court of India ba2(A)Examine...

Hi all, I am a completely new user to Excel Macros! I have sourced myself a code from this site, that goes a little something like: Private Sub Worksheet_Activate() Dim LookupRange As Range Dim MoveToRange As Range Dim MoveDay As Long Dim ClearRow As Range Set LookupRange =...

Hello All, I am having trouble, I hope you can help. I have tried a few different versions of code with no success. Example of what I require: Compare ("Sheet1") Range K4:K1000 with ("Sheet2") Range K4:K1000 and if there is a duplication, copy the "non-duplicates" from ("Sheet 1") Columns(B:O)...

I will explain step by step so I can explain more clear I have this form The data is extracted from this range when I click in the list box value it shows the following form with the values filled but some values are not in the listbox, some of them are in the sheet range I'm using...

Hello helpful people! I am trying to import specific cell data from Workbook1 to Workbook2. This needs to be an on-demand action so a button would be best to simplify matters. The button should be on Workbook2 as Workbook1 will change every time. I have never written code nor even looked at...

Hi, Below are the requirements: 1. How do I select A4:A5 dynamically so that it'll take into consideration whenever a user deletes or adds a row? For example, if a user adds a row within that range, the code needs to recognize that and select appropriate range of cells. 2. Put the sum of the...

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

Hi everyone, Is there an excel VBA code that allow you to replace part of a formula after cells selection ? For example, after selecting multiple cells, select the code to replace SUBTOTAL(9, with SUM( Some formulas examples: =SUBTOTAL(9,EA10:EA12) change to =SUM(EA10:EA12)...

Hi I can't XL2BB as my work won't allow it: I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...

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

I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3. The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?

Hello My code is set to wipe a workbook based on a date Private Sub Workbook_Open() Dim ws As Worksheet ' Check to see if specified date is passed If Date >= DateSerial(2023, 7, 6) Then ' If it is, loop through all sheets For Each ws In ActiveWorkbook.Worksheets '...

Hello, I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday. We...

I am attempting to add a new sheet after a specific sheet. Best I can remember (it has been some time back), it worked in standalone mode in a short test macro but now that I have integrated the code below with the rest of the macro code, it is not working. It compiles fine but at runtime, it...

Hi all, I have this formula: =IFERROR(SUM(IF(FREQUENCY(IF($A$2:$A$101=A2;IF($D$2:$D$101=D2;IF($H$2:$H$101=H2;MATCH($I$2:$I$101;$I$2:$I$101;0))));ROW($A$2:$A$101)-ROW($A$2)+1);1));"0") It checks the following sheet (please note that A2, A3 and A4 have the same value): ' I want the formula to...