urgent excel help

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

I want to have validation while saving (without using macro) Lets say i have cell A1 to A10. If i enter data in cell A1, only then it should give validation message while saving that "Cell A2 to A10 should not be empty." Generally if cell A1 is not blank then cells A2 to A10 should not be...

Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...

Hi, I have a list of 70 clients with contract amounts and start dates on one tab. I need to make projection for 12 months in a way that for each customer no more than 15,000 monthly revenues is included in the forecast. For instance if the contract amount is 42,000 USD then I should account...

Hi Guys, I am doomed, Please help me I need your help to create an interactive Dashboard, I have a data divided is Categories and sub categories. Complete data is divided in 6 categories, Which further are divided,1) Location wise, Further divided as 2) Manager wise and so on it end at...