car

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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