formula & macro

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. F

    COPYING DATA FROM EXTERNAL ARCHIVE

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

    HOW TO MAKE INCREMENTAL FORMULA

    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...
  14. 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...
  15. 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...
  16. 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...
  17. S

    Count the duplicate values in excel, but only the duplicates and the amount of duplicates values

    Hi, I'm having a lot of trouble trying to get some values in some documents I have What I need to do is, get the amount of duplicate values that are in a column, for example In this table I need to do this calculation All the repeated values in the Column "L" are basically a single Item, but...
  18. C

    Use The VBA To: Automatically copy and paste values in excel, to create historical table

    Excel Fans I have a situation Every day I received data from excel web into spreadsheet #1, columns "A2" & "B2" see example Date Value Tue-17-2019 4567.89 Now. I want excel to automatically copy both cells reference and create; "Date & Price" History on spreadsheet # 2. See example...
  19. M

    VBA Not Interpreting Single Quotes Correctly

    Hello, As part of a larger macro, I'm trying to input a formula into a range of cells. This formula does an indirect lookup of a worksheet name as a tab name, and therefore requires single quotes. However, VBA keeps trying to interpret the first single quote as a comment, and therefore...
  20. M

    Organizing tasks and schedules with forulas

    Hello everyone, I am trying to make a spreadsheet that includes a calendar for task scheduling and the project details in another tab. Columns B and C in the calendar look something like this: <tbody> B C proj.1 task 1 (blank) task 2 (blank) task 3 proj 2 task 1...

Watch MrExcel Video

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