Pull Until . Found: Pull The Number From The Right Until It Hits The Decimal Sign
I have a column of numbers each have a 0. infront of them (example 0.2346
0.5698). I want to pull the number from the right until it hits the decimal sign. So for the two above the result would be 2346 and 5698
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Pull Text After @ Sign In Email Addresses
I have a worksheet with a column that contains about 30k email addresses in the following format: name@company.com I would like to make a macro to do the following: I would like to pull the company name out (the text after the @ symbol) and put it into the next column, but it needs to remain with the email. I would like to do this with all of the emails on the sheet. before: john@doe.com jane@company.com after: john@doe.com doe jane@company.com company
View Replies!
View Related
Pull Found Data From Multiple Workbook
I am trying to Loop Through a Folder Of Excel Workbooks and get required Info from one of the workbooks, back to my Master File. I thought of "VLOOKUP" but I am not shore if it will work over Approx. 60 workbooks? if there is an other or better approach, I am open to all Ideas. So far I have code to Open my Master and declare the criteria for the VLOOKUP with the help from: Re: Run A Macro On All Files In A Directory -------------------------------------------------------------------------------- See also this page on how to loop through a folder Loop Through Folder Of Excel Workbooks _________________ I am now able to open all Files in the sub directory, now I need to know how to approach my problem of looking for and getting the Info back to my Master File with approx. 5000 entrys to look for?
View Replies!
View Related
Pull Found Records From Table Based On Single Column
I have the following data :- SHEET 1 COL A_______COL B________COL C V1990_______J100_________U1212 H2323_______Y999 U2222 SHEET 2 COL A_______COL B________COL C U2222 I0000_______U8900________T67888 H2323 I need to search data from range defined A1.C3 and if any data in that range found in the sheet 2 that having the same records.
View Replies!
View Related
Pull Number Or Actualy Times Them Together
(the html is messing up the out put for a2 and a3) I am trying to get the total amout that is in the set in individual cells. I have the size type done just having trouble timesing the numbers in the cell Example. A1 A2 A3 10/2LB/CASE 20 Pound 12 16 OZ CASE 192 OZ 12/750ML/CASE 9000 ML 5 Gal/Box 5 Gallon (i have placed the columns to match formatting normal=A1 Bold=A2 Underline=A3)
View Replies!
View Related
Pull Left Number From Text
In a1 i have 100.888 and a2 122.222 and a3 122.555UK,(and so on) in column b i want just want the number and not the uk, i have tried =left(a1,7) which works until a3 then it give me characters 122.555 and not the number/value 122.55. I need it as a value to use the vlookup, how do i do it?
View Replies!
View Related
Pull Data From Worksheet Based On ID Number
I have 2 worksheets (Sheet1 and Sheet2). Sheet 1 contains around 3000 records with multiple fields (columns). Column A contains the ID number. Sheet 2 contains some records with different fields except for the ID number which is common. I need a macro to retrieve information from sheet1 and copy it to sheet 2 based on the ID Number; i.e the macro needs to get the ID number from sheet2, locate it in sheet1 and copy the data from column D in sheet1 for that particular record and paste it in sheet2.
View Replies!
View Related
Pull Number By Position From AlphaNumeric Text
I am having an issue with formatting a cell to 'general'. I have a macro that runs using a formula (i.e. =MID(A12, 18,5)) to extract certain characters from an external data source. I then use only the values of that formula. There then is another macro that compares that value to another value in another worksheet. The issue I am having is when the macro runs, the code is read as ActiveCell.Offset(0, 3).Value...but instead of returning the value in 'general' format, it returns it with what appears to be text (i.e. "75.50" instead of 75.5). This acts as a mismatch since the quotes appear. I have attempted several things to correct, but even if I try to format-->general it maintains the quotes. The only way it changes is if I click within the cell...then it turns to general (i.e."75.00" becomes 75.5). I am not sure what is the issue.
View Replies!
View Related
Pull A Reference Number And Assign It To All Records In A Particular Section
I need to pull a reference number and assign it to all records in a particular section. The code I recorded keeps going back to the first section. Also would like it to repeat until all records have the reference number attached. 06010-100Beginning Balance07/09/2004AD06011-10007/23/2004AD06011-10008/06/2004AD06011-100 06011-100Beginning Balance07/09/2004AD07/23/2004AD08/06/2004AD Sub Macro1() ' ' Macro1 Macro ' Macro recorded 10/14/2008 by acantu ' ' Selection.Copy Selection.End(xlDown).Select Selection.End(xlDown).Select Range("C7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("B7").Select Selection.End(xlDown).Select Range("C63").Select Range(Selection, Selection.End(xlUp)).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Selection.End(xlToLeft).Select Selection.End(xlDown).Select Selection.End(xlDown).Select Selection.End(xlDown).Select End Sub
View Replies!
View Related
Indirect Address/match: Pull The Highest Number
I am trying to do season stats for my roller derby league. I have a great spreadsheet going but the one thing I want to do, I can't seem to do. I am attaching a "test" file. very simple and small but shows what I need to do. I have different sections and I am trying to pull the highest number out of that section. For this example, it is under the green Jams Skated: Jams at Jammer. The number on the right is the highest number of jams skated while the number on the left should be the name of the skater who has this number. Okay, no problems there. My problem occurs when I try to move these same formulas to another sheet. in this case, sheet 2. It pulls all kinds of strange things.
View Replies!
View Related
Pull/Extract Number Before Specific Character In Cells
What formula or function truncates a text field that is in the following consistent format: number. name ie. 3. Super Bella and 150. Taoist I wish to truncate the field so I have just the integer without the dot, space or word(s). Tried Len, Left & Replace but they require a specific number of characters. Since the number can be 1 to 3 digits long, this doesn't work.
View Replies!
View Related
Create A Formula To Pull The Person's Name And The Avg Number Of Cartons
I am trying to create a formula to pull the person's name and the avg number of cartons sorted for the month from this spreadsheet. I've attached a sample of the spreadsheet I created, you will see at the bottom I would like to see the person that had the highest avg for the month and the person with the lowest avg for the month. This is just a simple spreadsheet to track productivity of my sortation employees.
View Replies!
View Related
Decimal Sign Replaced With ';' Sign
I'm trying to solve a strange problem in a piece of code. I have a variable that is define as Double called STD. When i try to insert that variable in a formula the decimal sign (for me a comma "," because I'm Portuguese) gets converted to ";" (which is for me the separation sign for the expressions in excel formulas. ex: AND(A1>0;B1>0)=TRUE). The code is:
View Replies!
View Related
Concatenate Formula Not Taking Decimal Places/currency Sign
i have lets say a table with rows that contain the following data. SKU - PRICE - SALEPRICE - DESCRIPTION - SALEDESCRIPTION What I am trying to do, is to make a concat formula that says: SALEDESCRIPTION = DESCRIPTION+price was+PRICE+now+SALEPRICE In essence so that i can simply pull down the formula, and all our product descriptions have 'special offer, was xx (price) is now xx (sale price). This works fine, except that in the SALEDESCRIPTION, the amounts from the price and saleprice fields are being brought over without decimal places and without currency symbol. I have tried formatting those two columns as currency or accounting but neither works.
View Replies!
View Related
Paste Two Decimal Number In Excel Without Extra Decimal Places Appearing
I have a vba macro that takes data from one workbook and pastes it into another workbook. In doing this I have declared a few variables of type single (I only need two decimal precision). However, when I copy the values from the cells on the source workbook and paste them into the target workbook, the numbers end up having 12 decimal places. Ultimately, this extra precision causes my totals to be off by .01 or more after a while. I have tried rounding the number as I pull it off the source workbook into the variable, but that didn't matter. How do I solve this problem? Code for pulling data from source workbook:...
View Replies!
View Related
HOW CAN I PULL INFORMATION FROM ONE SHEET TO ANOTHER IF NOT #
I need a formula that will take info from sheet A column K only if sheet A column E is equal to sheet B column E. I need it to paste into Sheet B column K exactly as shown in sheet A column K. I tried using a Vlookup formula but I got #N/A and I am not sure if that is because there is text as opposed to numbers or if I am using the wrong function entirely.
View Replies!
View Related
Multiple Pull-down Menus
I have the following fields: Manufacturer:System:Part Number:Material Description: I want to make each field a "pulldown menu". For simplicity, lets say I have three Manufacturers "A", "B" & "C" Each Manufacturer has three systems "1", "2" & "3" Each System has 100 parts "1-001" thru "1-100", "2-001" thru "2-100" & "3-001" thru "3-100". Each part has a corresponding description such as "Horizontal", "Vertical", "cover", etc... I need to keep all of the manufacturers, systems, parts and descriptions in one excel workbook. I have no preference to how that information is built (tabular, list, etc..) I would like the workbook in which i want the fields above to be separate, so I only have to keep updating one master file that all of our takeoff sheets would be linked to. when I select a manufacturer, I only want the available systems for that manufacturer to show up in the next pull down menu, then for that system I select I only want the available parts for that system to show up in the next menu. the descriptions need to correlate with the parts I select.
View Replies!
View Related
Pull Down Option Description
I have created a pull down menu but cannot figure out how to add descriptions with them. The items in the pull down menu are codes instaed of making people look up their definition in a printed out table,I am hoping to figure out how to make it so that as people scroll through the pull down menu a corresponding definition for the "code" listed appears.
View Replies!
View Related
How Do I Pull Drive Data
I am trying to get a excel to list all the file names in a drive along with date last modified, author and file size. I have got the following bit of code to pull back the file names, but i am struggling to find anything that will pull back the other data, I think its something to do with the DIR function, but im not sure........ Range("B1").Select D = ActiveCell Cells(2, 1) = "Filenames" r = 3 f = Dir(D, 7) Do While f "" Cells(r, 1) = f r = r + 1 f = Dir Loop End Sub where "B1" is the file path of the drive
View Replies!
View Related
Cell Pull Down Formatting
I'm making pull down menus to auto fill in some options in my Cells... such as "Open" "Closed" "Work in Progress" what I would like is to have the menu also enter text formatting... so that I can have "Open" entered in RED and BOLD... and have "Closed" Entered in GREEN and Italics.
View Replies!
View Related
To Pull Some Data From One Sheet Into Another
I need to pull some data from one sheet into another. Here is an example of what I am trying to do if anybody know hows to do this? I need a formula that will look in sheet 1 look at the idnumber, match it with the idnumber in sheet 2 ande fill in the serial. sheet1 idnumber serial number 12345 66181 12346 66182 12347 66183 sheet2 idnumber serial number 12345 insert serial number here 12346 12347
View Replies!
View Related
Pull Data From Another File
Basically what I want to do is pull data from another file and have it copy it down about 10 lines onto another file. With a seperate sheet for each vehicle. For example: File 1: Has 2 columns with data Vehicle Number 1000 Vehicle Type Ford 1001 Chevy 1002 Dodge File 2: Has a vehicle log sheet, in which i want it to take the data above and copy it down x amount of lines. Vehicle sheet | Date issued | Hours used Vehicle Number| (data from file one here) | Vehicle Type (data from other column in file one here) And have it copy itself down from like A1 to whatever. These also have to be on seperate sheets within the workspace, and each "tab" be named after the vehicle number,
View Replies!
View Related
How To Pull Out All Data From A Row
Is there a way to pull out all of the data from a row and place it into a cell out to the right of the range? Some of the data is text and some of it is dates. My problem is that it is a big spread sheet and the data is scattered in the sheet. Not uniform at all.
View Replies!
View Related
Pull Out Unique Values
I have 36 cells that will have multiple letter values. The cells in the range (MyRange) in question, have formulas in them. I will be transferring this into a cell range that has over 6000 cells, but I'll worry about that when I get this part down. :D I have 07 excel but this is in the older versions.
View Replies!
View Related
Pull Values From Many Worksheets
I need to place a value in cell B on sheet 2 of a workbook. The value I need is stored in C10 on all other worksheets in the same workbook. The name of each worksheet is stored in Column A of sheet 2 (Rows 3 through 404). How do I get the value from C10 on each worksheet into the corresponding row on Sheet 2? I have Excel for Auditors and there is code on page 201 but it is the reverse of what I need. I need to get the value from the worksheets as opposed to moving a value to the corresponding worksheet. Example: Sheet 2 Column A Row 1 = Worksheet name Column B Row 1 = Need Cell C10 value from worksheet name referenced in A
View Replies!
View Related
Pull Some Statistics From A Workbook
I'm trying to pull some statistics from a workbook I've been sent and am having some trouble working out how to achieve this. I have a small interface that allows the user to choose a possible answer (drop-down menu) from a questionnaire (Yes, No, Maybe)(cell: C6). On the interface the user also picks the question they wish to see the stats for (cell: C5) The data I have been sent has been set up with the questions along in row A, and the answers below in each column (the answers run across row A from column G - AH). So, what I'm basically after is a formula that first looks up the question specified in C5 (I've used HLOOKUP to pull some other data), and then counts how many times the Yes, No or Maybe answers appears in the column where the question data is held.
View Replies!
View Related
Pull In Address From Another Worksheet
I have two worksheets. The first is a master listing of all stores for a certain client. They are all assigned a store number. The second sheet is a list of all invoices, I need to be able to type in the store number and it pull up the street address, city, state and zip, all in different columns.
View Replies!
View Related
Pull From Closed Workbook
I have a folder that contains hundreds of excel workbooks. Each workbook has 20 or more sheets. All workbooks have the same look and design. All workbooks have macros that they use to function and the macro I want cannot interfere with their macros. What I want to do is copy certain cell values (some numeric and some text) from several sheets from these workbooks and paste them into another workbook (a master workbook) that is essentially collecting these values into a table without having to open all these workbooks. For example, let’s say all of the workbooks are named with a numeric value starting with “one.xls” and that the sheets in these workbooks are named “a”, “b”, and so on. So, in the master workbook in cell “B2”, I want the name of the first workbook searched (“one.xls”); then in cell “C2”, I want the value from cell “J45” on sheet “b” of “one.xls”; in cell “D2”, the value from cell “B32” on sheet “b” of “one.xls”; in cell “E2”, the value from cell “K13” on sheet “e” of “one.xls”; in cell “F2”, the value from cell “R43” on sheet “k” of “one.xls”. The in cell “B3” of the master workbook, I want the same information as before except from “two.xls” instead of “one.xls”, and so on down to “three hundred.xls”.
View Replies!
View Related
Pull Last Entry From Column
I am trying to find a formula that will choose the last number from a column of data. The column has a number added everyday and I want the last number entered to be pulled to a different cell. e.g. 34 35 35 33 38 37 so 37 is entered into the cell
View Replies!
View Related
Pull Data Into Workbook
I have a workbook I created that is full of macros, graphs, and formulas. Five of the tabs in the workbook are where I will be putting my data. This workbook will also be used by others that don't even know what a macro is or does so I need to make this as simple as possible. How I get my data: I have a website on my intranet where I have to login and then I have five templates that I run. I can have the results given to me either in HTML or in an excel spreadsheet. The excel results are very basic. Heading for each column and the data below. I have the report generated with blank columns since my page the data will go on has formulas. Thus far I have been copying all rows starting with row2 and doing a paste special (values, skip blanks). I had a macro in my personal.xls file to do this for me but most users will not know how to import it so I need a resolution that will be saved in the WB I send out.
View Replies!
View Related
Pull First Character From One Cell To Another
I am using an exported dbf from filemaker pro. This is an established dbf, with over 2,000 sku's in it. Here is what I want to do. I am using Indata and InDesign to create a catalog. I need for excel to pull the first character from a cell and put it in another cell. i.e. I have a dbf where I have author last name, and title of book. I need for excel to pull the first character of each of these fields and put them in their own cell/column. This will allow me to use these new columns to make the " headers" for my InData/InDesign doc.
View Replies!
View Related
Pull Some Numbers From Text
My Cells contain loads of text like this: ["16733:0:0"] = “Product ID”:1:1:0", now what i need is just the 16733 to be extracted into its own cell, and the Product ID to be extracted into the cell next to it... all other Text can be deleted. The problem is, pretty much the whole of the text changes in each line :- ["12345:0:0"] = “Product ID1”:1:1:0", ["49573:0:0"] = “Product ID23”:4:8:0", ["2649:0:0"] = “Product ID485”:18:23:0", ["9264:0:0"] = “Product ID0473”:2842:2341:0", ["54321:0:0"] = “Product ID85647”:99:199:0", In the Numbered part of it (the bit I actually need), it would be either 4 or 5 digits long. Im guessing what I need to do is remove parts bit by bit, but for a novice user - Its proving a bit difficult!
View Replies!
View Related
Pull Values Between Two Periods
I have a text value which consists of two periods ".". I want to pull the value in the middle. eg. From the text value in a cell "oakland.california.usa", I want to pull "california" in another cell. All the values in column are in similar format. A B 1 oakland.california.usa california Hope this is not duplication of any pre-existing thread, if it is, I probably don't know the correct keywords to query.
View Replies!
View Related
Macro To Pull Certain Cells
Need to create a macro that pulls certain data of a certain varying limit to different sheets, e.g. I have a sheet titled 'Data Dump' which contains lots of information specific to certain models of a product. I would like two other worksheets, one called '1' and another called '2' to pull the following information: Worksheet 1 should pull data in columns A, B and I (in data dump) based on whether column H in Data Dump is = 1 to the total of 100 (i.e. 100 rows of information. (here an if statement would pull 100 and include empty rows, I do not want empty rows). Worksheet 2 should pull data in columns A, B and I based on whether Column H in Data Dump is = 2 to the total of 50 (i.e. 50 rows of information.
View Replies!
View Related
Identify And Pull ONLY Numbers Out Of Cells
I am working on a spreadsheet in Excel '07 that will pull data from online and reformat it in a way that another program can digest. The last thing I need is for excel to recognize if there is a 6 digit number in a specific column. This is tricky for two reasons: 1. Numbers come in three different formats, ### ###, ######, and ###.### 2. Sometimes there is also text within the cell, however I need to pull out just the 6 digits, and place them in another cell with format ### ###
View Replies!
View Related
Pull Or Push Data From One Workbook To Another
I'm looking for something that will be able to push or pull data from a workbook (named "Personen - test.xls" = persons) to an other workbook (named "Personen per maand.xls" = persons/month). In attached documents i tried to make clear (sorry, it's in dutch) what i would like to do. In English; the marked data in "Personen - test.xls" should automatically be shown in the marked area in "Personen per maand.xls". I think the biggest problem is the fact that "Personen per maand.xls" is a standard-document which should be filled -time after time- with many different data's from several "Personen - test.xls" documents. These documents are all named different, the data is always given in the same way. So in my opinion i should make something where i can tell excell which document to use and something i can tell where to put the data. But i really don't know how to do this...
View Replies!
View Related
IF Statement To Pull A Date Range?
I've created an IF statement with multiple formulas, but I can't seem to figure out if it is possible to pull the information by a specific date range. I have sales reps that visit customers on specific dates and I need my tally sheet to only pull dates within that current week. Does anyone know if this is possible?? This is what I have so far: =SUM(IF(sales rep!AB2:AB216=I3,IF(sales rep!$AA$2:$AA$216=I4,IF(sales rep!P2:P216=I7,IF(sales rep!$N$2:$N$216>=DATEVALUE("3/18/2005"),1,0))))) If you look above I have it to calculate the date value starting at 03-18-05, but I would like it to only pull that date through the next week.
View Replies!
View Related
How To Pull The Duplicate Values From 2 Columns?
I have this problem I have 4 columns which contain data. The first column is a list which contains random values from the third column. Now what i want to do is to pull the duplicate values from the second list without agitating the data from the 4th column because it is corresponding.In the example i have attached i would like to take the values from column A and find them in column F then extract them together with corresponding value from column G
View Replies!
View Related
Pull Data From Folder Of Workbooks
I have a whole group of workbooks. Is there a way to make a new workbook that will look in the folder containing all of the other customer's books and pull information from them? In other words, I want a workbook where in Column A would contain all of the Customer's Names (Cell Info!G6), Column B would contain the Insurance Company (Cell Info!M14), etc. Is there a way to to that?
View Replies!
View Related
Pull Query Results From Access
I'm at a stand-still again, as my current task calls for a way to communicate between Access and Excel. I know where the data I want in my Excel workbook is, and there's a query in place to pull it into a table. What I'm trying to do is write a macro that will open that particular table in Access, run the query, select the table, open a particular worksheet in my workbook, and then paste the data in. This isn't hard to do by hand, besides finding the right database among a mess of others. But I want someone who isn't me to be able to get ahold of the same data by running the macro. It'll make less work for me in the long run.
View Replies!
View Related
Pull Specific Data From Spreadsheet
I have a complex data set that has been imported into Excel from a binary data file and I am looking for a way to simply pull out specific fields. I tried to record a Macro that would simply delete the rows between the data rows I want to keep, but it always references itself to those same ranges and I'm not sure how to identify that I want it to sequentially move down the page deleting the same number of rows, and adding the row of information I want to keep as it goes.
View Replies!
View Related
Pull Unique Values From 3 Locations
I would like to create a macro which will look at columns A,B and C. Based on A,B and C, I would like the macro to return only the unique combinations. At the same time, I would like columns D and E to perform a sum. This is the original sheet: ******** ******************** ************************************************************************>Microsoft Excel - Trial19.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutE1E2E3= ABCDE1A1YES1032B2YES1013C3NO1034D4MAYBE1015D4MAYBE101NJSS* [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR. This is what the sheet will look like once the macro I would like to create is executed. ******** ******************** ************************************************************************>Microsoft Excel - Trial19.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutE1E2E3= ABCDE1A1YES1032B2YES1013C3NO1034D4MAYBE202NJSS* [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR. As you can see, the highlighted areas denotes the changes that were executed through the macro.
View Replies!
View Related
Prompt User For Data To Pull
I'm building a spreadsheet that consolidates multiple worksheets into one. I've got that portion done, but what i need help with is a user prompt. I don't have an example at the moment, but it should be fairly straight forward. Rather than consolidating all the data into one worksheet I want to consolidate only the rows that contain certain information. The column I need to query in each worksheet is "BL". The only thing is that column won't always contain the same data. Is there a way to do basically a prompt to where it searches for the data they want and if it isn't in there it just moves on to the next worksheet automatically?
View Replies!
View Related
|
TRACKER
