formula & macro

  1. E

    Excel VBA/Formula to perform operation in a cell based on cell Colour

    Hello there, Here, we have a Red and White Coloured cells in "Remarks" Column. The white coloured cells are fine and need not to be worried about. As shown, there is a continued red coloured cells upto S.N 5 Row starting from S.N No 2 Row. So, I want to copy its corresponding "Ending" Column...
  2. P

    Date Value to Code ID

    Sir, I'm looking for a formula that generates the Date ID from Date value like below in mini sheet, I found a pattern using CountIF on A1&B1 that is 1/1/1900, I don't know how to use this pattern for 05.09.21(todays date) to get a Date like in the below cells. Thanks in advance Date ID...
  3. D

    VBA for payroll data entry and analysis

    I am trying to create a macro for a small business to help with their payroll. It would be simply the user typing in the name and the hours worked. The other cells would have formulas to help calculate the net pay. The table below shows an example of what I am doing right now. On one tab, I have...
  4. S

    Scan multiple cols and row, and arrange in 2 columns

    I am struggling to get the expected output as below. Input data: Output data: In the output data - Column 2 is unique concatication of Column 2,3, and 4
  5. A

    PLEASE HELP!!! Can Not Get Formulas To Work??

    I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it. JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to...
  6. S

    Need to Transpose these 1 to 6 columns into one single Column (multiple rows),Keeping the left 2 columns intact. Please help!

    Company Name Count of Names 1 2 3 4 5 6 Deco-Mica Ltd 4 Deco Mica Ltd Deco-Mica Ltd Deco Mica Deco-Mica Bharat Textiles & Proofing Industries Ltd. 4 Bharat Textiles & Proofing Industries Ltd Bharat Textiles & Proofing Bharat Textiles & Bharat Textiles Sainik Finance & Industries...
  7. P

    Combining repeated rows from 2 sheets' data based on a key

    I am having 2 sheets in excel and I am trying to combine the data such that for every record in Sheet1, I get records from Sheet2 based on the common key. Below is the sample data to clarify: I have SHEET 1 and SHEET 2 Data and I want to generate something like SHEET 3. Can you please suggest...
  8. L

    VBA: Add formula to a cell's string using VBA

    HI I am exporting a 6 digit number from a system into Excel. When this is pasted into excel, this is reformatted as a number instead of being left as a text value. Column A with the code shows what the reformatted number looks like. Column B shows what I want it to look like. AB1CodeOutput...
  9. K

    Find Synonyms for a word in MS Excel using VBA

    Dear VBA experts, i have set of words in column A, i need a excel VBA macro to get the meaning for each word in column A on corresponding B column. Please help me with a code. Thanks in advance ! Regards, Karthikha.
  10. W

    VBA CODE to vlookup and get multiple results

    I have a requirement where there are set of values in A column of sheet1. These values in column A are mapped to multiple values in sheet2 of A and B column. I need a VBA code where it gives me the unquiet list of mapped items in horizontal manner. So the result must reflect in B2, B3, B4 etc...
  11. E

    How to copy (with a macro) formulas from a row down based on if values exist an that row on another tab.

    Hello again. I need to copy a row of formulas from a specific row (Row 16) down but only if there is data in a specific filed on another tab. To explain a little bit better. Some people fill in data on a specific tab (Tab 2) Other people fill in data on tab 4 My formulas concatinate and/or...
  12. J

    Combined (Possible Nested) Formula

    Hello Fantastic Excel SuperUsers: I always like start off with saying thanks for all the help in the past! I have two formulas I would like to combine. =IFERROR(IF(SEARCH("specific text",cell value,1),other cell value I want to copy,cell value) and a INDEX MATCH formula. Caveat would be...
  13. R

    Need Help On Formula

    Hi Friends, I need the formula to get a specific value from a cell. I tried SEARCH, MID, LEFT, RIGHT but none of the formulae is working for me. In Cell A1, I have a paragraph and likewise in cell A2 and A3. In cell B1, B2, B3 I need to apply a formula to pick the 7 digit value which starts...
  14. F

    problem with VBA that checks a true false value in a cell from another xlsm file

    Hi All I have two files : A and B. I am writing a VBA in file A that generates some value and writes that in a cell in file B. in file B macro, there is a Function F and there is a cell in which a formula written that used this function F that generates a True or False value based on the...
  15. P

    VBA code to reset drop down list

    Hello. I am in need of some help here. I have 2 drop down lists on my spreadsheet. what I need is so when I select an entry in drop down list #1 for the other drop down list #2 to clear. Vice Versa I also need the same code to clear drop down list #1 when drop down list #2 options is...
  16. F


    Hi, I have a table were I need to paste numbers from external archives, not from my workbook, the thing that I have these columns: # -B UPC - C Cant. -D Descripción - E Cod. SAP -F Cantidad -G...
  17. K


    I have a list on the first sheet with details, I have the second sheet with some blank spaces which are to be filled by the details on the first row of the first sheet by use of simple equals equations. How can I make it so that I can generate another sheet which will automatically get...
  18. M

    Copy the worksheet from Workbook into another workbook and perform forumla with existing sheet

    1. In a folder (Folder path C:\david\Desktop\New folder) , I have file name called " Data" and sheet name "Data info" and another file name called "System" and sheet name "system info" 2. I need to perform formula with Data workbook and system workbook. Formula need to apply in System workbook...
  19. B

    Extracting Data between XML tags

    Hi, I am currently seeking a solution to extract certain information from XML between tags, name, address, gender etc. Basically I need to be able to make information presentable in a table form. I have used the below formula which works to extract the problem is if i create a template to...
  20. M

    VBA copy formula from one cell to the next one

    Hello, This is my Currently Excel Sheet Cell DP3 contains a Formula that is "CONCATENATE" from another sheet with name "CODICI". What I would like to do is 1) Copy the formula from the cell DP3 and paste it in cell DQ3 with the numbers + 1. 2) So i the cell DQ3 I would have the following...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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