urgent excel help

  1. L

    VBA - Consolidate data and Sum mulitiple ranges

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

    Multiple Criteria

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

    Addition (Possible) ?

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

    Store some TXT values into an Array - New Type of Question

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

    Excel with VBA save good but crash on close Very Urgent Please !!!!!

    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()...
  6. S

    VBA excel, able to load even with different file name

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

    Cell with comma seperated values and vlookup

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

    Excel User Form_ List Box Macro

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

    Need urgent help on this

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

    Urgent Excel Help Needed Again!

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

    Excel formula help

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

    Excel Dashboard

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

    Excel Formula to VBA

    Hi, Need your help to convert the below formula into a Button VBA, If I use this formula directly on the sheet it is getting stuck into a Circular Referance, Circular referance is because, Q7 is getting calculated from the Range selected, but I want the entries to happen in the Range as per...
  14. S

    Sumif Inception!

    Hi Everyone, I maintain a contracts database and need to automate the total qty column. Having a really tough time getting it to automatically show those numbers. Summary: This data represents one contract (internally it is contract #18, externally, it is contract #21). It is broken down into...
  15. T

    Problem with blank cell in finding top n values

    I want to find the sum of top 3 values from several datas..But if my datasheet is not complete(that means i have less than two datas) and I want to get sum of the two datas..How can I do that?(if I put 0 on the blank cells,it works.But I dont want to put 0,I need to solve it by having the blank...
  16. W

    VBA Macro to Select range and copy paste to another sheet continuously

    Hi, I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing...
  17. J

    Duplicate help!!

    Hi, The overall problem I have is that I need to identify codes found column H and column J that match, When they match I need to identify if the order number is different in column E. So when the number in H has a match then look in in J for a code that duplicates. H J...
  18. W

    how to pull multiple dates from another workbook

    <tbody> friday monday part qty date qty date 140880 25 6/20/2015 50 6/30/2015 140890 25 6/25/2015 7/15/2015 140891 30 7/20/2015 100 10/15/2015 </tbody> i have a report ran everyday for shipment dates i want to know if it is possible to pull in multiple dates...
  19. K

    [MOS] Microsoft Office Specialts Exam 77-420: Excel 2013 Help!!

    Hi everyone, Today i gave my MOS Exam 77-420 : Excel 2013. i scored 980/1000. overall the exam was easy. i got 100% in all objectives except 90% in 'Applying Formulas & Functions'. I know where i did wrong. But i still can't figure out how to solve that problem because of which i couldn't score...
  20. M

    Help!!!! Special sorting

    Hi, I am in desperate need. I have a file which looks similar to the data below: <tbody> A B C D E 20140930 3344 XYZ 141 AAB7 20140430 3344 XYZ 141 AAB7 20140930 3344 XYZ 2196 AAB7 20140430 3344 XYZ 2196 AAB7 20140930 3344 XYZ 21345 T2FG 20140430 3344 XYZ 21345 N8J5 20140930...

Some videos you may like

This Week's Hot Topics

Top