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...
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
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...
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))...
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
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...
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
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...
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...
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
<!--[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...
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
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...
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 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.