1. E

    How to combine two table information?

    Hi, Can someone please help me with this: I have a table with these columns: <tbody> Product Original currency Jan-16 Feb-16 ... Dec-16 Total 2016 in original currency Total 2016 in CAD A USD 3 5 8 XX (3*1.3)+(5*1.28)+...+(8*1.294) C EUR 3.4 3.2...
  2. E

    Simplifying Code Efficiently

    Hi All, i have written a code that looks quite repetitive and could probably be structured much easier with a loop / case, however i'm struggling to apply a proper form. I've highlighted the only difference in bold. Could you kindly have a look at my code below (it's an extract, the code...
  3. M

    Convert EUR to GBP VBA Script

    Hi, Im trying to create a script to change all the values on the press of a button from GBP to EUR and back if the button is presed again, can anyone help. I search online and the forum but not joy. Many thanks
  4. R

    How To Autofilter Rows Based On Cell Value In Excel?

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

    VBA : Create loop to update Multiple Textboxes based on ComboBox Selection

    Hi I am trying to update multiple textbox based on selection in a combo box The Combox section is based on an email address . This email address could appear multiple times in the data base and I need to return data in the Textboxes for each line. I have created a form and am able to update the...
  6. J

    Automatically update of secondary cell entry in cascading dropdown menu

    Hello, I have a list of price in 2 languages : French (FR) en English (ENG). Here is a model : <tbody> Please select a language Dropdown list 1 (choice : 'FR' or 'ENG') </tbody> <tbody> Object 1 50 Eur Object 2 100 Eur Dropdown list 2 (choice : 'maison' or 'avion' in FR / 'house' or...
  7. G

    Multiply 2 columns based on condition then sum them up

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

    looking for right formula

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

    VBA / Macro - Sort by ROW - Specific Requirement

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

    Return the last updated value with the cell formatting

    Dear Excel friend, I need your help in finding the last value updated along with the cell formatting. I have a table with some country listing in A column and currency amount in the next column The amount columns are formatted on currency as per the country code...
  11. S

    IF formula for 3 calculations based on the contents of Column D

    Hi All, Hope you are well. I would like some help on an IF statement please. In column D, I have the following values...EUR, GBP and USD. I need a formula which calculates based on the contents of the cell in column D. My formulas for the calcs are. EUR - =SUM('Raw Data'!E2/Menu!$J$4)/'Raw...
  12. D

    Find exchange rate within a date range

    I'm using Navision which only has a starting date in the tables. I have an exchange rates table as below I have a transaction line with the posting date 02-04-2015 where I need to add the exchange rate for this date. It is the first in below (6,9464) but how do I find this result with a Power...
  13. A

    Data summary - transfer certain columns of rows 2 criteria (VBA or Formula)

    Hi there, Recently I have received a payment workbook containing 2 Sheets (USD & EUR) and I would like to Transfer to a new workbook named purchase summary: Here is a selection of USD payment: <tbody> <tbody> Course type Month Description Invoice No. Lecturer Book Description Gross amount...
  14. S

    Index match column and row

    Hi, I am trying to index match with three different table ranges. I am apply the following formula in B16=IF(MATCH(A$15,$A$2:$B$2,0),VLOOKUP($A16,$A$3:$B$12,2,0)) the formula working fine but the problem is every time I have change table ranges. I need one formula for whole table range...
  15. J

    array formula to perform vlookup and sumproduct at once

    Hi, I am trying to compile an array formula to perform following action: Here are input data: Prices in EUR for parts for months <tbody> Jan 2018 Feb 2018 Mar 2018 Apr 2018 PART1 1 2 2 4 PART2 2 3 4 5 PART3 3 4 5 6 </tbody> Structures (bill of material) of finished products <tbody>...
  16. M

    Array formula - show only unique records without blank rows

    Hi, I know this can be done using array formulas, but I am not expert in them so maybe you can help me out. I have two tables: <tbody> location name value ... EUR Lucy 0 ... USA Fiona 0 ... EUR Jane 1 ... EUR Jane 1 ... EUR Lucy 1 ... ... ... ... ... </tbody> <tbody> location...
  17. A

    Excel Smart Price Buckets "Pivot" or VB Assistance

    Hello eveyone, Im looking for asssitance on calculating a buket level and total buckets, based on a comparison to another sheet ( Red culms) In order to emphesize here is an example; Sheet A ( Spend) <colgroup><col span="4"><col><col span="2"><col><col...
  18. N

    SUM of look up values based on multiple criteria

    Hello everyone, I am trying to calculate YTD (year to date) sum of Sales Revenues based on multiple criteria. Basically the idea is to have two drop down list in Dashboard sheet. The first drop down is used to select Customer Name and the second drop down list is used to choose Reporting...
  19. B

    VBA to clear contents, paste into another worksheet based on criteria

    I have data in a tab, called "SourceData" in the following order: <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> Curr Company Department Account Account Name Jan Feb Mar Apr USD 1 100 55100...

Some videos you may like

This Week's Hot Topics