excel2013

Hi , Want Regex in excel formulae as mention below input and output for reference. Input Output 3005AB1394714000000 AB139471 2022ABR52447FPV ABR52447 2022A9561554PPV A9561554 2022ABR52240LTW ABR52240 2022PAR45939FPV PAR45939 2022PNN03733FPV PNN03733 2019Z6167512 Z6167512...

I need some help as I don't think I can record a macro that would do what I need to do. The macro which I wanna code would: Verify in column J if column contains a "x" text value or a date or the text value "ANOM" the x value means not treated, the date means it has been treated and ANOM means...

hi guys, I'm using the below formula to make a summery in my first sheet. This formula is working nicely without any problem, but if there is an additional row with cell value "Total=", then it gives no result of that sheet. I just want to add additional conditions in this formula to grab only...

Hello! I have a problem, I am completely green in programming and I need to write vba code which will copy data from one sheet to another. The problem, however, is that I have to copy the second column with a maximum of 17 tables (the number of tables and rows in the table varies depending on...

Hi Guys, Here I'm with a complicated situation, I have many styles packed goods in carton, now I have to re-pack again for air shipment, with below condition. FILE IN GOOGLE DRIVE Sheets are; 01.AIR-QTY 02.CURRENT-PACKING 03.DESIRED-PACKING We will turn sheet "CURRENT-PACKING" to sheet...

Hi Guys, I have an excel file with some file/style name with corresponding file/style weight. ABCD1STYLEWEIGHT2AA-0011103AA-0021304AA-0031505AA-0041706AA-005190D3:D6D3=D2+20 And I also have some files in a folder in "E" drive, with the style name with some prefix as below. SS_AA-001.xls...

Hi There, I'm re-arranging data from column A:E to G:O. While re-arranging, I'm getting blank cell in soeme rows of column G, H & I, it's because of my current formula at cell g2, h2 & i2. I need help to have the alternative formula for this 3 ( g2, h2 & i2) cell, to have the same result but...

Hello There, Need correction in formula at J2, it's not giving the correct output considering the header J1:O1 Please help me to sort it out, thanks...

Hi Everyone, I want to check the result of the formula before inserting it into the cell. If the formula generates a 0, then I don't want to insert the formula into the cell. How can I do this? Here is the part of the code, where I want to do this. Dim c As Range For Each c In Rng...

hello all. i have sales data with the following: A B C D Month-year | Part number | SALE QTY 2020 | SALE QTY 2019 02/2020 XXXX 2 ..... ... ... XXXX...

Sorry if this is in the wrong location, this is the first time I am posting on this forum. My issue is a regarding a "Compile Error: Method or data member not found" that happens when an excel file is opened by some users. These users have either excel 2013 or 2016 installed. The compile error...

Hi I have a question. I have data in sheet 1 (C2 COLUMN) IN ENGLISH, AND IN SHEET 2 ENGLISH (COLUMN B2) AND CHINESE (COLUMN A2). I want to match the english from sheet 1 to sheet 2 if its correct then the chinese will appear in sheet 1 B2. Can you help me. Thanks Nitesh

I found some code from https://contexturesblog.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/ and I was wondering if anyone could help me alter it to my needs. The first bit of code in VBA from Microsoft Excel Objects is: <code style="margin: 0px; padding: 0px; border: 0px...

1. How do I write VBA to convert a range to a table (with color scheme selection). 2. How do I write VBA that will detect if a table exist then revert it to range (unformatting the color scheme selection). many thanks..

I made two codes for one sheet to not allow copy paste and right click for column A only. It work just fine for column A - but when I tried to copy on column B - the marching ants did show up but immediately disappear when I shift cell to copy. and it won't paste.. what is wrong with the codes...

I would like to copy range("C1:C16") in Sheets("summary") and paste it to the rest of worksheets on range("E3") ..excluding Sheets("summary") how do I write the subroutine code? many many thanks

I have multiple workbooks in a directory and each with only 1 worksheet. I wish to insert those sheets (including all formats) from every workbook to a master file. If it is possible to use a file dialog box where I can just select the files to insert - the better. (else, the usual identifying...

I have a workbook which i use for technical analysis. It works perfectly in Excel 2003, 2007 and 2010. However when i use it in 2013 if I try and type in an unprotected cell Excel treats it as protected, even though Properties clearly show Unprotected. This happens only after I have used...

Hello, I have created file wherein the button will auto transfer the row from Customer tab (sheet1) to Closed tab (sheet2) when the CLOSE sign is indicated in col K (a.k.a auto transfer when criteria is met). It is already doing the functions that I wan it to do, except for 2 last functions...

Hello fellow geniuses. I work in Excel 2013 and am very proficient in many things. However, I was asked a question that stumped me and I have never even thought of it. The boss of my wife, who is not very smart when it comes to Excel and wants to cater to people who are not proficient in...