attached

  1. Y

    Copy information from table to table

    Hello everyone, I will appreciate so much an answer to my comlpicated question: Which formula should I put that will enable me to copy the information from table 1 to table 2 as shown at the attached screen shot? Thanks a lot, Yaniv...
  2. F

    Copying data from one spreadsheet to another

    Please see the documents attached as it explains all that is required. I would really appreciate your help on this.
  3. B

    How to give wrap text to text box

    i have plenty of text boxes names: TEXT BOX NAME:JOG,BLA,GIO,IDEA,LOD,JOK Those are IN SHEET NAME:"ID NO" i Have attached cells to text boxes how to assign macro for this text boxes? word wrap=true locKed=true
  4. M

    How to have text flow downwards in cell?

    Hey guys, I can use some help please. If you can look at the attached image, I would like when I am typing in each cell I have expanded to have the text fit into that cell alone. As the attached screenshot shows the text is flowing outside of the cell into the next, how can I have the text flow...
  5. T

    how to get the curve maxima?!

    How can I get the value of the point that I have circled on the attached graph? i have the data, I will plot the curve, then how can I get the value?
  6. C

    Production

    In colume C & D I use the following formula to look into =INDIRECT(ADDRESS(SUMPRODUCT(($U$2:$AX$932=B5)*ROW($U$2:$AX$932)),(SUMPRODUCT(($U$2:$AX$932=B5)*COLUMN($U$2:$AX$932)))+1))...
  7. B

    How can I attach an object (file that was attached to an worksheet ) to an email?

    Hi guys I am trying to make an outlook email button that when pressed it will attach an already attached file (object) that's on a cell in the worksheet into the body of the email. Hope this makes sense to you guys thanks
  8. N

    send outlook email with attachment using excel cell reference

    Excel 2007ABCDE1ToCCSubjectMail BodyAttached File path2nikhil@gmail.comnikhil@gmail.com;sam@gmail.comTop 50 ReportHi Nik, Plz find attached ReportC:/Nikhil/Top 50/01.Top 50_APAC_2017-10-23.xls3Henry@gmail.com;Alexis@gmail.comSamuel@gmail.com;Robin@yahoo.comTop 20 ReportHi Henry, attached is the...
  9. F

    Count between Two Cells

    Dear Experts, I require to check the count interval between the 1st OFF to the Last OFF. After the Last OFF, count should not happen. Expected result attached for your reference. <colgroup><col><col><col><col><col><col><col><col><col><col><col><col...
  10. M

    Highlighting a cell on a table

    I have a table in the excel file attached. What I need is when I enter a value in A1, B1,C1,D1 etc. if the value is present in the corresponding table row, it should be highlighted. I made an example in the attached file. https://1drv.ms/x/s!AoGkZUHlKui9gRg6qf_Yom2t6eig
  11. T

    DAX Formula Error in PowerPivot

    I was trying to create a DAX formula to show only the value of a particular line, however that number repeats all the way down. See image attached below. I have a calculate formula and have defined the parameters, but that number get repeated everywhere... I only want it to appear once in the...
  12. G

    File Attached Syndrome

    Every one has done it, written the email told the recipient that the spreadsheet is attached...then doesn't attach it! I wonder if anyone has a bit of code for outlook VBA that will spot the word attached and check that something is attached when you click the send button and warn you if it...
  13. K

    Create tabs using filtered pivot

    Hello, I have a sheet with two pivots. I want to create the same sheet using different departments per tab (cell B1 and B13). Is it possible to create a code to auto create the tabs? Image of sheet attached
  14. V

    Macro(s) / Excel formula(s) to automatically extract specific elements from a string

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Good evening! I posted yesterday a message on MrExcel forum, focused on extracting some specific elements (marked in the attached document by red colour) in two other cells...
  15. H

    How Can I Simplify the attached Formula -

    Hello - How can i clean the below formula - =SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name1"))+SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name2")) Please help thanks
  16. K

    compare all distances and match with the closest item

    Hello everybody Consider I have something like attached. What I need to do is; compare distances between A1-B1, A1-B2, A1-B3... etc. and match A1 with the closest one (in this case it is B1) I have X-Y coordinates for all items here. I attached a screenshot of a sample excel file to make it...
  17. P

    Counting attached files in outlook

    The other day I posted a question on counting attached files to emails in outlook. Had a great answer and the following VBA. So the new problem is it works to good. Its counting everything in the email as an attached file. I been looking to see if others may have had a solution to filter out...

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