numbering

Hello, I am using a macro that creates a Word document and pastes data from Excel in it. I would like two things: 1)Paste the data without the table, but keep the formatting 2)make the pasted data have numbering in the Word document Could someone please help me with the properties to be added...

I have a DBFORMAT sheet where there are 6 types of DBs (Distribution boards) differentiated by headings in rows. There is an RADB sheet with a dropdown menu and “ADD” button. When I select the DB from dropdown menu and press ADD, the corresponding rows of item from the DBFORMAT is copied and...

Hello, Is it possible to synchronize the scrolling of three vertically aligned workbooks in Excel 2010 based not on the =ROW() value but according to some numbering scheme in column A of each workbook? For example, suppose you have three vertically aligned workbooks in (a single instance of)...

Hello everyone, I'm new to VBA coding and trying to create a loop to number years, months and days 1 to 9 based on a specific start date. <tbody> A B C D E 1 Year Month Day Day Name Date 2 1 1 1 Monday 22/09/1980 3 1 1 2 Tuesday 23/09/1980 4 1 1 3 Wednesday...

Hello,, I am trying to create an outline numbering list from a data table which look like below: <colgroup><col><col></colgroup><tbody> # of Criteria Numbering Category 4 1.1 3 1.2 4 1.3 4 2.1 </tbody> Result to be as follow: 4 1.1 1.1.1 4 1.1 1.1.2 4 1.1 1.1.3 4...

I have a list of to-do's and want to number them based on grouping. I would think this would be a fairly easy formula to build but my knowledge of Excel is limited. Below is an example of WHAT I WOULD LIKE (row 1 is the column this data can be found in; row 2 is the name of the column; row 3...

I would like to have one or more macros to be shared with anyone working on the similar worksheets. I would like it to create a sequence to read like the following example: ABC-0001 ABC-0001 ABC-0001 ABC-0002 ABC-0002 ABC-0002 ABC-0003 ABC-0003 ABC-0003 and, start from a higher number...

I have a two columns spreadsheet listing 1000+ items subjected to multiple revisions. The first column (A) contains ID showing the numbering and the second column (B) contains the item description. In the case when a certain item is to be removed, instead of deleting the entire row, I would...

I am having an issue when the numbering with my macro, when I get to 1.9 after it is 1.9 and it goes to the next row it just puts 1.1 It needs to be 1.10 Same when it gets to 1.19 it just goes to 1.2 instead of 1.20. Any ideas? Below is my code: Sub WBSNumbering() 'From...

I can't find a way to auto number and repeat numbering according to the repeated values in the other column like this: <tbody> 1 Mike 1 Mike 1 Mike 2 John 2 John 3 Tony 3 Tony 3 Tony </tbody> Please help. Thank you in advance.

Hello, I am wanting one macro to do the following steps: 1. Wrap text when cell is selected (this will be in column C all the time) 2. Adjust the height of cell to fit the wrap text (this will be in column C all the time) 3. When column C has something in it, in column A I want to place...

Hi, all. First time posting to this site but long-time lurker. I need a formula to add a column to my data that numbers each customer's orders based on the purchase date. The table contains a separate row for each item ordered by a customer, so there may be several rows with the same order...

Hi everyone! I am currently working on a spreadsheet and I am facing some difficulties in regards to auto numbering. Basically i have a column which contains consecutive numbers, i.e. cell G9 contains the value 126, G10= 127, G11= 128, G12= 129....etc... so what i would like to do is.. when...

I am creating a userform where I initially ask the user how many irrigation zones they have. Once they enter that number, I would like to create records 1-X (let's say 12). I don't want to be able to add more zones than that. Is there a way to artificially limit the number of records a user...

Hi all, first of all, I am looking forward to a productive cooperation with all of you guys :) It's my first post, so let's get it up and running! My problem is the following: I would need a continuously, conditional numbering with a reset function. Let me give you guys an example for a...

Hi there, I am new to the group and was curious if anyone can help me out with a macro I need to create. I am trying to number rows based on a number in the header. However, I want to repeat a number a certain number of times until it moves on to the next number. To provide more detail...

Hi everybody I am working on a sheet for scoring KPI's in which I need to have a three-level outline numbering: Themes, sub-themes, and indicators. The format should be "1", "1.1", "1.1.1". I need to be able to use the data for pivot tables, so each row should include name and number of theme...

Hi, is it possible to count/numbering with two columns as its range? i wanted a numbering on the dates as shown below; the countif formula works but on one column only, how can i add the other column so it does not only count the date 1 column but also the date 2 column where the answer should...

I need the following help urgently, Please see if you can tell me what to do. I have 3 codes for 3 sales men, A,B and C Now everytime that they take expense reimbursement payments, I number the voucher as 1,2,3 and so on. Now the problem is the number here does not reflect the nos. of voucher...

Hi All, Im feeling kind of stupid right now, I have a code that numbers only the rows that contain a certain value. However when there is a gap i would like it to keep numbering. For example it number 1, 2, 3 then jumps a row and starts again at 5 when i would like it to be 4. Does anyone have...