ms excel 2010

For each Match in the workbook,I wish to add the value in the B cell of worksheet1 and the value in the C cell of worksheet2 and display the result if less than 100. This same process is repeated for worksheet1 and worksheet3 and on until worksheet10. The iteration now starts from worksheet2 and...

I was wondering if someone has a formula for MS Excel (not in VBA since I'm not good at it) to be able to help with the following: I'm trying to compare the "text contents" from the cells in column B to the "text contents" from the cells in column A, and place in column C the difference of WHAT...

I am using MS Excel 2010 and my comment fields got corrupted. Any solution to solve this problem?

I would like to know if it's possible to combine a nested SUBSTITUTE and CONCATENATE formula or similar to add/insert a Character within text string I have a column containing keywords (Cell: A2:A3) that I would like to place a unique character ("$") within the text string in front of each of...

Friends, I want that when i type in excel sheet it should merge the cells automatically. For example as I start typing from cell no A1 and continue typing to cell no E1 then the range from A1 to E1 should automatically be merged. Moreover I want to assign tooltip to the new customized buttons...

I have merged two ranges in excel sheet, but it is leaving one line between the merged area of the both ranges. I wish to remove this line but could not succeed. I have adopted many ways but everything failed. I am attaching the image of excel sheet showing which line I want to remove. Please...

Hi all, I'm new to using VBA in Excel, and I'm having a tough time getting my event handlers to work properly. I have data validation set up in a specific column. The user must choose from a specific list of part #s, which is listed above the cells with the data validation (current worksheet...

I have a file with 147693 lines. I need to remove 6 pairs of CR and LF at the end of the first 6 lines, then skip one (which is a legitimate CR, LF) then continue to the following 6 pairs. Any help ho to do that? I understand I will have to write a macro to do this, but have no idea hoe to...

Hi All, I want to display the worksheet name of every worksheet from each workbook in A cell at the time of merging all the workbook into one. please help as i am unable to do so. To display the worksheet name, i am using below mentioned macro:- Sub SheetNames() Columns(1).Insert For i = 1...

I have an Excel UserForm that I use to enter data from my job. I commission solar inverter stations. Each row in my spread sheet contains data for a different station. On my UserForm I have a CommandButton, that when press takes the data from the current row being displayed in the UserForm...

Hello All, I want the following functionality in excel. If in the entire column B if any of the following string is found get the corresponding value of another cell in Column A. String to search: OK NOT OK BLOCKING NOT TESTED See the example at the following link...