Hi,
I am looking for a macro which will go through columns and collect information for each row into a sentence.
For example:
column 1 column 2 column 3
James Jones Male
I will p...
I need to copy and paste a formula down a column. The length of the column is defined by the data in the column to the left (column c). However, the length of this data column will vary. Thus...
Would it be possible to use the data validation (in cell C39), allow=custom, and the formula function that adds C39+B39 and places the result in B39. And the input message would pop up.
Thanks
I have a user who is accessing an excel file located on a network share. When she opens the file with Excel 2007 (version in which the file is saved) it initially looks as though the content i...
I have the range from C3 to C3.end(xlDown) selected, and I want to deselect every fifth cell starting with C3. In other words, C3 ... C8 ... C13 ..., etc. are deselected. Or maybe it's done ...
Hi friends,
I am muthukumaran i need a help from any one. Now i am doing one project. that project has two columns one is Category and another one is Sub Category. I need a macro that pull ...
I have a module that creates a new workbook and sets a public string variable (saveFileName) with the name of the new workbook.
Then I have a sub that is supposed to copy a sheet from an open...
Hi,
Excel macro to give sepeartion to specific colums data and get the results to colum "S"
"SID: R05109
CG: P4-2.4GHZ/2* 1 GB/40 + 80 GB/FDD/GIGA"
The final results has to be as t...
Experts,
Please check enclosed file..!! I made some adjustments on the pre-made macro, but it does not work as I want, I add values from 1 to 6 on Column H, I want macro to make the calculati...
Please take a look at this worksheet. For some reason the cell values don't change when you change the values in their source cells.
http://www.discretedata.com/Ex-Ex/Excel/FormulasNotUpdat...
Hi Experts,
I have been trying to create a Golf handicap score card which will automatically reduce a players handicap by 1 if they score '4' but i cant get it to work.
Name Original Ha...
I'm trying to do the following:
- When user selects a cell on a worksheet and clicks a button on the worksheet, to write some text to the selected cell. E.g. user selects cell B4 and click ...
I have a excel sheet with a lot of rows. A lot of the rows have the same id. This is not a normal id but a company id. The headquarters of each company contains some data about each branch the...
I have two tables that have nearly the same info in them I would like to compare the tables to find what is in tableA field1 but not in tableB field1. I don't need to go the other way though....
I am working with office 2007. I have a powerpoint slide that I want to create a hyperlink for that links into a specific cell on an excel worksheet. I know that if I define a name for the cel...
I have not programmed in Excel but would like to add a verification button at the end of the worksheet.
Upon clicking the verification button, it would search cells F18 to K18 and verify that...
How do I create a query in MS Query that uses exists worksheet in different workbooks?
K
I am trying to send an excel document as an attachment using the File - Send to - command. I see "Send to - Mail recipient, for Review", but not "Send to - Mail recipient, as attachment". How ...
I want to show two precentages in one cell. The is more than enough room, as the colomns are prttey wide.
I have these formulas:
=SUM($B$134:$B$135)/SUM($B$102:$B$108)
=SUM($B$136:$B$140...
I have a VBA add-in that reloads data from a database and formats and displays it in a worksheet.
The add-in may display a chart of the data and when I refresh the worksheet from the dat...
Hi Experts
Does any one know how to remove the ........dashed red line in MS Projects as shown in the screen print??
I know its MSP question posted on a excel forum so apologies.
Greetings all:
We have a series of users that have an Excel document of scheduled activity types that we created from an Advanced Find in Microsoft CRM 3.0. The report inside the Excel doc...
I do a lot of macros and end up copying and pasting them from others.... Is there a site to learn how to use macros effectively that is FREE?
Is it possible someone can help me alter this code so that when command button 2 is pressed it prompts you to input the password into a text box. If the password is wrong the workbook stays lo...
How do I return the focust to the Outlook screen after running code in VBA in excel?
