excel vba

Hello, I'm currently learning excel and vba. I was tasked to create a program and a part of it is to allow users to log in. In a separate userform, the user registers their account together with their other information. The next step is to enter the new user form to login and see their...

I'm running into a unique situation dealing with duplicates. I have the following sheets: Sheet1: Sheet2: Sheet3: My current macro included in the workbook will compare any two columns within individual sheets and delete them. Sub delete() Dim x As Range Dim lstrw As Long Dim sh As...

pincode vendor rating pending cases 1 xyz 2 0 2 xyz 2 41 3 xyz 2 45 1 xyz 1 4 2 xyz 3 17 4 xyz 2 0 5 xyz 2 45 6 xyz 3 17 This is my excel data i want to copy all the unique data of pincode to another excel sheet.. For eg. here there are pincode "1" which has 2count then all...

I have a report that I need to update from the data in another report. Both reports are large, over 50,000 rows, so I read them into arrays so the process would run faster. I need to split the Source array into separate arrays based on certain conditions in the HR array. I'm getting an object...

Hello Everyone, can you please help me with a code that will sum up values based on condition, Here are the details, If sheet "Control Panel" Range(A2)=sheet "BOOK1" Range(B) (search in all rows from B2 to B down) If sheet "Control Panel" Range(B2)=sheet "BOOK1" Range(L) (search in all rows in...

HI i have set of data rows which i need export to word file with images Data in row from A7 need to export to word one by one after image In column O:O contains image path with name after export data values image need to upload followed by text, please find the excel file and expected result

I want to save activated worksheet at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75 Tried below code Code...

Hi I have an excel book that is a template and gets populated through Power Automate and only the headings of the table exist. The data in the table can vary in amount of rows The data is pulled from a database where it has different levels and the Name needs to be indented according to the...

I am trying to generate printable stickers from Data I have in Excel. I currently have 4 columns of Data, Columns A and F are the values and C and H Barcodes were generated from Columns A and H: The problem I have is trying to format and mass generate printable Barcode sticker labels from...

i have 3 set of data value with code value , i want list out table values from source code values for e.g 3 tables have set of data Table A.......................................... |TAble B............................. |TAble C....................................|...

Good morning all, I'm having some difficulty with setting up a macro which will trigger if two conditions are met in a worksheet. Require a message box to appear if the value in a particular cell (D4) in the D column shows the keyword “Supplier” and if the value in a different cell (H7) in...

I've got 2 seperate files. One is a macro-enabled excel(Data) with userforms ad another is a macro-enabled word(Cover Page) with userforms. I want to combine these 2 into a PDF to form a report. Is something like that possible? Could you also please refer to helpful articles on this situation...

I am trying to generate printable stickers using Mail Merge from Data I have in Excel. The Data I have: Using Mail Merge it turns into this as the Font changes from Code 128 in Excel and into Calibri in Word: Ideally, I would like it to look like the first record automatically but I had to...

im very new in VBA, and i gonna appreciate who ever wanting to help me... Here i have a case, i have several conversation action that linked with Hyperlink. lets say conversation module placed in cell Q6-Z6, and every cell has a title as a code (p1-p9) which placed on cel Q5-Z5.. i want to make...

Hello everyone, I need some help in recompiling this code. It is meant to copy a range from a sheet, paste the range in a new sheet and save it at a given directory. It works as expected, except that it copies and pasted the range at A53:I54, while I want it to be pasted at A1. Plus, if possible...

Hi, I'm trying to do a research in a userform from a date, I can search from a word but can't figure out how to do it from a date. Like here in the picture, from the textbox I have to enter the date of birth then click search and then the looked for data would go in respective textbox. Can...

Hello, Fabrics are to be cut to certain sizes. Example; 24 pieces of 225 cm 32 pieces of 175 cm 88 pieces of 150 cm 24 pieces of 75 cm 32 pieces from 50 cm 80 pieces from 35 cm These require 304 meters of fabric. One ball of fabric is 6 meters. 51 balls of fabric is enough without any loss...

Hello, I need some help with coding in Excel VBA. I have a file with 2 worksheets, and I have to code a macro in VBA, but I do not know how this works... In WS 1 there is data being added by some formulas that extract data from WS 2. I have to operate in WS1. In column F there is added, what...

Hello I have two workbooks one in which i wish to copy from and the other i wish to paste into. My source workbook some cells have formulas but some have values and i would like to paste as what they are in a tare workbook but the same way So if source cell copying from is a formula then paste...

Scenario: There have two excel files, one for 2pm and one for 3pm meeting. The files are not exact same, but currently we need to copy some of the data from 2pm file to 3pm one everyday. Requirements: Only copy the value between two worksheet on two different workbook (2pm and 3pm) if they have...