urgent excel help

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

I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high) If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column If I choose High to low my pivot should get sorted in...

Hi all, I want to sort a pivot based on the options Example: I have a data contains 3 columns, State_name, Lives (*integer), Coverage (*Percentage values) I have to create 3 options 1. Alphabetical 2. High to low - Lives 3. Low to High - Coverage If I choose any of the options my data...

Hi, I want to populate a cell when I click another cell Example: I have a list of data in Column A, if I click any of the cells in Column A the value in that cell should populate to B1 or some cell which we want

Hi all, I have an excel workbook having some huge data. I need to split the master workbook into separate workbooks. The splitting of data should take place whenever it finds an empty row.(splitting spot). And I want the newly created workbooks to have below conditions: 1) A filename with...

Hi! I am new here and just started learning vba codes. I was wondering, I have searched alot but Could not find a specific code where I would be able to sum the A column of the duplicates of B to D columns and deleting the duplicates. The original Data would be like QTY UOM ITEMS...

I wasn't able to find anything re my specific need in the forum: I need a macro to assign to a button to track transferred quotes. I need this macro to reference today's date against a column's date cell, to add +1 to the corresponding count, up to a limit set in another cell. "TRANSFER"...

I have to complete the following task, but I do not know what formula I have to use, can you please give me a hand? The statement is the following: How Many Spanish calls were handled by team blue during May 2020? See picture below for your reference. Thanks in advance.

Hi Friends Am Having an issue with work sheet I was assigned to keep the tracking of Vessel time spent base on different KPI KPI as follows Average time spent on Full Deck on Jack-up Rigs & Barges <16 Average Time Spent on Half Deck on Jack-up Rigs & Barges <10 Average time spent on...

Hi Guys Can anyone help out with a VBA Code that will generate Automatically Serial Number Starting from Column B2 and date in column C2 once name is entered in Column D2 Need a solution for this below is the VBA code i use but still i cant get around Private Sub Worksheet_Change(ByVal...

Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...

Hello all! I am looking for a code or formula to delete the entire row if it meets the following conditions... I would like the entire row deleted if "Column B" is the first instance (by column A) and it correlates to an "N" in "Column C". I would also like every row that contains the same...

Hi is there anyone who can help. I'm working on a project and I need a VBA Code to consolidate multiple rows based on a single column entry, then adding together the other columns. At the moment the data looks like this: <colgroup><col width="170" style="width: 128pt; mso-width-source...

HI, <colgroup><col><col><col></colgroup><tbody> ID STATUS Confirmed Status 3333 Approved 4444 Approved 2222 Approved 3333 Approved 2222 Approved 3333 Approved 1111 Not Approved 4444 Approved 1111 Not Approved 3333 Approved 3333 Approved 3333...

Hi, I have Data Sheet of a students, in which serial number and name of each student are given together in one cell. Is it possible to add only serial number of all? <tbody> ABC School Class VI Students 1 xxxx 2 xxxx 3 xxxx 4 xxxx 5 xxxx 6 xxxx 7 xxxx 8 xxxx 9...

Dears, Lets suppose I have the following database: P|GEKU1A|15|KOSVO|0|7 S|BUVBA|-25594833|-49101500|CPN|CF|0|15400|18870|23460|500|260|0|0|0|0|0|0|0 S|GEKUD|-25523178|-49023769| |TF|0|0|0|0|0|260|0|0|0|0|0|0|0 S|GEKUD|-25523178|-49023769| |IF|0|0|0|0|0|260|0|0|0|0|0|0|0...

i am new in excel VBA, and after finishing below code, the function of the code is running very well and i can save it but when i try to close it i have not responding error and it crash all excel and restart it, the code has been used is : Code in workbook : Private Sub Workbook_Open()...

HI all!, i was asked to make the files to load in the excel more robust. Meaning the excel has to be able to load two files of different name and format to produce an output. keeping in mind format as in the the way the file is named. i have tried to do some codes myself but it would not load...

1st table/report has cells with single values as well as multiple values separated by comma. <tbody> Identifier AA XY,AA,YX BE RE,WX,EW,XT AB,ER, </tbody> if any of the values in the cell is there in the 2nd table I need to filter the 1st report. 2nd table/report <tbody>...

Hi All, I need you help with the Listbox in Userform, I have two columns in Excel Raw file, Column A has got categories and B has got the unique data. I want to have all the Data from Column B in the list box, which falls in the category (From Column A) mentioned in TextBox1. kindly assist...