excel 07

  1. M

    Button Click: Generate Outlook Email, Include Data from Two Separate Columns (Almost Done)

    Hello, I have a work sheet (Excel 2007) with a few buttons that generate emails based on certain cell values. When clicked they sort by a specific date in a column then by customer name. It uses the customer name to grab email address from a separate sheet "Mailinfo" and then it generates an...
  2. N

    My Excel 2007 Files seriously corrupted

    Dear Experts, All my excel files have been corrupted and I'm unable to open any of them. I tried couple of free download for excel file recovery in google but non of them helped me. I see message from Microsoft Excel: Your file is severey damaged unable to recover is the message I am...
  3. J

    Macro is Slow!!!

    Hey guys, Im relatively new to VBA coding and was wondering if there was a quicker way to make the below coding run faster?? WithActiveSheet.Range("B:B") .Value = .Value .SpecialCells(xlCellTypeBlanks).EntireRow.Delete End With...
  4. E

    Find and Replace call for help!

    Hey; I'm a self proclaimed simpleton when it comes to excel. I've been scouring the internet, but I've been unable to find QUITE what I'm looking for. I'm looking for a formula or VB script that searches all the cells in Column A on Sheet 1 for all the values in Column A on Sheet 2, and when...
  5. Z

    Replace, delimit macro for x,y coorinates

    Replace, delimit macro for x,y coorinates Hi I am trying to create a macro that will allow me to replace ( , ) on several x,y coordinates and convert them into separate columns at once. For example my villages opponents as you can see I have a list of villages that i want to insert into...
  6. R

    allowances calculation

    Dear Friends, pls help me with this problem in excel, this is my homework question. (to be solved in excel) The question is to calculate the Travel allowance based on the conditions given below, 40% of the basic salary whose basic salary is up to $8000, subject to a minimum of $3000 or 25% of...
  7. S

    Excel to word conversion

    Hello! Can any1 provide me a code to open a new word document and copy and paste the contents in a excel worksheet to it.
  8. J

    Macro code help

    Hi, can you pl help me with a macro code for the below task in excel 2007.I am new to macros. 1.In Sheet1 I have 100's of Rectangular shapes each containing one text box containing Text(Single sentence with many words).each Rectangular shape is one below the other in order and each...
  9. F

    Excel Charts pasted into Outlook/Exchange Email

    I've written my VBA code similar to the post found here "http://www.mrexcel.com/forum/excel-questions/562877-paste-chart-into-email-body.html." However my issue is that when running the macro it's not giving me the latest chart on the active workbook. Any ideas?
  10. J

    Macro: Post Columns from tabs and summarize it

    Hello everyone, I'm new to this site and I hope I get to learn VB more. I am developing a template for employee assessments. I've got the macro running to create blank assessment forms with column AI containing the employee's grade. There is no specific number of employees - as new employees get...
  11. S

    Add in hyperlinks via VBA to call other modules?

    Hi Mr. Excel Forum, I am designing a custom ribbon that will be distributed across different people's computers. One of the functions I have included in this ribbon is the ability to download a table of sorts where it lists the total issues outstanding. While this table only lists out the...
  12. U

    macro to look for a value from sheet 1 into sheet 2 and bring entire row

    i have two sheets "1" and "2" there is a list in sheet "1" in coloumn C, i want to search all the number that are in sheet 1 coloumn C into sheet 2 couloumn c, if it matches then bring the information from entire row of that sheet 2 to sheet 1.
  13. E

    Help in Counting rows

    Hello All, I am using Excel 97, Windows XP. I need help in counting. Sample of my data is given below: Column 1 Column 2 Column 3 Column 4 Column 5 Company Name Date Director Name Director Designation No. of Directors 20 Microns Ltd. 3/31/2002 Chandresh Parikh Chairperson & Managing...
  14. Z

    Count multiple citeria in a date range

    Hi, i am trying to populate a table using a raw data to count using multiple criteria in a data range. Please refer to the attached file. Based on the team and task, i would like to count following a criteria to dertermine the number of occurrence based on the dates given. Also needed to search...
  15. U

    get the folder name from ID in the coloumn

    i have a coloumn "ID" which contains ID . in the next coloumn i want to get the name of the folder which contains a word file with same name as ID. So for example, i have the ID 1234ABC i want Excel to search my computer for a Word file called 1234ABC.DOC(x) and return the folder that that file...
  16. D

    Proprietary Info and Caching of External Data

    I've read over these threads for quite a few years now and have almost always found any answers I needed, or at least got pointed in the right direction. Unfortunately, I need to ask for your expertise. I am using Excel 2007. I put together an Estimate sheet that pulls date from a Master sheet...
  17. R

    How to send email from excel using VBA with Cell Range (Including Images) as Email Body

    I want to send email from excel using VBA with Cell Range (Including Images) as Email Body, I have below code to send email as HTML body every this is coming to email body (formats & fonts) but Images are not displayed in email body. getting error "The image cannot be displayed. Your computer...
  18. F

    Please recommend rank automatically formula

    <colgroup><col><col span="5"><col><col span="75"></colgroup><tbody> DRAW BALL BALL BALL BALL BALL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69...
  19. F

    I'm looking to make a histogram,,,

    For helping me , I do not have much practice with excel yet, I'm looking to make a histogram with the following information: input data (column sum), and bin (column with range value) <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> SUM BIN 272...
  20. F

    Histogram problem,,,

    I need help. the number 9 with frequency 0 is false . The "number more" 18, I don't understand? What means this? <tbody style="border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased;"> Number Frequency 1 13 2 13 3 12 4 10 5 12 6 11 7 22...

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