honda

Hello Friends, This is part of my macro which I am using. Sub makecopy() Workbooks.Add ChDir "C:\BACKUP" ActiveWorkbook.SaveAs Filename:="C:\Backup\Factory Target.xlsx", FileFormat:= _ xlOpenXMLWorkbook, CreateBackup:=False End Sub Can I tell the code to pick...

Afternoon. I have a worksheet called HONDA SHEET which has a drop down list in cell A2 When i make a selection from the list my userform called HondaSoldItems is shown & values etc shown. Now what i would like to happen is when i press my close button on the form "NOT the red cross" cell A2...

Hello, I think what I'm trying to accomplish is relatively easy but I am really struggling on this one... One of the problems is I will need to do this everyday with different data so I'm trying to use a formula that can be used for all data in this same format. I have a sheet with 4 columns...

Hi, I have a code which works well & correct,it then calls the macro below. Sub sheettolist()' ' sheettolist Macro Sheets("HONDA SHEET").Range("A21:G21").Interior.ColorIndex = 6 Sheets("HONDA SHEET").Range("A21:G21").Copy Sheets("HONDA LIST").Range("A4").Insert Shift:=xlDown...

<tbody> ID Part number Kind manf. date comments 300 100 L 09/05/2001 toyota 300 101 R 06/03/2001 toyota 301 200 L 01/01/2015 Honda 301 201 R 01/01/2015 Honda 302 300 L 01/03/2012 Nissan 302 301 R 01/05/2014 Nissan </tbody> After merging...

Hi, I have tried various ways but i dont get all the items i need in the Msgbox. The code below is what i have so far. I require the following. Title, Two lines of message text, OK box. 16 vbCritical code to get the red circle etc with audiable beep Thanks very much MsgBox ("Honda Japan 11...

Hi & Good Morning, I have been working with a code for a while where the cell in question must have 17 characters otherwise the code would do its job. Example SHHFN13408U004767 I have recently had the need to now allow 11 characters. Example RG3-1009939 So the code needs to be working for 11...

Hi, For many reasons the standard Msgbox is no use for me in this case so i have made a userform. My problem lies with editing the code to know accept / use the userform. The 2 text boxes on the userform as advised for you. txtQuantitySold would be the value from the countif formula column F...

Hi, I am currently using the following code supplied. It works fine as it should but i have noticed that if the cell B13 has no value the macro still runs. Please can you advise an edit to add to the supplied code so not only must cell B13 be active BUT it must also contain a value Sub...

Hi, I am new with Pivot Tables and I have a scenario that I can't seem to make work. Say I have the following data in a pivot table (Car Owner is in ROWS, Car Type is in both ROWS and VALUES): Car Owner Bob's Cars: 1) Honda (100%) Car Owner Jack's Cars: 1) Honda (33.3 %) 2) Ford...

Afternoon all, I am using the code shown below to copy the data from HONDA SHEET A17:G17 to HONDA LIST A4:G4 This happens after i make my selection from a drop list down in cell F17 Sub sheettolist()' ' sheettolist Macro Sheets("HONDA SHEET").Range("A17:G17").Copy Sheets("HONDA...

Hello, So I've got an interesting problem, and I'm debating on the best way to kill this bird. I've got an excel sheet that contains the following (only it continues for 122 columns wide, and 80,000+ rows....): <tbody> sku description ACURA INTEGRA TSX YEAR HONDA CIVIC ACCORD .... abc123...