excel 07

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

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

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

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

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

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

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.

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

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?

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

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

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.

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

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

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

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

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

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

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

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