excal vba

For example…… ( Please explain and give a solution step by step) Student ids (sheet 1-it has more column like this) Column 1. Column 2. Column 3 0000 Sunil. Maths 1111. Gayan. Science 2222. Ranjith. History 3333. Tharsh. ICT...

Hello, I have posted my excel VBA code below, I made it so when I double clicked on cells AP6:AP85 the user would be prompted to choose "Fixed" or "Variable" to use in subroutine get_supplier_rate. But when a user picks Fixed or Variable it replaces the original numeric value that was in cells...

Trying to email as a PDF selected ranges with VBA. Hi I tested using ChatGPT to ask the same question and i got the results below. But the data emailed is not using the slicers that are selected. It emails without slicer sections. I want filtered results. Can anyone help. Sub...

Hi guys, im have Problem and i hope u can help me :) i just want to insert one row for every duplicate row data/ Table and fill that with something from each duplicate data, u can see image below Table A --> Table B --> Table C I Hope u help me With VBA Thankss ;)

Hi, i am working on a new employee performance evaluation form. Managers will fill the form for each of their employees semi-annually (attached). Each employee should have a minimum of 5 objectives and a maximum of 10 per each 6-month period. In the old evaluation form, each objective had a...

Hi, Hope you're all well! I am somewhat of a novice when it comes to VBAs/Macros. Just really know how to enter codes and run them - hopeless when it comes to understanding what is what etc. I have a long way to go :) Basically, I was hoping for a code that will compare 1000s of entries in...

Dear Excel Genius I have produced some products in my company which are having or use different raw materials purchased at different prices. I want to calculate the product's price per kg by using the (Raw Materials) FIFO Method. Below is the example data I have calculated Products 1 to 5's...

Dear Expert, I hope all are doing well. I have a requirement to retrieve the API data and the retrieved data will be displayed in an Excel cell. So, I successfully retrieved data from the API. But, I wasn't able to display the retrieved data in an Excel cell. Can you please help me with this...

Hi guys, I have 2 excel files that I want to have when applying macro and exporting data from excel 1 to excel 2 this condition: In the NOOS/SOPO column: If you select NOOS in Excel 1(from Drop-Down) , the NOOS column in excel 2 will be Yes If you select SOPO in Excel 1, the SOPO column in...

I want to save activated worksheet i.e.template at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet(template) 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...

hello programers can you help me i need a program every 1 hour auto check email inbox outlook if the email body content write ( please file)this email is move to the 1 specific folder like "download folder'' .i hope u are understand my english is very bad english..

The following are the conditions that I am trying to achieve Sort Column F and H, then add a row when there is a value change in both rows. The condition must add a row when the values change Sell - D Sell - S Buy - D Buy - S After creating the blank row the Column I must sum the values by...

Hello! There is the need to open the first and only the first Excel file present in a specific folder. I am having some trouble using the Dir function with a relative reference. This code is working when the full path is there placed, but the reference must be relative: Dim FileName As String...

Hello, I have searched for a solution to the question I have asked, but can't find any that work for me. Either because I am running 365 on the Mac platform, or I just plain dumb (or both). I have 2 sets on columns D to G and J to M. each independent of one another. I need a button to Hide...

Hi, I am new to VBA, please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" automatically or some action. The table 1 is located in Sheet 1 and table2 is located in Sheet2. For clear understanding I have...

I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...

I Want to insert all listed Gifs from a folder into Spreadsheet, then by selecting a Gif, and then by clicking the command button in the sheet an user Form should pop-up and display the Gif. I tried to display the Gif directly in the userform using Webbrowser object. It was working. But i dont...

Hi i have userform with the all the data adds to the "VehicleRejected" Sheet from a userform however i have added an code for user to select an image from their drive and now i want userform to add the image against the data on same row. below it is placed in a image2, whereby user can select...

I am very new to VBA coding / excel as such. However I have designed a VBA based program for my needs based on several online VDOs and working satisfactorily. However the validation code for data entry is not working at all and data can be processed to next step without entering full information...

Solve this query....