extra

Hi, I am looking to a way to import data from a list <colgroup><col span="3"><col><col span="3"></colgroup><tbody> cola fanta sprite 320 JAN CAR STANDARD EXTRA 12-Jan 13-Jan RETOUR USED 321 PIET TRUC STANDARD EXTRA 12-Jan 14-Jan RETOUR...

Dear All I am using the following code to print my Invoices Dim n As Long n = Application.InputBox("Number of extra printed copies.?", "Printed Copies", 1, Type:=1) If n <= 0 Then Exit Sub ' User canceled With ActiveSheet.PageSetup .RightHeader = "(ORIGINAL FOR RECIPIENT) "...

Hello, I'm trying to add a sheet within a sheet. I have 3 bank accounts, account 1 is sheet 1, sheet 2 is account 2, sheet 3 is account 3. I need to create sheets or sub sheets that I can create so when I click the sheet, my sub sheets pop up so I can then select the sub sheet I want. In this...

I am trying to create a amortization schedule for an auto loan where the monthly payment changes based on the previous payment. I found a template that creates a amortization schedule but the payment is fixed throughout the schedule. My first payment when I first started paying was $360 for 60...

I have a holiday allocation calendar and i want it to highlight todays date with a thick border. I cant get conditional formatting or anything to work and im wondering if i could add an extra something into the formula...

HI All Hoping you can help me sort this out. I thought I had it but not working how I want it. I have a formula that I am changing daily to include one extra cell in the formula. =((SUM(Daily!BL10:bt10)-SUM(Daily!BL4:bt4))/SUM(Daily!BL4:bt4)) The range is all the way up to CP4 or CP10...

Hi, I am looking at a spreadsheet provided by a colleague. It appears to have restricted the column's viewable. So I can only scroll over to column AH, and then it just ends. This must be a setting, it is not like the extra columns are hidden. Does anyone know how to alter these settings...

<tbody> a b c 1 batsman runs 2 sunil 14 3 c kapil b salil 4 malcom 28 5 runout 6 peter 49 7 b steeve 8 sachin 35 9 c lily b steev 10 extra 4 11 total 130 </tbody> Hi, I have data something like aboves I want help to write vba for...

Doing inventory, Item A is short -3 Item B is over +3 Total amount of inventory +/- is 0 but in reality I am off by 6 I know ABS returns the absolute value of a number and it is not a big deal to add an extra column for ABS Value But I was wondering if there was a neat trick to...

Please can someone help me with a nested if formula. Understand the concept just cannot get it to work. I’m wanting to band a set of data into categories as follows: Less than 20 = small 20 - 59 = medium 60 - 99 = large 100 plus = extra large If someone could post me the foruano for this I...

I am using vba to search for searching for certain key words/phrases in excel spreadsheets. Sometimes a phrase may have extra spaces in between words i.e. "Forecast O&A $ per Unit" When I search i use "Forecast O&A $ per Unit" (only one space between each word). In my spreadsheet...

Can someone show me how to remove all words, characters and extra spaces from a Userform textbox with the exception of the first word?

Okay, so I have a large macro written that changes formatting in a file, the lines might only be like 300 lines and the columns maybe 8 columns, but the size of the file is rather large. How can I write it in the macro to dump extra space? I have the macro to create a new file and to move the...

So, our payroll system doesn't know how to properly space text in a report to be exactly how long the word or words are therefore we have to estimate the spacing to be x number of spaces. Which means if the word or words are shorter than x number, the rest of the field contains spaces. For...

Hi, I have a sheet that I am creating that has department numbers in column C and names in column B what I would like to do is have a macro to sort the data in columns B:DL by department number then by name but after each department add an extra line in so that they are spaced out. Can anyone...

In the worksheet I have fixed the column width as follow: Column A Column B Column C AAAAAAA|BBBBBBBB|CCCCCCC| Supposed when I save it as prn the output would be: AAAAAAABBBBBBBBCCCCCCC However the output went wrong and become: AAAAAAA BBBBBBBB CCCCCCC There are three extra spaces between...

Hi all , i need your helps for my excel document. I am newbie at vba. 1) I have 3 combobox and i completed 2 of 3, but last one is date it should be extra filter like not compulsory 2) I need make a graph with a button on user form 3) I need insert shapes on userform by pressing a button Doc...

Sorry guys, I've done this before but cant get it to work this time I have a name as such John,Doe but I need an extra space after the comma as such John, Doe Please assist

I'm using 'Chr(10)' to add line spaces between text in a textbox, (not sure if this is the best one to use and don't know the difference between the different methods anyway), but is there a way I can run a routine to remove extra spaces once the Userform is displayed, or just before it is to...

Hi Everyone, I am running into a frustrating problem with a VBA project I am working on. Our organization uses a 14 month year (12 regular months and 2 special posting periods for trailing charges), and I am not sure how to handle the two extra periods. I want to validate that the month of the...