xyz

  1. M

    Getting specific text or tumber from cell

    Hi Guys, I've got a lot of cells with useless text and a combination of text + numbers in it that I need and by now I am out of ideas... Sometimes it looks like this: Useless-Text_CD_local random, name (randomname) 2019-10-17T08:20:15 XYZ-COUNTRY-000737 Or like this: Useless-Text_CD_local...
  2. B

    Look-up Formula Logic Update

    Hello, I have the following look-up formula: =IFERROR((VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0)),"N/A") I would like to add a condition to this formula that says: IF Column BD = Hello, then return a value of "MK" regardless of the look-up value. Essentially, this logic should override the value...
  3. R

    Dynamic Table in Mail Merge with different page for key attribute

    I have to prepare letter for students of different colleges. For each college, there should be one letter with name of all the students & their details in tabular format. The students data is in excel is as below: <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  4. M

    Splitting Data into Months based on Date Range

    I have been doing some research but was unable to find exactly what I am trying to achieve. I have been working with VBA frequently but am not quite advanced enough yet to do do this, so I would really appreciate some help! I have a list of customer bookings, with various information and a date...
  5. D

    Power Query - Filter Table Based on Distinct Conditions from List

    https://www.youtube.com/watch?v=fRd6wYkfDUQ In this video, Mike uses a list to extract rows from the Start table that DO NOT include anything from the list. Is the opposite possible? If it's in the list, then extract rows from the Start table that contain it. E.g. Suppose the list only has...
  6. C

    Subtract Cumulative Total until it reach zero with FIFO excel creation

    Hi, i'm trying to create some subtract formula, but no idea how should i do it, the table below would show the result i desire: <tbody> A B C D E F 1 DATE STOCK ITEMS NAME COST PER STOCK (IN USD) QUANTITY OF STOCKS CUMULATIVE/ BALANCE OF STOCKS REMARK 2 1/1/2019 XYZ USD 1 1000 1000 BUY...
  7. E

    VBA Recognize Cell Value

    Hi all, Is there a VBA macro that looks to see if a cell has a value? For example: "If Cell(123) has a value then xyz end if" Thanks in advance for the help.
  8. C

    Build Array Macro for copying cells and pasting basis criteria

    Hi Excel Guru's..need a vba to resolve this. Below table is my Onedrive source Data Set residing in Sheet1 (Table 1 ) <tbody> ID ST NAME Asset Qty UOM Asset2 Qty2 UOM2 Asset3 Qty3 UOM3 Asset4 Qty4 UOM4 Asset5 Qty5 UOM5 Req type Justy Enclose 1 16-07-19 xyz top 5 100 rock 8 80 soft 10 110...
  9. P

    Help with the basic formula

    Hi everyone <tbody> Product wholeseller price/kg Apple ABC Rs 50 Orange ABC Rs 30 Apple XYZ Rs 40 </tbody> Using Product as the key i want to extract all the datas in new table like <tbody> Product ABC(Price) XYZ(Price) Apple Rs 50 40 Orange Rs 30 </tbody> I used formula to get...
  10. K

    Find out differential value of two sheets based on criteria match

    Sheet 1 <tbody> ABC 40 DEF 25 GHI 35 XYZ 20 </tbody> Sheet 2 <tbody> ABC 45 DEF 20 GHI 10 PQR 18 XYZ 40 </tbody> I want changes in value in 3rd sheet based on name criteria match of both sheet and additional name and value of sheet 2. Could you please solve my issue.
  11. C

    Help with Web Scraping VBA

    Looking for some help. I'm using this code right now to scrape the innertext of all <li>s on a webpage where the class name is "error' (e.g. <li class="error">, within a DIV tag. However it doesn't work when there is no DIV tag on a page. Can anyone help me to do the same thing, but without...
  12. V

    Create multiple workbooks

    Hi Team, i have data from col A to L. in my col B i have names abc abc abc xyz xyz xyz xyz xyz and in col A i have 3 different names for "abc" and 5 different names for "xyz", and go on till last record of col B. so i wanted to create workbook "abc" and it should contain their data in that...
  13. J

    VBA - filling in blanks in Table column

    Hi all, I have a 6 column running Table (called "CS" - see table below). Each month my macro takes current data from a separate 5 column table and pastes it to the bottom of the CS table. After this procedure, there is always the expected blank 1st column in the CS (which is the "File...
  14. E

    UserForm to enter Orders

    Would like to reach out to this community to ask for help. I have been creating some user forms in Excel but I am stuck when it come to creating user form to enter customer orders. Any recommendation would be greatly appreciated. User Form would generate a SO auto number 1234, however would...
  15. L

    running same macro again to create a new sheet

    Hi I opened a new file. has sheet1. I clicked on recording Macro. I clicked on + to add a new sheet. Then changed sheet name to XYZ. Then stopped the macro. So far so good, Now sheet XYZ is the active one. I now tried to run the same macro but this time, Sheet3 will be created but then I got...
  16. A

    Hiding OLEObjects based on data validation on a different worksheet

    Hi I have run into a roadblock that I just can't figure out, I would really appreciate any help I can get. On sheet 2 in B2 there is a data validation drop down list that has 6 different options. What I need to happen is that on sheets 6, 8, and 9 for an embedded word doc "Object 1" to be...
  17. J

    Extract serial number from a string and insert info

    In my problem workbook, there are a few things I have to work with but cannot change. The user clicks a button labeled "Enter Job Number" which starts the ball rolling and populates a number of cells in hidden columns A thru E. Once that's done, the user then comes to a button that reads "Click...
  18. A

    Auto Hyperlink

    I have a workbook name "TCS" I want a vb code which apply on sheet1 It has range A2:A50 and have names in each cell same name files are available on this sub folder; Thisworkbook.path/Backup For example, File name ABC on cell A1 should be hyperlink with file "ABC.xls" in folder Cell A2 named...
  19. M

    Finding Latest Supervisor

    Hi All, I have a quick question regarding PowerPivot calculate column. I have below tables 1) Transactions <tbody> EMP ID EMP Name Sale Amount Sale Date Supervisor Name 1 xyz $1000 12/12/18 Sup 1 1 xyz $100 12/15/18 Sup2 </tbody> 2) HeadCount Table <tbody> EMP ID EMP NAme SUp Name...
  20. T

    SUMIF in Power BI

    How to use =SUMIFS for below table in power bi. =SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID) <tbody style="box-sizing: inherit;"> Prior Months Region Sale Region UI PID Europe Europe ABC ABC 12 Europe Europe XYZ XYZ 12 Europe Europe OPQ OPQ 2.5 Americas...

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
Back
Top