I need help putting in ranges for my embedded IF's in a formula
If $A7 is = to 1-7 (meaning 1,2,3,4,5,6,7) return value 0, if $A7 is = 8-22 return value of 1, IF $A7 is 23-37 return value of 2, if $A7 is 38-52 return value of 3
Thank you
Through the help of many on this site I created a worksheet that you can add an embedded PDF or other type files and this works GREAT but now for some reason I have 1 excel file with an embedded PDF that just will not open... clicking on the embedded file does nothing... there are embedded .JPG...
Hello,
This is a spreadsheet I've been using for some time now and the embedded file was working. Today I'm having trouble opening the file. When I click on the file it's selected as though I want to copy of move the file to another location.
Thanks
bell1958
I'm trying to count the cell that have a number embedded in the string:
<tbody>
11/10/2016
11/14/2016
11/17/2016
11/21/2016
11/24/2016
</tbody>
<tbody>
1zSMITH
2zSMITH
SMITH
SMITH3
x4zSMITH
</tbody>
I can count if the Number is 1st or last but am having problems when the are embedded. The...
To all Excel Gurus!
Is there a vba macro that can run from Excel that will open up the Outlook Inbox so that a specific email can be selected and be embedded into a spreadsheet as an object? ie. When a user double clicks the embedded email icon in the sheet, then that particular email opens up...
I am creating a report in PowerPoint 2010 with charts on separate slides. The chart is the same layout each time, and the data refers to a different subset of team members. (If it helps, they show forecast project hours versus actual project hours for our developers, split by our...
Hello
I've embedded a Word document into an Excel file. Everything works great, however, it looks ugly.
My main issues are:
When I click on the Word file's icon, the icon shows a bounding box around it.
The Word file's icon can currently be resized and repositioned anywhere in the Excel...
Hi
This is a bit complicated to explain but I shall try!!!
I receive a price list from a supplier, which contains PartCode,Description and price, it also includes an embedded picture shape of the product (which has generic names e.g. picture069) and a hyperlink embedded in another shape with a...
Is there a way that a formula can be automatically applied to a cell if specific data is input in another?
For example:
If "vendor" is typed in B2, (specified formula) is automatically embedded in F2.
Hello all,
I'm having an issue with an embedded IF/THEN Formula which has three different IFs. Every values in the L column will change. The different choices are:
No quotes, I'm putting them there to show the spaces before or after the value.
1. "# %not " (# being a single number)
2. ST00...
Hi... need help sooon!
I am trying to copy the text file which is embedded in my excel, and trying to paste it in a folder using the below code.
ActiveSheet.OLEObjects(1).Copy
CreateObject("Shell.Application") _
.Namespace(ActiveWorkbook.Path & "\") _
.Self.InvokeVerb "Paste"
It is working...
Hello;
I have some embedded VBA I'm using that clears the contents of a cell if another cell is changed. These columns are used for data trending, and so its basically to ensure the data is trending correctly (i.e. sub-area matches area)
Here is the code:
Option Explicit
Private Sub...
I have a spreadsheet that has multiple tabs in it. I need to be able to FIRST print the 'Comments' tab (which contains the embedded word doc that is 4 pages long), then print all active sheets that are visible. I've tried this piece of code, but I throw an error "User-Defined Type not defined"...
How can I write a formula to display data as per the below?
The 239.555 is cell C2.
The months going horizontally start from E3, going vertically they start from B5.
In E5 I am up to here with the formula (needs to be dragged across and down) so as to apply the pattern below to each row...
Morning,
I have the following algorithm:
<TBODY>
N</SPAN>
Y</SPAN>
Y</SPAN>
N</SPAN>
Y</SPAN>
Y</SPAN>
Y</SPAN>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
The part I have bolded repeats infinitely afterwards. I need to convert this into an excel formula.
Where a 'Y'...
Hi all,
What I want to achieve is this:
Display me a set value e.g. 10, every time that EITHER condition A or condition B are met, UNLESS a given cell = 0.
To give some context, this is relating to deliveries of a product. I am forecasting the costs incurred over a period of years where...
Hi,
I've embedded images into my spreadsheet as icons using the code below, and I need to then copy the images into Word - not images of the icons, but the original images. Is this possible? If so, can anyone help with how? I've tried several things, including Steve Bullen's PastePicture, but I...
Hi All , I need a vba code which can open an embedded word doc ("Doc1.docx") in my Excel Sheet1, amend the document the way I need (code that I already have), copy that amended version, paste it in the new mail of already opened Outlook, keeping the format intact and eventually close the word...
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.