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

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top