need help

  1. cyrilbrd

    VBA format entry

    Hi, Given a UserForm with a TextBox named TextBox1 The textbox will feed data to an excel table using the following code: Sheets("Data").Range("Data_Start").Offset(TargetRow, 6).Value = TextBox1 We would like the user to encode 6 numbers example 123456 that would show in the table as...
  2. B

    Format Date/Time

    Hi, My CSV has different date/time values. I have tried to format the cells but the values aren't consistent. Any idea how to amend these please? Some years show 19 and other 2019, some values are left aligned and other are slightly to the right. I can't seem to make it all the same.
  3. H

    Esc key not working in Excel windows 10 Office 365 excel

    Hi Guys Anyone discovered this issue and how do I fix this, please? :)
  4. T

    Increment Duplicate value by a dash and 1

    Hi VBA Gurus, I hope everyone is doing well. I have this list of Customer IDs and the number of payments for this check run. It's company practice to increment the IDs by -1(Manually), adding one each time, while doing nothing with the first ID instance. Please see the small example below...
  5. O

    Power Query - changing entries and Big Data

    Hello, everybody. I have CSV files that upon opening have some irregular IDs' entries (all IDs should have 17 characters but after filtering them by the length I found some that had an irregular amount of characters - 14, 15, 18). However, when I created a Power Query, suddenly all the IDs...
  6. S

    Need help on Insert PDF file VBA function

    Dear Members, I am using the following code to display photo from a folder in my excel sheet. Sub DisplayMainPicture() With Sheet1 On Error Resume Next .Shapes("ReceiptPic").Delete On Error GoTo 0 If .Range("I12").Value = Empty Then Exit Sub PicPath = .Range("I12").Value 'Picture Path If...
  7. S

    Need Help on Exporting Excel Sheet as CSV format

    Hello Everyone, Need your help to export custom worksheets of a workbook as a separate CSV file. For example, I have 7 worksheets in my workbook, out of which I need to export only 2 sheets only. So, I need a macro which would prompt me to select sheet/sheets to export and select a folder to...
  8. S

    Categorize shifts based on time

    Hello, I have a work item where I’m in need to mark or categorize the shift data based on times ! Say for eg : 6 AM - 01-30 PM = Morning shift 01.30 PM - 09.30 PM = Noon shift 09.30 PM - 06 AM = Night shift My input data in A column would be 00:57 AM 13:47 PM
  9. T

    Changing FilePath from user Select to a "fix" FilePath

    Imran Isshack 12:24 PM (30 minutes ago) to me Hi All, I have this VBA code I found on a MrExcel Thread which is working well, except I must manually select the target folder each time it’s executed. This VBA renames all files in a folder based on a cell value(A2). Is...
  10. T

    Excel VBA- Mass rename all files in a folder based on Cell A2

    Hi All, Below is a example of daily downloaded files(somedays are > 30) which I manually placed in a folder. The downloaded files names are not useful (Screenshot). I have been "manually renaming" and saving using the below VBA. I do not need to make a copy of these files, just needs to rename...
  11. M

    Resize Every Table Of my Powerpoint Document

    Guys I really need some help. I have tons of tables in a powerpoint document. Some are 2 in x 2 in and some are 3.5 x 3.5 in. I need to resize only the 3.5x3.5 tables to a size of 2.8x2.8 I know this can be done with some easy vba code, but I don't possess the knowledge for it. I know it has to...
  12. S


    Hello Everyone, I have following table and need help on sum total of Value 1 column. Value 1 Value 2 100.00 100.00 200.00 500.00 300.00 300.00 400.00 100.00 I am looking for a formula which would return value based on the following criteria: If Value 1 = Value 2 then exclude that...
  13. S

    Need help on Power Query to transpose data

    Hello Everyone, Need help to convert data from column wise to row wise. My current data set is as follows: Column 1 Column 2 Jan 100 Feb 200 Mar 300 April 400 May 500 I am looking for a result as follows: Jan Feb Mar April May 100 200 300 400 500 Thanks in advance. Best...
  14. P

    Power Query Loop Calculation

    Hi, I am new to Power Query and have an issue with a task which is relatively easy to complete in excel. I need to get a loop calculation where the next output is dependant on the previous output in two places. Please see below for a brief snapshot. The Starting point is 100 and no calculation...
  15. A

    Calculate KPI using percentages

    Hi Gurus I hope I can explain this correctly. I need to calculate a KPI using %, I got as far as creating the target. Column D is the target of 100%, so if the target is met then the achievement is 100%, I need to calculate the achievement with a max of 200%. Any ideas on how to get this done?
  16. S

    Need help DAX LOOKUP formula which would work like VLOOKUP

    Hello Everyone, I have two tables Table 1:- Voucher No. Invoice No. Invoice Amount Invoice Date Vendor Name 1 ABC-1 100 14/05/2019 ABC Company 1 ABC-2 200 14/05/2019 ABC Company 2 EFG-1 300 31/05/2019 EFG Company 2 EFG-2 400 31/05/2019 EFG Company 3 XYZ-1 500 30/06/2019 XYZ...
  17. S

    Need help of Date Format

    Hello Everyone, Is there a way to show a date as "MM-YYYY" format in power query or in DAX. The actual data is in "DD/MM/YYYY" format. Thanks in advance. Best Regards,
  18. S

    Copy data from two different sheets

    Hello Everyone, I have two sheets with follow data: Sheet 1 SR. No Data 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H Sheet 2 SL. No Data 1 100 2 200 3 300 4 400 5 500 6 600 7 700 8 800 I am looking for a formula/way to copy data from above sheets to a third...
  19. L

    "Translation" of Excel formula into M language for the Power Query Editor

    Hi guys, I am totally new to Power BI, the Power Query Editor and most of all the M language. I wanna try to import data from different Excel documents using the Power Query Editor and then merge different columns from these separate documents using the joins function. Finally, I plan to add...
  20. L

    Drill through y-axis on stacked column chart

    Hello, I have a stacked column chart with dates on the x-axis and different codes on the y-axis. I would like to set-up a drill through / drill down function for the codes on the y-axis but I don't know how to do this. For example, one of the stacked column is the code "3xx". This code is...

We've detected that you are using an adblocker.

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
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 "".
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.
Go back