attached

I am currently looking for a formula that i can sum up the all the numbers under one persons name. So if John name on he work sheet 5 times need to calculate all the numbers that john has. I have attached a sheet to make it more understandable a bit...

Hello guys, I need my macro to open the Attachment Files button inside a Purchase Requisition and tell me the file name attached. I was able just to get the "PDF" text, but not the name itself. https://imgur.com/d2WF0Q0 This is the line code I used to get the "PDF" text, the rest of the...

I'm having an issue and I think part of it is I'm probably overthinking the issue. I have an output report that provides me with some folder sizes. It came out in megabytes. As I'm presenting this to upper management, I need it in a format they understand; gigabytes. How can I take column "C"...

Hi, I am trying to create a spreadsheet that tracks stocks. When using the excel stocks function and outputting data, the market cap for all 500 stocks is coming up as ####### and I am also getting a #FIELD ! error for certain P/E or EPS data. I've attached a screenshot with issues highlighted...

Hi please someone help me to make a sales report as per the attached sheet as in the Sheet2 . If someone help me I will be very thankful. https://www.dropbox.com/s/6lcxtojqs8s977x/Dummy.xlsx?dl=0

Hey my friends, In cel A1, there is date and time together. I need a formula to split them into following columns as it is shown in attached file. Pls check the link: https://jumpshare.com/v/sSGwGXDJPfVWcl4UwBcf (Click "Download" button in up-right part of the page) Waiting for your help. Thank you.

I'm trying to prevent myself from accidentally sending a file to someone outside of my organization's domain. (We've all hit the "reply all" button and sent something to someone we didn't know was in the email chain, right?) I've got some code I found online, but it doesn't make a...

I have macro to email sheet3 the macro works perfectly except it shows the name of the workbook followed by today date of the attached workbook I need this amended so that only sheet3followed by todays date is shown in the attached workbook Kindly amend this section of my code...

I need to update this table of sorts every week, i have made 3 iterations for the same in the sheet attached. But in the main sheet i only have one table within which all modifications would be done. The process usualyy takes a few minutes is there any way to spped it up using either macros or...

I have a sku that i want to look up in a range and i want the find the amount of a certain supplier attached to that sku in the range, Does anyone know how to do this

Hi, First time using this. What am I doing wrong that brings about the errors in attached image? https://www.dropbox.com/s/mo6gk6kigrts0me/asas.png?dl=0 Thks,

Hello. Is there any way to exclude the cell from the range? Here is the deal, this is how my sheet looks now (grey cells doesn't contain a formula) I2:I11 - people that need to be connected to the task (there are 6 tasks - M3:M8 ; H15:H20) J2 - there is RAND() formula N3:N8 there is...

I need some help with a formula (see tables below). What I need is for the Reference ID in the first table to lookup the Reference ID in the second table, and if the date range for that Reference ID in the first table falls inside one the date ranges within the second table, the price needs to...

Hi all, Hope you can help me with this one. I am looking for a formula which will give me the date a product was last sold. In our BI system we have quantity sold and the date but nothing like last sold on. I have attached a file and am looking for a formula which will retrieve the info in G2...

Hello all, I have attached a file which demonstrates this. In my real document, I have about 3,000 rows. The formula in P is: =COUNTIF(A2:L2,"*"&"tour:"&"*")>0 This works 100% of the time. The formula in Q is: =IFERROR(CELL("address",INDEX(A2:L2,MATCH("*"&"tour:"&"*",A2:L2,0))),"")...

Hi all I have an Excel file as attached which show months in which we have order from customers. Could you please help me the formula to show the month in which the customer first bought our product? I have attached both the Excel file and an example picture. Thank File...

I need to compile a formula that adds a parameter so that if column G/470 has the word "PLUG" it will multiply E470*O470 along with the current functions. Is this possible? I keep striking out and wasting my time. I've attached a link to my screenshot and I've inserted my formula below...

Can you deal with the comments in the attached? https://www.dropbox.com/s/uwuf9nht3snfva1/example%20-%20Copy%20%283%29.xlsx?dl=0

Hi all, Wondering how to solve a repeating list of values in a combobox. After a number of blank cells the list repeats itself, these values when selected have no text attached to them. How can i make sure the list doesn't repeat itself?

A Screenshot of the worksheet is attached below. Help needed please as I'm new to using codes in VBA. https://1drv.ms/u/s!AuJosJM5re-thDoADN_0odaoTIQH