ms excel 2010

  1. U

    Using 'For Each' loop in Ms Excel VBA

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

    MS Excel 2010: Comparison of 2 Cells and Show Differences in 3rd Cell

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

    Corruption in Comments Filed

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

    MS Excel: Nesting SUBSTITUTE & CONCATENATE Formula within Text String

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

    How to merge cells automatically as I type and how to assign tooltip to new customized button in ms excel?

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

    How to remove the specific line from excel sheet?

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

    VBA Excel 2010 - data validation filter - event handler

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

    How to remove a CR and LF form txt file

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

    Getting the name of the worksheet into A1 cell of each workbook, at the time of merging all the excels into one.

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

    Excel Visual Basic Code to get ToggleButtons and OptionButtons to return Yes or No instead of True or False

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

    Help with a Excel formula !

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

This Week's Hot Topics

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