num

Using Excel 2000 Hi, I got pattern in column C and in the column D Assign Num and in the column F got 27 unique patterns I am looking for 2 results... 1) In the column G find last the last row number of the each pattern 2) In the column H find the assigned number is matched in the column...

I don't have a clue how to search for something to help me with this problem. I have a worksheet with 5 columns (num, FY-Qtr, OP, UP, Qtr Result). I need to populate the Qtr Result column with the word Keep IF the total of the OP and UP columns for an FY-Qtr and Num is greater than zero. If...

Hi guys, Im having trouble with a userform which contain textbox and combobox and I asked my question in a couple of part. Firstly, ım trying to do when I activate the userform , it is supposed to ask me TimeSheet Num. That is so easy but the thing that ı get stuck on getting the TimeSheet...

Hey all, Title says it all! Here's what I'm trying to do! Let me know if this can be done! TIA!! <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] G H I J K L M N O P </thead><tbody> 4 #0F6FC6[/URL] , align: right"]...

Hello all, i have a sheet of more then 1000 journal entries and i want to print each entry in a separate sheet but it is very complicated for me to do that, so i need your help. https://drive.google.com/file/d/0ByIO6pEr5ISRbHc5dHZpTkZqYXM/view this is the link of example sheet and what i want...

Hi Can anyone know here how i will get some words or letter in the fields of the table and put it in another field. Thanks Here is the example: tblfromemail: Field Name: Subject Ticket Number: Num '7003894' Implement Task. Due Date: '2017-10-16 15:40:42'.Changes are released Result...

Is there any way that i could store the value of Dim num as Double num = Cells(x,1) - Cells(x,2) i'm kinda new to excel vba so im not sure if there's another way around this code TIA..

Good morning, I currently use a sub to add an input real number to any highlighted cells: Sub AddNumberPrompt()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Dim WS As Worksheet Dim rngSel As Range Dim Num As Double Dim i As Long Dim j As...

I'm trying to change the date in several different workbooks. Right now my code just references the cell that contains the new date, but I want it to hard code that date into the workbooks instead. How can I change this? Here's my current code. Dim Num As Double Num = 8 Dim FilePath As String...

I'm new to VBA and writing a code that will go through a list of excel files and update the date to match the current excel file. I want to make it so that we don't have to write the full file path including what drive its on, just match it to the folder that the files are contained in so that...

Hi Peeps, Im working on what i thought would have been an easy spreadsheet. Basically Im looking up data from a table, then im using the index function to sort the data. This all works fine.e.g: =INDEX($A$1:$C$7,SMALL(IF($A$1:$B$7=$E$1,ROW($A$1:$B$7)),ROW(1:2)),3) Which looks up the text in...