urgent excel help

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

    I need to make buttons to edit my formulas.

    Can somebody please help me with a formula for buttons? I need that when I press a button the formula changes or adds a spacific number. for example if formula is "=60*D45+O43" I need to make buttons to make the number 60 to change to another number that i specified for that button. and if i...
  3. S

    How to use a variable in another sheet/workbook

    Hello everybody, I have been working on a task where I have to copy some data from cell A1 and A2 in sheet2 of a workbook to a macro that uses it later. I have declared some variable and the values present in sheet2, cell A1 & A2 is assigned to them. But it gives me "Runtime error 9 : Script...
  4. P

    Excel FORMULA. Urgent Help for my work.

    At work we use this spread sheet. Part of my job is to fill out this spread sheet whenever i issue the material for a job. Now if you look under the 1.75x4 colored in the blue there will be an arrow and it will say "arrow #1" what it is doing is adding it up,for how much material we have used...
  5. S

    VBA - Grab Unique Values and Paste them x number of times

    Hi Everyone . . . Not really an Excel VBA expert, so I thought I would come try my luck here. Essentially, what I am trying to accomplish is this: I have two columns of data that I would like to generate, a date range and an hour range. I have the following range of data in Sheet 1 Column B...
  6. T

    macro truncating cell on all worksheet.

    hi, i wanted to write a macro that would truncate the cell B1 to 10 character from the right. Then rename the sheet with the right bit of the cell. And finally delete both cells. And repeat this process with all sheet in the workbook (they all contain a section number and section description in...
  7. S

    Trimmean, averageifs, and countifs

    Hey Everyone . . . I have the following AVERAGEIFS formula in my workbook: =IFERROR(AVERAGEIFS(Data!$A:$A,Data!$J:$J,"="&CONCATENATE(TRIM($B$3)," - ",TRIM(Orders!$C3)),Data!$K:$K,">="&Orders!$H$1,Data!$K:$K,"<="&Orders!$I$1),0) The purpose is to average a number set if a string matches and the...
  8. L

    Selecting adjacent data based on conditions

    Hi All, I am trying to convert a table that looks like this: Time; Event 1; Event 2 12:00; 0; 0 13:00 ; 0; 0 14:00 ; 10; 0 15:00 ; 4; 0 16:00 ; 5; 4 17:00 ; 3; 5 18:00 ; 5; 0 19:00 ; 0; 0 20:00 ; 0; 0 21:00; 0; 0 22:00 ; 0; 0 23:00 ; 1...
  9. P

    Not able to find a existing sheet in excel file?

    I have a defined function in an excel file. When i paste the funtion in any cell it returns a value. I tried finding out where/how is it fetching the value through formula auditing, where i saw it's pulling the value from a sheet named Data2, cell g23, though this sheet is not showing in the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top