Duplicating A Row And Numbering?
Mar 3, 2009
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 2 Replies
ADVERTISEMENT
Aug 12, 2014
Is there a simple way to duplicate a number according to a given value? For example, i want the input to be 8 and the number is 1 so the output would be 11111111.
View 3 Replies
View Related
Jul 15, 2009
I am trying to make an inventory cover page - that shows data of separate products on different sheets with the following;
Product
Date
Previous Total
Amount Taken
New Total
and occasionally there is a Re-issue of stock to the previous total.
This is at the moment an historical record as anyone can see the usage across the dates for any particular product by looking at the sheet. Each time there is a change to the inventory it is recorded on a new row. But what I am trying to do is to copy the last row of data from each sheet to the cover page to show an overall inventory.
The part where I get stuck is making the selection of the last entered row of data [from each sheet] automatically updating the coverpage, when each sheet will get new data added frequently.
I thought about somehow making a duplicate of the last row and locking it in place and linking that to the coverpage - but I still do not have a clue on how to get it to automatically select the last row of the data.
View 7 Replies
View Related
Apr 23, 2006
I have attached a spreadsheet here showing when people have had squash coaching.
What I would like to do is have a summary section at the bottom showing how many sessions each person has had throughout the month, at which club.
So where a club code such as the "C" "N" or "NO" is used I would like to insert the person's name in the summary section at the bottom.
If the same person's name occurs again I would like to simply (that's the hard bit for me!) use one cell to continue to count his number of sessions - rather than duplicating his name over and over in a list, as would be done by using COUNTIF.
I'm well lost on how this might be done but am sure that it must be possible?
View 9 Replies
View Related
Apr 30, 2014
I am in need of duplicating a current workbook for others use such that when I update information in the original all those who have a copy of the duplicate will get the updates I have made. I have searched all over for linking workbooks together and I am familiar with linking cells and other small bits of information from other workbooks but in this case I want a duplicate workbook that is updateable from my source workbook.
View 5 Replies
View Related
Feb 12, 2010
I'm creating a KPI spreadsheet which utilizes named ranges to allow for Dynamic charting. I've created the first data input sheet for one of the 10 areas being KPIed. The sheet has 60 named ranges in it.
The goal is to duplicate the existing sheet (Area 1A) 10 times and adjust the named ranges and formulas within the named ranges according to the sheet names.
Is there a way to accomplish this without having to manually recreate or edit every named range for each new sheet?
View 6 Replies
View Related
Nov 29, 2012
I am attempting to duplicate data from the first cell in each row in Sheet1 to the first cell in 6 rows in Sheet2.
I want to do this for each row in Sheet1. For example, I want to take cell A1 from Sheet1 and copy what was in that into Sheet2 into cells A1-A6. Then I want to take A2 from Sheet1 and copy what was in that into Sheet2 into cells A7-A12.
Is there an easier way to go about doing this? I have too many rows in Sheet1 to do this by hand.
Edit: I know the formula for getting a value from Sheet1 and put into Sheet2 cells A1-A6: =(Sheet1!A1)
View 5 Replies
View Related
Apr 15, 2014
I'm trying to automate some documents we use on a regular basis so that we don't have to re-enter the same information over and over again. Basically I can get some cells to work and some will not. My first sheet is a contract. So I want Customer and Contractor info to show up on the rest of the sheets. I'm assuming something is messed up in the formatting of the cells but I can't figure out what.
So on my Job Book Cover Sheet I first want the GC's name and the code =Contract!G8 works perfectly. In the cell just under this one I want the Customers Name, but =Contract!C8:D8 (the cells on the contract with the Customers Name) returns #VALUE!
That said, the code =Contract!C8:D8 on my project detailer sheet returns the customer name like I want it to.
View 5 Replies
View Related
Dec 5, 2012
What exactly do I want to count?
I want to count how many unique serial numbers there are for a particular production error?
For example
Column A = Serial Number (which is too many are same) so won't the duplicated.
Column B = Error Message "Error"
Which formula can count's how many serial with error was encountered on the summary sheets.
View 3 Replies
View Related
Jan 21, 2007
The following code was supplied by Bill, but I want to do the same thing in B10:B164, where "x" is entered in B10 and the time stamp is entered in C10 & D10.
I tried copying the same script but had an Compile error message which said Ambiguous name detected: Worksheet_Change. The name of the sheet is Sheet 1 (Main)
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("M10:M164 ")) Is Nothing Then 'change your range on this line"
If Target.Value = "x" Then
Target.Offset(0, 1).Value = Now
Else
Target.Offset(0, 1).Value = ""
End If
End If
End Sub
View 5 Replies
View Related
Aug 6, 2014
I have a worksheet (Morning Reports) that has a running macro on what I need is how do I get this same code to work on a different sheet titled (Afternoon Reports) This afternoon report will be a scaled down version with slightly different range:
How do I modify this code to do the same thing just on a different sheet
[Code] ....
Protection password is "Financial3" and sheet and VBA
Attached File : New Morning Report - Master_Copy-NO DELETE.xlsm
View 3 Replies
View Related
Sep 27, 2009
I have two sheets, they basically contain shifts. They are laid out identically the only thing that changes is the date along row 1. In order not to have to recreate the workers from sheet1 onto sheet2 I use the following
View 2 Replies
View Related
May 4, 2009
I m writing a macro that will match duplicating cells in an excel spreadsheet. Here is an example.
BEFORE MACRO
id1 | example 1 | example 2 |
id2 | example 3 | example 4 |
id1 | example 5 | example 6 |
id2 | example 7 | |
AFTER MACRO
id1 | example 1 | example 2 | example 5 | example 6 |
id2 | example 3 | example 4 | example 7 | |
View 3 Replies
View Related
Nov 15, 2013
How to open a fresh workbook and have information automatically being pasted in, based on a checkbox trigger. I don't know if I have explained well or not but essentially it is this:
W5 is the checkbox with a tick and a cross. When the cell is ticked I want to specicy cells on this record to be brought over to another tab.
View 1 Replies
View Related
Jul 18, 2013
Im replicating rows which have multiple items in Column1. Im aware that the ID Column has duplicates..my source data is like that for now so I wont complicate it just yet.
Once ive got this working I can proceed to the rest of the tasks
View 9 Replies
View Related
Mar 19, 2008
This is my Excel dilemma: creating roundrobin pairs.
For a given list of numbers, I need to generate pairs where each number is paired with all the other numbers without creating a duplicate pair.
For example: 1,3,4,6... (dynamic)
Pairs: 1-3, 1-4, 1-6, 3-4, 3-6, 4-6
Results should be generated in two columns. Column A would be ID1, Column B would be ID2 (the combination of both would be the pair created)
ID1ID2131416343646
I have basic ideas for a macro but the loop within a loop and the OFFSET for the next row is something I really can't put together.
View 9 Replies
View Related
Jan 23, 2008
As a simple example, I have three columns (A,B,C). In both Column A and B they have single word text in them, but in Column C it is a paragraph of words that I format the cells to 'fill' so that it is all tight and concise when viewing the worksheet.
Afer I have saved the document and have closed it when I reopen the document. Cells from column C have randomly duplicated themselfs throughout the entire worksheet,but only onto columns A,B,C (where there is pre-existing text). As the random cells get duplicated it overrights the original text (results) as it does it, so once I open up a document and see this it is to late. this is a continual problem that I cant find a resolution for.
View 9 Replies
View Related
Jan 9, 2013
(Excel 2007), I have a template that I need duplicated for every reference. My Worksheet lists all the references and the macro use to duplicate a worksheet for every reference in the worksheet. The problem is when duplicating now, it duplicates the name of the template. For example, when the macro is ran sheet1= Template(1), sheet2= Template(2) ect.
Here's the code- I think it has something to do with the named ranges
Code:
Sub Macro1()
For i = 1 To Application.WorksheetFunction.CountA(Worksheets("Worksheet").Range("A:A"))
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Worksheets("Worksheet").Cells(i, 1).Text
Next i
End Sub
View 4 Replies
View Related
Feb 15, 2013
I wanted to see if it were possible to combine multiple worksheets into one new worksheet, but without duplicating columns with the same heading, enabling the data to fall into the correct column if it's shared in multiple worksheets, and adding columns if their unique. Furthermore, if there are a few "leading" columns, i.e. ones that are shared in every sheet and never move from where they are, to include those as the leading columns in the new sheet. I'm unable to post an attachment, but I'll try to paint a picture. This is on a much smaller scale than intended, but I want to combine Sheet 1 and Sheet 2 to form Sheet 3 (which I've manually copied to look how I would want it to look if the formula/code works properly). Columns A, B, and C are the "leading" columns I was referencing, whereas any of the following columns may or may not be shared in the various worksheets, but should still be included and combined if they're the same. There also might be a different number of columns depending on the sheet. I consider myself somewhat of an intermediate user, and I am familiar with using VBA codes for formulas should that be the proper remedy.
View 2 Replies
View Related
Sep 29, 2006
I am currently trying to add some functionality to an Excel workbook and I have a combo box that I am unable to get the values to populate. On the same worksheet I have a command button. Here is the code I am using to attempt to populate the combo box:
Private Sub cmdSendSave_Click()
Call SendSave
End Sub
Private Sub bxLocation_Change()
With bxLocation
.AddItem "Mt. Hope"
.AddItem "Summersville"
.AddItem "Huntington"
.AddItem "Pulaski"
.AddItem "Coastal Bend"
.AddItem "Odessa"
.AddItem "Wheeling"
.AddItem "Hollywood"
End With
End Sub
View 9 Replies
View Related
Mar 7, 2013
I have 2 columns,
column A has a series of 8 digit numbers (some will match some will not) sorting in A-z order from lowest to highest value.
Column B is blank at the moment.
What I want
In column B i need to add numbers starting at 1 and moving down in sequence.
If more than one rows have the same number in column A they get the same numbe rin Column B
It's really a pain or have to hand type in the numbers and I can't figure out a easy way to do this.
Attached example.
Tab 1 = Origanl Data
Tab 2 = results i'm lookin for.
View 2 Replies
View Related
Jun 6, 2014
I tried to search the forum for my unique problem but had no luck. As you will see attached, I have a series of excel buttons I need to duplicate and have target a different set of cells. I am hoping there is a way to avoid manually doing this.
The goal of the document is to push the button when both colours in the row and column interact (research on birds). There are two additional behaviours with an exact same set of buttons but they need to target "Body Rush" and "Food Displacement" tables underneath. I need all the buttons on one page since multiple behaviours happen simultaneously that need to be recorded.
I have something like 100+ modules in VBA I have created, I am hoping there is an easier way to do this so I don't have to create another ~200 modules in order to get the last two behaviours setup.
I am hoping there is either an easier button system or way to make buttons adjust somehow.
I am not the most advanced VBA user
View 6 Replies
View Related
Aug 22, 2009
I am trying to copy two cells from one worksheet to another in the same work book based on the value in Column B of one of the sheets. This is just a building block to a larger script I am going to create.
Below is my attempt but I keep getting an error at Range(Cells(x, 3)).Select.
View 7 Replies
View Related
Jul 16, 2013
It is for a calibration spreadsheet that I run that keeps track of when items are due to be calibrated.
It works at the moment and has populated my outlook with calendar entry and reminder 2 weeks before they are due - which is perfect.
The problem is when I update one of the calibration dates I will want to re-run the macro to create a new appointment - but this will duplicate all the appointments that already exist! very annoying since there are over 200 items.
Sub outlook_appointment()
Dim olApp As Outlook.Application
Dim olAppItem As Outlook.AppointmentItem
[Code]...
View 1 Replies
View Related
Oct 24, 2007
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 10 Replies
View Related
Dec 26, 2007
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 9 Replies
View Related
Nov 3, 2008
is possible to add a hyperlinked TOC (Table of contents) within a spead sheet (Excel 2003) like it is possible to do in Word. Also how do I go about sequential numbering of rows with sub numbering as shown below? Where if i add a row between 1.2.2 and 2 it would be 1.3.
1
1.1
1.1.1
1.1.2
1.2
1.2.1
1.2.2
2
View 3 Replies
View Related
Dec 18, 2007
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 12 Replies
View Related
Mar 6, 2009
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 5 Replies
View Related
Mar 25, 2006
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 10 Replies
View Related
