Numbering Blocks Of Data.
I have 250000 lines of data and at the moment they are in seperate blocks of different sizes, and seperated by 5 blank lines.
For Example
112
1523
523
1523
*5 BLANK LINES*
12
23
*5 BLANK LINES*
344
4563
etc.
What I would like to do is give each block a number.
1 112
1 1523
1 523
1 1523
*5 BLANK LINES*
2 12
2 23
*5 BLANK LINES*
3 344
3 4563
The lines in between will come out eventually I just need them there as they are difineing the blocks of data.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Compare Blocks Matrix Of Data
I have the follwing data in A1:T17 3,4,7,9,10,11,21,32,33,35,37,41,47,57,60,64,69,72,74,75 4,6,9,10,12,13,15,21,22,31,35,47,49,52,56,63,64,72,74,75 4,6,9,10,15,21,31,33,34,41,42,45,46,47,57,60,68,72,74,78 3,4,6,10,11,13,18,21,30,32,33,35,46,53,60,67,69,74,77,78 6,9,13,16,21,22,31,46,48,49,52,61,63,64,69,70,71,75,78,79 3,4,7,10,14,17,18,21,28,31,33,36,37,43,47,57,65,69,75,80 4,7,13,15,17,25,29,32,37,42,45,47,50,57,60,64,68,71,72,74 3,7,10,11,16,18,28,34,35,43,47,51,52,55,56,57,60,64,71,72 8,9,10,12,16,21,22,28,38,47,49,51,52,53,54,55,64,66,71,72 4,5,6,9,12,15,19,20,30,34,35,38,45,47,54,56,63,65,72,78 5,6,9,12,15,21,26,31,32,43,44,47,64,66,67,68,69,74,75,80 .................. I want to compare the first set of 20 numbers (A1:T1) with the second set (A2:T2) and check how many numbers match. ** If the matched numbers are >=10 ** then list them to the right of cell W1. In this example, 10 numbers matched are 4,9,10,21,35,47,64,72,74,75. List them in W1:AF1. Now compare (A1:T1) with (A3:T3). In this example, 11 numbers matched 4,9,10,21,33,41,47,57,6,72,74 list them in W2:AG2. Now compare (A1:T1) with (A4:T4). 10 numbers matched 3,4,10,11,21,32,33,35,60,69 list them in W3:AF3. Compare (A1:T1) with (A5:T5). Here only 5 numbers matched 9,21,64,69,75 (Which is ** less than 10 ** - does not match the criteria) DO NOT LIST this. Compare (A1:T1) with (A6:T6). 11 numbers matched, 3,4,7,10,21,33,37,47,57,69,75 list them in cell W4:AG4. ................. Sub Compare() Dim r As Integer, rr As Integer, c As Integer, cc As Integer, opc As Integer, opr As Long opr = 1 For r = 1 To 16 For rr = r + 1 To 17 opc = 23 For c = 1 To 20 For cc = 1 To 20 If Cells(r, c) = Cells(rr, cc) Then Cells(opr, opc) = Cells(r, c) opc = opc + 1 End If Next cc ............................... Next r End Sub The above code runs fine but If I increase my rows from 17 to 1200 it takes 3 1/2 hours to complete. Can it be reduced?
View Replies!
View Related
Sort Range Data Blocks
I have a list of data (as shown below under Input), which I would like to sort them according to their block number (as shown below under Output). The hurdle is the sorting should be able to cater for missing fields. Also, note that the sector can be recurring, that is "P,P,Q,Q", and then follow by "P,P,Q,Q" again. INPUT Block No.SectorData 11P19 22P 33P39 41P18 52P21 63P38 75P22 85P24..............................
View Replies!
View Related
Copy Data Range Blocks
I would like to copy specific cells (all in one block) to another worksheet, then do a bunch of other things with the data (these steps work already), then go back to the original worksheet and copy the next block of data, repeat about 50 times, then stop at the end of the list. I can't attach a file as I can't get it under the file size limit but the rows to move (just to any worksheet in the workbook, from there I can manipulate and move as required) each time are row 1 plus all those pertaining to each subject group. So for group 1 it would be row 1 plus rows 6 to 28 - for group 2 row 1 plus rows 29 to 51 - group 3 row 1 plus 52 to 74 etc. If I can just get looping through chunks of data and moving them around under my belt
View Replies!
View Related
Sort Records Within Data/Range Blocks
I have around 50,000 records in a data file within which groups of records are contained in blocks delineated by date/time. e.g.; A B C D E 10/03/2008 13:15 a 100.0 10/03/2008 13:15 b 2.8 10/03/2008 13:15 c 50.5 10/03/2008 13:15 d 8.6 10/03/2008 13:15 e 32.5 10/03/2008 13:25 75.2 <-----Time change 10/03/2008 13:25 5.5 10/03/2008 13:25 16.5 10/03/2008 13:25 3.5 etc As you can see, while the file is ordered by date/time in Column A, the values in column E are randomly ordered. My objective is to maintain date time order but sort the values in Column E into an ascending order within each block. So, for example, using the details above I would want it to look like; A B C D E 10/03/2008 13:15 b 2.8 10/03/2008 13:15 d 8.6 10/03/2008 13:15 e 32.5 10/03/2008 13:15 c 50.5 10/03/2008 13:15 a 100.0 10/03/2008 13:25 3.5 <-----Time change 10/03/2008 13:25 5.5 10/03/2008 13:25 16.5 10/03/2008 13:25 75.2 Note that there is data in columns B to D which would need to be sorted in line with Column E. So, all records in the block, cols A to E are sorted to give the above order for each time block. My problem is that I'm not sure whether a basic sort can do the job or whether a macro is needed. I'm using Excel 2003.
View Replies!
View Related
Move Blocks Of Data In 1 Column To Rows
Moving Data And Deleting Blank Rows. I am a complete newbie to excel VBA and require assistance (if at all possible). I have data in the following format in an excel sheet (I have a lot more rows but give an example for two rows)... in 1 column but I wish to separate it (i.e. move data along onto the first row in other columns) and delete blank rows. For Example: Col1 AAAA BBBB CCCC DDDD EEEE AAAA BBBB CCCC DDDD...............................
View Replies!
View Related
National Insurance Number Validation On Blocks Of Data
I have a spreadsheet where data is pasted on from spreadsheet supplied by various external companies. One of the main problems we're having when validating the data is an incorrect NI Number and I'm hoping to find a way of getting this automated. What I would like to do is, when a block of text is pasted into our template, a block of code to look through the selection and check column S for a valid format NI no (eg AB123456C). I have some code (below) that works when changing an individual cell, but nothing that works when pasting in blocks of text. Private Sub Worksheet_Change(ByVal Target As Range) stringvalue = Target.Value statuschange = 0 Application.EnableEvents = False 'Check for text only cells If Target.Column = 19 Then
View Replies!
View Related
Fill Series That Combines Data From 2 Sheets In Blocks Of 10
I have a spreadsheet with two sheets... Sheet1, and Sheet2, that I use as sort of a staging area to format info before bulk uploading to my product database. The products I'm working with at the moment have 10 subcategories below each of them. Sheet1 is the full product database listing. I place new subcategories in blocks of 10 that I plan to add to the database on Sheet2. Sheet2 also holds the default partial category names in cells A2-A11. Part 1: I am currently using the following formula on Sheet2, in column C to combine the category name value on Sheet1, with the default partial category name values on Sheet2 (A2-A11). I'll paste two blocks so you have a clear picture of what I mean by blocks of ten. =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$2) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$3) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$4) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$5) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$6) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$7) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$8) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$9) =CONCATENATE(Sheet1!B3407;" ";Sheet2!$A$10)..................
View Replies!
View Related
Numbering And Sorting The Data
I have a excel file which looks like the following:............. The file contains more than 25,000 rows. What I need is, I have to give numbering to the above including parent id no as well. The nesting level can go to a maximum of six. The result should be 1 Electronics 0 2 Sound & Radio 1 3 MP3 & Portable Audio 2 4 Mp3 Players 3 5 IPod 4 6 Nano 5 7 5GB 5 8 10 GB 5
View Replies!
View Related
Calculating Time Blocks
I am trying to calculate the amount of time in blocks, using a pre-determined spread. For example: AM block is anytime between 0600-1230 PM block is anytime between 1230-1830 Evening block is anytime between 1830-0000 and the Overnight block is anytime between 0000-0600 Sounds easy enough, yeah? Let me paint an example of how I want it to calculate though: If an employee starts at 0600 and finishes at 1400, then the AM total is 6.5 and the PM total is 1.5. If an employee starts at 1100 and finishes at 1900, then the AM total is 1.5, the PM is 6 and the Evening is 0.5. If an employee starts at 2200 and finishes at 0800, then all of the 10 hours must report to the Overnight total, even though some of them fall within the Evening and AM blocks. I just can't seem to get each block to show the accurate number of hours...and to bring in the rules that I require.
View Replies!
View Related
Add Names To Blocks
In a worksheet I have (not equal) blocks of data. In column A there is the projectnumber, in columns B-K there are data. Projects are devided by an empty row. All rows in some block have in column A the same value (projectnumber). What I need is the following: I would like to add names to that blocks. The name must be equal to the projectnumber.
View Replies!
View Related
Remove Blocks Of Rows
I have a worksheet that collects information from another using complex formulas. In column A I have codes i.e. PRD001A, PRD001B etc. A block of codes starts at A and can go up to Z. i.e. PRD001 could start WITH PRD001A and finish with PRD001N then there is always a PRD001W and PRD001Z to finish with. PRD002A would follow PRD001Z and might only have A, B, W & Z codes before PRD003A. In column K is the sum of columns D:J. What I want is a macro that will look at column A & K and if all OR some of the codes for say PRD001 are >0 don't delete any of the rows for that group of codes. Then look at column A & K and if all of the codes for say PRD002 =0 delete all of the rows for that group of codes.
View Replies!
View Related
Working With Time: Blocks Every Whole Hour
I have a spreadsheet that users input the temperature each hour, for a 24 hour period. The time used is 24hr clock, as example, cell A1 will be 03:00, and cell B1 would be the forecasted temperature. On another sheet, the user inputs the temperature for the specific time a airplane is going to take off, i:e: 07:32. Is there a way I can have the second sheet look back to the first sheet and grab the temperature for the correct time (using the hour block it falls into). The first sheet time blocks are every whole hour, i.e 08:00, but on the second sheet, the time could be any hour/minute, 07:32.
View Replies!
View Related
Counting Blocks Of Highlighted Cells
I have huge sheet with time periods across the top and accounts listed down. I have manually shaded cells red that represent "new" sales. I have used the custom function "colorfunction" to count these red shaded cells in the past. Now, I am trying to count blocks of cells. Each block is a different # of cells and represents sales $ over a different period of months. I want excel to count each block (start to end) ans add them up... I can SEND THE SHEET IF YOU WISH.... J F M Ap M.... acct 1 acct 2 acct 3
View Replies!
View Related
Summing Uneven Blocks Of Rows
I am trying to Sum "uneven blocks of rows" using the Sum Function.This works OK for the 1st.Block,but then the selection of cells moves down the same number of rows as the 1st Block. I am attaching a sample file which best explains what I am trying to achieve.
View Replies!
View Related
Copying Blocks Of Rows Into New Worksheets
What I'd like to do is to have the block of rows starting from "Agent:" and ending with "Total" copied into a separate worksheet and then have the worksheet named using the agent's name. I have highlighted the data in yellow in the attached reference file. I would like to have this done for all 58 agents. I could copy and paste manually but that wouldn't be the smartest way to go about this. I figure I probably need a looping structure for this but I am not yet proficient enough to figure this out quickly. I am supposed to have this done today. Edit: The last part of this would be to have blocks of rows from the "sections" worksheet which use identical agent names also pasted below the data from the "questions" worksheet. I have attached the workbook I am working on now cutting and pasting manually.
View Replies!
View Related
Insert Rows Between Blocks Of Information
I have used some code that Kris gave me a couple of weeks ago and changed it to insert a row between each block of information. Have I got it right? Sub InsertRows() Dim lRow As Long Dim r As Long lRow = Range("A" & Rows.Count).End(xlUp).Row Application. ScreenUpdating = False Columns("M").Insert [m3] = "temp1" Range("M4:M" & lRow) = "=LEFT(A4,5)" For r = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If Cells(r, 13) <> Cells(r - 1, 13) Then Rows(r).Insert Shift:=xlDown Next r Columns("M:N").Delete Application.ScreenUpdating = True Application.DisplayAlerts = False ActiveWorkbook. SaveAs Filename:= _ "H:HOME imcEXCELCOUPON_COUNT5_MAYREFORECAST.xls", FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Application.DisplayAlerts = True ActiveWindow.SelectedSheets.PrintOut copies:=1 End Sub
View Replies!
View Related
How To Copy Blocks Of Formulas Or Conditional Formatting
Lets say I have a block of cells (lets say A1:E5) that all reference the value in the upper left hand cell (A1). Could be a formula by itself or one embedded within a conditional format. I reproduced the formula and formats in the A1:E5 block by using the absolute cell reference $A$1. I now want to reproduce that entire block (including the referenced cell A1) multiple times on the sheet, but the catch is that each new block must reference the cell in IT'S OWN upper left hand corner. (e.g. a block located at F10:J15 must use as it's reference F10, not A1). How can I quickly reproduce those blocks? I have done a search and replace to eliminate the $ symbols within the formulas to make them relative, but that doesn't seem to work within conditional formats. The issue right now is I am trying to apply conditional formats to a sheet I already constructed. I don't want to overight the formulas in the UL corner, so I am trying to copy and paste the conditional formatting only. Can't seem to figure out how.
View Replies!
View Related
Sort Info In Column Into 50 Row Blocks
I have a sheet with about 1000 rows of data filling 40 columns. the data is the same in column 1 for a random number of rows between 2 and 40. ie as here... 2 2 2 2 33 33 33 4 4 4 4 4 4 etc. Is it possible with a macro to divide the sheet into blocks of 50 rows each with just the data before it changes to a different no. so that it looks like this 2 2 2 2 46empty rows here.......................
View Replies!
View Related
Split Address Blocks Across Multiple Cells
I have cells of block addresses that are delimited (tab I believe - there's a small square that appears). I need to split the addresses out into separate columns for each line of address. I tried using the Text to Columns wizard as suggested by Excel Help, but ended up with only the first line of address being posted in the cell to the right (the rest of the address was nowhere to be seen). I'm sure I've done this before but can't for the life of me remember how I did it.
View Replies!
View Related
Rearrange, Move Blocks Of Cells To New Columns
I saw a post that needed a solution for moving blocks of cells in order to get fewer rows but more columns. The post is gone but I'd like to think my work wasn't in vain as the algorithm was more difficult than I thought. The problem was wanting make a 5000 X 4 grid into a 1700 X 12 grid, 55 rows and 4 columns at a time. This is sometimes done for visiblity or printing purposes to get more data going across instead of down. An example would be wanting to have more data accross on a print page and the page holds 55 lines of data. For example, A56:D110 would be moved to E1:H55, A111:D165 to I1:L55, A166:D220 to A56:D110 etc. The code is somewhat generic so different blocks of rows and columns can be specified. To see this code work, enter the number 1 in columns A-D, then fill series -> step by one for a thousand or so rows. Then run the code. Sub FewerRowsMoreColumns() 'Rearranges blocks of cells so the end result is more columns and fewer rows Dim RowStop As Long Dim ColStop As Integer Dim RowStep As Long Dim ColStep As Integer Dim RowOffset As Long Dim rw As Long Dim col As Integer ColStop = 12 'Enter the last column number you want the cells moved to RowStep = 55 'Enter the number of rows you want to move at one time ColStep = 4 'Enter the number of data columns you are starting with.....................
View Replies!
View Related
Random Numbering
I have a list of names in Column A going from row 2 to 15. I want to randomly assign them a number ranging from 1-14, but that random number can not be assigned twice. I only need each number once. I am putting the formula in column B.
View Replies!
View Related
Auto-Numbering
i have formulas in a range L5:L15 which sometimes return some value and sometimes zero. i want to give them auto numbers in column M in a way that it should only count the cell which has some value. suppose formula in L5 returns some value, L6 also then L7 & L8 have no value(but formula persists), cell L9, L10, L11 has values then L12 has no value L13, L14 has value and L15 has no value (but it has formula in it) values in these cells changes and some goes to zero and some return values. now i want to give them Auto Numbers in a way that cells with some value should only be considered.
View Replies!
View Related
Numbering In Forms
I have created a form to input parking ticket data to a spreadsheet, it all works exactly as i want it to, but i really need it to tell me the next available number or empty line, so i can use that for filing and audit purposes, ideally i would like it to do sequential numbering, but i've been looking for weeks and cant find a soloution, i have basic knowledge of VBA and i'm really struggling with this,
View Replies!
View Related
IF Statments And Numbering
Heres an example of what I'm trying to do, if I select form a list a certain name (i.e. "Plt") then I want it to populate a list of numbers (1-102) and the same with "SO" populating numbers 1-119. and here is what I have so far =IF(OR($F$1="Plt",$F$1="SO",$F$1="Plt LR",$F$1="SO LR"),"1.") Is there anyway of making excel do this?
View Replies!
View Related
Numbering System
Wondering if there is a formula for Excel that could replicate a numbering format like in Word? Example: A1.1. A1.1.1. A1.1.2. A1.2. A1.2.1. A1.2.2. A1.3. and so on... Idealy I would like to go farther than the 3rd level.
View Replies!
View Related
Numbering For Coordinates
how to get a single cell (C2) and (D2) to make the numbering format go from (## ## ##) to (######). The Excel spread sheet is a coordinate converter, designed to take Degree's minuets seconds and convert it to Decimal Degrees, the formula is set up and work Great, but every time I copy and paste the coordinate to the excel spread sheet, i have to manuelly erase the spaces between the numbers so the formula can work properly. How can i get the cell to automatically delete the space between the numbers to save me time.(I.e 29 35 42.34325 -to-> 293542.34325)
View Replies!
View Related
Numbering Macro
why the Macro below works fine when the spreadsheet is not filtered, but once you filter the spreadsheet it does not work. and if possible a solution. Sub Count() Dim MyInput As Integer MyInput = InputBox("Enter Start Number") MsgBox ("Start number is ") & MyInput mycount = Selection.Rows.Count MsgBox mycount ActiveCell.FormulaR1C1 = MyInput For Num = 1 To mycount ActiveCell.Offset(1, 0).Select ActiveCell.FormulaR1C1 = MyInput + 1 MyInput = MyInput + 1 Next Num End Sub
View Replies!
View Related
Sequential Numbering
I have a workbook with two worksheets. Worksheet #1 is a form that will be populated with data and saved as a new worksheet, then cleared and used repeatedly as a master form. Worksheet #2 is a log / register of the unique forms completed and saved from the master each time. I need to assign a unique sequential # to each form when it is saved and record this number in a column on Worksheet #2 (the Log). I am using some macros for the copy work but struggling with the auto-numbering of the forms when completed and saved.
View Replies!
View Related
Numbering By Group
i have items listed in groups and need to number them 1111 1111 1111 1222 1222 1222 1222 1444 1444 in the column beside this i need these items to be numbered 1 1111 2 1111 3 1111 1 1222 2 1222 3 1222 4 1222 1 1444 2 1444
View Replies!
View Related
Numbering A List
I'm trying to make a sequential resultlist starting with nr 1, 2, 3, etc under the column: Rank ? This should be part of a macro, so autofill is not an option... As you can see, the number of rows are different from each group, and starts with nr 1 for every group. (Some formatting became all wrong posting this.........
View Replies!
View Related
Sheet Numbering
I'm wondering if this is the way things work and there's nothing to be done about it (but I doubt that). I have a workbook that I load data into from a csv file. The csv file is "divided" into regions, and I want each region's group of data to be loaded into a separate sheet. To be on the safe side, I delete all the sheets before loading the data with the following code that I found in this forum Sub delete_all_sheets() Dim sh As Worksheet Application.DisplayAlerts = False For Each sh In ActiveWorkbook.Worksheets If sh. Name <> ActiveSheet.Name Then sh.Delete End If Next Application.DisplayAlerts = True End Sub Then, for each new region, I create a new sheet with the following code On Error Resume Next sheet_nr = sheet_nr + 1 Sheets(sheet_nr).Activate If Err.Number <> 0 Then ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count) End If On Error Goto 0...............................
View Replies!
View Related
Insert Conditional Horizontal Page Breaks Around Logical/Visual Blocks
I run a report that has several blocks of information with blank rows separating them. The blocks change from time to time and across pages so they are not always in the exact same rows. I'd like a macro that can insert page breaks around a certain number of rows (say 60), but not insert one between two rows that have any content. If the page break would fall between two filled rows I'd want it to go to the nearest blank row instead. The pages would be about the same size but the blocks of information would not be broken up. That's my idea, anayway. I don't know VB so I can't be sure it's even possible. Provided this is possible, I'd greatly appreciate the help, as would all the other people in my organization who have to do this on a daily basis.
View Replies!
View Related
VBA Macro To Copy Blocks/Areas & Append To Another Worksheet
i am making a spreadsheet for recording employee telesales activity each day. administrators will update a shared workbook each day with the information employee names are across the top and the activities are down the side (calls, CVs sent, interviews, meetings) each day has it's own block of data. on a friday I would like to run a macro to select these blocks and paste them into the first free row on a separate worksheet. i have something similar working elsewhere which copies one column and pastes that into the last free column of a new sheet but i have no idea how to do it for rows going down a page. I have attached a file example to clarify.
View Replies!
View Related
Restart Auto Numbering
I have just successfully added a code to Visual Basic in order for it to insert a sequential number automatically upon opening the worksheet. It works great, but how do I restart the numbering now that I know it works?
View Replies!
View Related
Auto Numbering A Tag Name
I would like to know if there is a way to Auto number a text. I have a column with text tags (lets say Column B). These cells look at a specific cell (ex. A1) and see what text is written in it then copy the text into their own cells B1, B2, B3 and so on. So if cell A1 reports AAA then Column B cells become AAA all the way down. Now what I like to do is for column B cells look at A1, copy the text and add _01 infront of their copied text. so for Column B, B1 reports AAA_01, B2 is AAA_02, B3 is AAA_03 and so on
View Replies!
View Related
Insert Bullets And Numbering
Is it Possible to Insert Bullets and Numbering in Excel. Especially Bullets And what is the Easiest way to insert Bullets. Sheet2 ABC1ItemsWant this2BindersŲ Binders3Pen SetsŲ Pen Sets4PencilsŲ Pencils5BindersŲ Binders6BindersŲ Binders7PenŲ Pen8BindersŲ Binders9BindersŲ Binders10BindersŲ Binders11PenŲ Pen12PencilsŲ Pencils13DeskŲ Desk14PencilsŲ Pencils15BindersŲ Binders16Pen SetsŲ Pen Sets17BindersŲ Binders18BindersŲ Binders19PenŲ Pen20Pen SetsŲ Pen Sets21PencilsŲ Pencils22PencilsŲ Pencils23BindersŲ Binders24DeskŲ Desk25PencilsŲ Pencils26Pen SetsŲ Pen Sets27BindersŲ Binders28PenŲ Pen29BindersŲ Binders30PencilsŲ Pencils31BindersŲ Binders32PencilsŲ Pencils33PencilsŲ Pencils34PenŲ Pen35Pen SetsŲ Pen Sets36BindersŲ Binders37Pen SetsŲ Pen Sets38PencilsŲ Pencils The "Ų " Indicate Bullets that means " Ų in Column C
View Replies!
View Related
Auto Consecutive Numbering
I have a form that I use often, but numbering is slow because I go in and number the form, print, go back and put in next number, print, etc. Is there a macro or formula that will automatically update the consecutive numbers when I enter or print?
View Replies!
View Related
Quick Auto-Numbering
Auto-Numbering just an example:- 56 57 58 59 60 The Column above is the first column on a selected sheet. i will select 56 and from there (End-Shift+Down arrow) which selects all the values from 56-60... My question is from here on if there is a shortcut key or 'vba macro' that can autonumber from 1. Thus giving output result of.. 1 2 3 4 5 i want to record the solution for above problem in a macro recorder for different numbers that is why i have to do (End-Shift+Down arrow)
View Replies!
View Related
Automatic Numbering In VBA Etc
I'm trying to create a bug reporting tool (with a bunch of text boxes and drop down lists) and have the following problems... 1. I would like to get a unique number inserted automatically in a textbox (it's supposed to be the bugs id (1001). How do I do this? And when I click OK after inserting all info I want this number to become +1 so the next defect can be added immediately. 2. Why are my drop down lists empty as default and their values only appear if I enter a value. Why aren't the lists displayed when i just click on them? 3. I have a multipel row text box. How do I get the text to jump to the next row automatically instead of using crtl + enter?
View Replies!
View Related
Duplicating A Row And Numbering?
I've been given an excel file with 75 addresses (1 address entry per row) and I have to make 150 copies of each address while also numbering column D for each row 1-150. So in the end it would go from: (sorry for the periods.. extra spacing didn't work!) A........B................C.......D AAA...123 Street...City...<blank> BBB...456 Street...City...<blank> CCC...789 Street...City...<blank> To: A........B................C.......D AAA...123 Street...City...1 AAA...123 Street...City...2 AAA...123 Street...City...3~ AAA...123 Street...City...150 BBB...456 Street...City...1 BBB...456 Street...City...2 BBB...456 Street...City...3~ BBB...456 Street...City...150 CCC...789 Street...City...1 CCC...789 Street...City...2 CCC...789 Street...City...3~ CCC...789 Street...City...150 I don't mean to be lazy and just ask for a macro code, but I'm a complete excel novice and just looking for a quick and easy fix rather than copy/pasting these entries manually.. edit: this file has a deadline for it, which is the reason for the quick fix not to just get out of learning how to do it I've tried to make a macro consisting of inserting a row, copying a row then pasting it, but that only worked for the first row that I'm duplicating.
View Replies!
View Related
Automatic Sheet Numbering
I have a report blank that is comprised of numerous excel worksheets (fixed letter size). During the completion of the report, one may add, delete, and/or move worksheets. I want each worksheet to have a cell that dispalys 'page # of total number of sheets'. Is there a way to automatically update this information?
View Replies!
View Related
Sequential Numbering Macro
I need a macro that will number a cell (A1 for example) starting with the number 1, and another cell (A2) with the number 2, then back to the first cell with 3, then back to the latter cell with 4 and so on.
View Replies!
View Related
|
TRACKER
