usd

I have a multidimensional array with 'x' rows and 3 columns of data, and I'd like to perform a VLOOKUP on the array information stored in memory rather than calling the worksheet each time. I'm just not sure how to write the code to perform the VLOOKUP using INDEX/MATCH, and repeat that process...

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...

Hi, I am looking for a VBA code that can flag/highlight rows based on certain criterias. There are 3 distinctive part numbers in the below table, with multiple Distributor, price breaks and pricing. Each "price break" column is ranked based on the price. In this case, we keep EDAC as the...

Hello, I am trying to figure out how to create a formula that will feed into a different worksheet. I have most of it figured out but I am stuck at two parts. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> AsOfDate BankId AccountNumber AccountName BaiControl Currency...

Below is the beginning of my code, the only issue I'm having is that the below list when deleting should only delete on an exact match. So for example if I have 'carrier name' as a column header and 'carrier name 2' as a column header by the list below only carrier name column should be...

Hey All, I'm having a nightmare with this seemingly simple task. I have several cells as below <tbody> <tbody> E USD E GBP E EUR 5 O USD O USD O USD </tbody> </tbody> And another table of data below with a frozen pane, A10:Z2500. Using an example of E EUR this data is in...

Hi, I am struggling to return a result with a Dax formula. I have a Fact table that has some data Fact Table <tbody> Date Account Curr Trans Amt GBP Equiv USD Equiv 01/04/18 12345 EUR 10,000 9,000 14,000 01/05/18 12445 USD 15,000 10,000 15,000 01/10/18 12445 GBP 1,000 1,000 1,425...

Hi everyone, Hopefully a simple one for someone but I cannot get it to work! I’m trying to convert all currencies on a spreadsheet to USD Column B has the base price, Column C has either (GBP,USD,EUR). What I am wishing to do is in column D show a USD price only , so if column C says GBP or...

Hello, I am wondering if anyone may be able to assist me in creating a VBA macro. What I am looking to do with the below is sum up the "Long Total" column, but only where the "Long Curr" column shows USD. Anything else I need the long total column to be zeroed out. The last piece is I need...

<tbody> A B C D E F 1 Chocolate EUR 8 BRL/CAD 3.1430 2 Coffee bean BRL 5 EUR/CAD 0.6760 3 Apple USD 3 USD/CAD 0.7560 4 Macaroon EUR 10 5 Candy USD 2 6 Total CAD </tbody> I have two tables as shown above. I want to find the total in CAD according to their local...

Hi, thanks a lot in advance for the help I have a simple macro working for the below table: A B C D <tbody> Transport Amount Currency USD Flight to Narita 300 USD Shinkanzen 13,080 YEN </tbody> If...

I need to develop a macro that is currently beyond me. Here is the scenario. The company will sometimes book an order that will be paid in different currencies (e.g. USD, GBP, EUR, JPY, AUD, etc). We add a commission rate for each currency we're going to pay the rep on. On a line we might have...

I need to develop a macro that is currently beyond me. Here is the scenario. The company will sometimes book an order that will be paid in different currencies (e.g. USD, GBP, EUR, JPY, AUD, etc). We add a commission rate for each currency we're going to pay the rep on. On a line we might have...

Hi Everyone, i'm setting up sheet to include as much info as poss without needed to re type date from one sheet to another etc. eg if one cell has list data varification for currency EUR GBP and USD. lest say cell C3 for another column/cell (H3) i need to have formula to say if C3 is EUR or...

Dear Community, I have a daily report which is currently manually sorted. I would like to do this automated with a macro if possible. The "Row Headers" look something like this: <tbody> 302(USD) 304(EUR) 305(USD) 307(USD) 308(USD) 310(GBP) 311(USD) 342(EUR) 368(EUR) .... </tbody>...

Hi Master, Need your expertise in building a VBA to copy the data from Sheet 1 and transpose paste in Sheet 2 – As per the below format: Sheet 1 (will have a pivot in the below format) - Data needs to be copied from this sheet: <tbody> A B C D ID GBP USD Grand Total 12345...

Hi there, Need your expertise in building a VBA to copy the data from Sheet 1 and transpose paste in Sheet 2 – As per the below format: Sheet 1 (will have a pivot in the below format) - Data needs to be copied from this sheet: <tbody> A B C D ID GBP USD Grand Total 12345...

Hi Everyone, I am trying to calculate my pipeline backwards. I hope I can explain clearly here. The premise is: If I start with 100 USD in my pipeline and I have a win ratio of 20% I will win 20 USD. This 20 USD will move to the next stage (stage A) where there is already another amount...

I want to create and print files with the following logic : file 1 : keep row 1 Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart and add row 2 11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US...

Hi, I'm reading and using all the codes posted in most of the threads but I still found difficulty in running smoothly in my worksheet. May I ask for your help to formulate a code that will sum up all the duplicates in Criteria Range- column I (it will not include blank spaces) and sum range...