1. S

    Error in code to rename existing folder

    Hello, I have the following code to rename an existing folder but it gives me error in the line: OldFolderName As NewFolderName. Can I please have your help to make it work? Thank you. Private Sub CommandButton1_Click() If Me.ComboBox1.Value = "" Then MsgBox "CAR can Not be Blank!"...
  2. Y

    Error in code to save loaded pictures in userform to specific path

    Hello, I have the following code that I got with the help of this wonderful forum. I have modified a little but it is not working. Would it be possible to get your help? Private Sub PicToSheet1(picControl, sht As Worksheet) Dim PCAR As String CAR = Me.TextBox1.Value Dim p As String...
  3. M

    Grouping certain value by colomn

    Dear Forum Need help please. I have entries raw data that not in order like this. Entry No 1, Car, Duck, Cabbage Entry No 2, Bird, Banana Entry No 3, Plane, Bird Entry No 4, Bike, Pea Entry No 5, Pear Entry No 6, Car, Duck, Banana Entry No 7, Duck, Bike I want all entries will grouping...
  4. A

    Conditional if in multiple rows and columns

    Greetings! I have a question that I believe it should be fairly easy to resolve for someone with experience. I have a data set that looks something like this: <tbody> Run Order Sequence CAR 1 2 CAR 2 1 CAR 3 3 CAR 4 4 APPLE 1 2 APPLE 2 1 APPLE 3 3 APPLE 4 - SODA 1 1 SODA...
  5. kelly mort

    Issue getting the value from an array instead of index

    Sub GetOutPut() Dim V1, V2, V3, V4, V5 Dim TheList Dim output V1 = "This One" V2 = "The Boy" V3 = "That One" V4 = "Car Race" V5 = "Cash Money" TheList = Array(V1, V2, V3, V4, V5) Output = Application.WorksheetFunction.RandBetween(LBound(TheList), UBound(TheList)) MsgBox TheList(output)...
  6. T

    split worksheet into separate worksheets based on row content

    Hi, Hoping someone could help me with this. I've been trying to find a way to do this and just can't get there. What I have is a combined spreadsheet that prior was multiple workbooks/sheets (don't have the original) and was combined into one very large worksheet. Each segment of the...
  7. A

    Macro to extract data from report

    Hello, I have a tedious task of reviewing data in a piece of software. I only need two pieces of data in order to do my review, but there are a lot of data that show up. I only need the data shown below (data are fictional): <tbody> xxxxx08a.p 7.8.50...
  8. C

    Guidance On what are the recommend method or how to display Graph with 2D Table

    Hi all to paint the context i not here to seek for answers but for guidance: Below is the following question. <colgroup><col span="7"></colgroup><tbody> The Popular rental car companies in town are Goldee and Supreme. Goldee charges $195.99 per day plus $0.85 per kilometer, and...
  9. U

    Pivot table question

    Hi there, is there anyway that showing data "as a percent of' will relate to the entire dataset? Meaning, for example, that if I have a data-set of car models sales by car makers and I choose to filter 'Audi' in the pivot-table- The percent of sales for A3 model will be in relation to the...
  10. J

    Count of gap between cells

    Hi, I have had a look through but couldn't find the answer to my problem. I have a table that has the time a car drives along a road in each direction, I have got this into one column, so that you can analyse the gap between cars. I have attached an image...
  11. T

    COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

    Hello kings i want to to combine ( sum if with subtotal ) to calcul consomation of Motor fuel so when i filter a car number it can calculate Gasoline Diesel fuel exemple in picture
  12. M

    Use search from a list.

    I want to use the search function but from a list. Ive got a column with a string of text. (A) And Ive got a column with a short string of text. (B) And a column with a category corresponding with the short string. (C) Now I want to use the list of short string to find the same in the long...
  13. J

    Transpose and group? How do i transpose one column into multiple rows base on value in another column

    Hello, this seems like it should be easy but I can't find ananswer. I have tried the native pivot function,transpose, etc. I have two columns likethis: (sorry for the bad formatting) Column 1 / Column 2 A / Apple B / Banana C / Carrot A / Airplane B / Boat C / Car A / Anything So I need...
  14. C


    <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> Invoices Name2 Priority...
  15. B

    Sort multiple tabs

    Thank you in anticipation. I have multiple tabs on a worksheet that are ordered thus (the numerals are times but set as text): Bus 14.10 Bus 14.40 Bus 15.10 Car 14.15 Car 14.45 Car 15.15 Plane 14.20 Plane 14.50 Plane 15.20 I would like to sort the tabs in TIME order.
  16. kelly mort

    Validation of texts from two different textboxes

    Hello I am looking for a script that will compare the values in two textboxes to see if the both contain same words. One box has "Small Yellow Car" Second box "Car Yellow Small" "Small Car Yellow" Etc Rules : 1. The order does not matter 2. The length of characters in both cases must...
  17. P

    another bill of material question

    so i got some great help on a bill of material question a month ago. now that i have been running the new system, the bills of materials are not set up traditionally. Usually the whole bill is exploded with all levels. If i have a bunch of bills in a query that are not exploded in levels, how...
  18. A

    Select a Cell Based on Value of Another Cell VBA

    HI - I want to create a column with concatenated column 3 like below. Basically select values from column 1 and column 2 where column 2 value is non zero. Can anyone please help ? Highly appreciated. <tbody> Column1 Column2 Column3 Apple 10 10 Apple, 8 Car, 2 Home Mango 0 Car 8...
  19. U

    Comparing for allowable items

    Good afternoon, I am attempting to identify mismatched data in Power BI. However, I am totally new to BI and am intimidated by DAX. I have two tables: Table 1 is a list of business IDs, and what item types they are allowed to interact with Table 2 is a list of business IDs, and what items they...
  20. R

    Index match same row?? possible?

    Hi, I am trying to do index match on same row is this possible? EG: <tbody> Apple 10/02/2018 car 12/03/2017 Orange 11/02/2018 bus 23/02/2018 Banana 12/02/2018 van 16/12/2018 </tbody> I want to search the top row for "car" and when it finds it return the adjacent cell so...

Some videos you may like

This Week's Hot Topics