excel2007

  1. D

    I need help on what formula to use!!!

    Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data and a button for encoding. Excel WorkbookABCDEF12poducts34date delivered5monthDateYear6location of delivery78delivered by910sales1112Encode13Main...
  2. D

    What formula to use???

    Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data then, a button for encoding. Excel WorkbookABCDEF1******2*poducts**3******4*date delivered****5**monthDateYear*6*location of...
  3. D

    How to do this, what formula??? or what VBA Codes???

    I am using Excel2007, i'm doing database as my project and i am having a problem on how to do this... I have have three sheets first is the input sheet... Excel WorkbookABCDEF1******2*poducts**3******4*date delivered****5**monthDateYear*6*location of delivery**7******8*delivered...
  4. D

    Serching by Keyword using VBA Code, I need help...

    Hi I am using excel 2007 and I am trying to put code inside a button that if i push the button and can search by its keyword from the list. The code I'm generating is this when i record macros ActiveSheet.Range("$D$1:$D$6").AutoFilter Field:=1, Criteria1:="=*Wayde*", _ Operator:=xlAnd...
  5. D

    Date Manipulation, I need Help...

    Hi, I'm using Excel 2007 and having problem with date, plese help me... I have 3 rows for the Month, Date, Year respectively and i want it to be converted in a single cell so that i can manipulate and compared it with the today date and add days, week or month on the next cell. For example...
  6. D

    Need help in keyword searching

    I'm using Excel2007 and I'm doing a database, i have a lots of concerns and questions, let me start with this. I have two sheets, the first sheet is the search sheet, then the second is the masterlist. I want to have a search button than can actually search for its key word and filtering the...
  7. D

    Can anyone help me how to search the data in column by its keyword???

    I'm using Excel2007 and I'm doing a database, i have a lots of concerns and questions, let me start with this. I have two sheets, the first sheet is the search sheet, then the second is the masterlist. I want to have a search button than can actually search for its key word and filtering the...
  8. P

    Excel 2007 vba filter problem

    I am a newbie to posting queries on this forum but please accept my thanks for many past postings to MrExcel which have enabled me to deal with VBA issues. I have developed an Excel membership database model for a charity. VBA is used to produce various reports. Many of the reports require a...
  9. G

    [XL07] Pivot Table - Divide one field with the count of another one

    Hello all, First of all a big thank you for all the help this board has given me as a lurker :-) Now I've small issue and I thought I could finally register and ask for help directly. I searched for an answer already but I couldn't find anything, probably 'cause the terms I searched for are too...
  10. Snakehips

    Excel2007 displays strange rows above standard column headings

    I have a large, (78 sheets and a high level of vba automation), well established Excel2003 spreadsheet that iI am now trying to run in Excel2007. I have a problem with one sheet where there are 8 additional rows displayed below the ribbon but above the standard column headings! Three of these...
  11. N

    find unique text and sum value

    I have problem with one function..i dont know how to do it and whether that is possible to do with formulas or macro. I have column Name, where can be one name many times, next column state, subject which are useless this time and columns points and totals I want to make function that do this...
  12. S

    Excel 2007 Change Pivot Table (Select Multiple) with Macro

    I need to select 2 items (months that are chosen by a user) in a pivot table. I can either put the Months as PageItems (Select Multiple) or FieldItems, either way I will get the results I need (when selected manually). When choosing one item, no problem. I use the code...
  13. S

    Need Substitute for Conditional Formatting

    I am using excel 2007. I have a formula in cell J12 that produces a number from a list depending on what the value is in C8. But, I need that number to be negative (formatted red with parentheses) if cell J11=0 and L11<0. I know I can do the RED part through conditional formatting, but how do...
  14. S

    Combobox w/ Predictive Text?

    I'm using excel 2007. I need to insert a text box on a worksheet that will allow me to type in comments for the client to read when we send out a report. A simple text box I can do. What I would like is to have a text box that "remembers" previous entries so I don't have to type out the whole...
  15. S

    Formula Error

    I am using excel 2007: I have created the following formula (with some help from this forum), but I am getting an error message saying I am missing a left or right parentheses. Can someone help me? I can't figure it out. =IF(ISBLANK(B17),"",IF(AND($I$8="AIRBORNE...
  16. S

    Need AND OR Formula Help

    I need help writing a formula for this scenario for Excel 2007: <link rel="File-List" href="file:///C:%5CUsers%5CSam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData"...
  17. A

    Link problems excel 2007 to excel 2003

    Hi, I have two excel workbooks, one created in excel 2003 and the other using excel 2007. When i link a cell from the excel 2007 workbook to a cell in excel 2003 workbook (that has some text in it), it shows a "#N/A" message. However if i then open the excel 2003 workbook using excel 2007...
  18. B

    EXCEL 2007 Macro hyperlink issues

    How can I create a button hyper linked macro that will apply conditional formatting? The cells are positioned vertically in the same column, but not consecutive.

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