I need to copy a cell, insert a blank cell below and paste the contents into the new cell. I have a list of text and numbers in Column A. I need to double what is there and keep it in the A column, but i need to keep the copied cell contents directly below the cell it is copied from. Any ideas?
What I have:
TB1-I1_I:1/0
TB1-I2_I:1/1
TB1-I3_I:1/2
TB1-I4_I:1/3
What I need:
TB1-I1_I:1/0
TB1-I1_I:1/0
TB1-I2_I:1/1
TB1-I1_I:1/1
TB1-I3_I:1/2
TB1-I1_I:1/2
TB1-I4_I:1/3
TB1-I1_I:1/3
Where does A1 come from? What creates that first instance.
The physical way to do what you want would be this (Assuming, the operation in A1 is taking care of the variables within the cell)
Right click A1>Copy>Right click A2>Insert Copied Cells>Right Click A2 again and paste special Values.
Now you can make this a Macro and associate it to a button or have it update upon updating a specific cell... which is why I ask,,, where does A1 come from?
-If you think you are done, Start over - ELeGault
The entire list was created by others by manually typing them in, so I was only given one long list that i need to perform the function on.
I have not made a macro before, but wouldn't mind a 101 on how to make that happen. I have several of these lists with hundreds of cells each that need this function done on.
heh 101 would take a while - These lists? Are they single column lists or several columns wide. Is there a rhyme reason/pattern to the list in which you can just generate a formula to recreate?
Such as... the "What I need. If entering the first two into the cell this starts the pattern...
TB1-I1_I:1/1
TB1-I2_I:1/1
Then you can enter a formula in A3 and repeat/drag it down
When I do this I get this list....And it just goes on... so knowing your data is going to dictate best course of action as well as being able to recognize patterns if any.
Please Login or Register to view this content.
TB1-I1_I:1/1
TB1-I2_I:1/1
TB1-I1_I:1/2
TB1-I3_I:1/2
TB1-I1_I:1/3
TB1-I4_I:1/3
TB1-I1_I:1/4
TB1-I5_I:1/4
TB1-I1_I:1/5
TB1-I6_I:1/5
TB1-I1_I:1/6
TB1-I7_I:1/6
TB1-I1_I:1/7
TB1-I8_I:1/7
TB1-I1_I:1/8
TB1-I9_I:1/8
TB1-I1_I:1/9
TB1-I10_I:1/9
TB1-I1_I:1/10
TB1-I11_I:1/10
TB1-I1_I:1/11
TB1-I12_I:1/11
TB1-I1_I:1/12
TB1-I13_I:1/12
TB1-I1_I:1/13
TB1-I14_I:1/13
TB1-I1_I:1/14
TB1-I15_I:1/14
TB1-I1_I:1/15
TB1-I16_I:1/15
TB1-I1_I:1/16
TB1-I17_I:1/16
TB1-I1_I:1/17
unfortunately every cell is unique, i just happen to list a few that had a pattern.
so your plan is to key in every data point. Is this copy paste from a data source or Paper to PC?
my plan right now is to: add a row below A1, Copy A1 contents into A2, then repeat for A3, etc, times hundreds of times. Not fun.
The data source is paper, so I can't automate that part. Another person is giving me this list that they typed up.
Here are 2 options
Both will make a copy of the top record.
Option 1, Will automatically send the record down based on A1 update (Which means deleting the contents will also submit a record.
Option 2, Usually more user friendly. Will send the record down only when you click the button.
Test it out and let me know if this is where you were going.
Options.xlsm
If it is, make sure to mark as resolved -
ALSO, open up the visual basics to look at how this is working. Break it down line by line in the module to understand the SendDown code. Currently all of row 1 can be limited to a few cells or even just the A column. Also look at the Sheet 1. There is a Private sub that controls when to send the macro down.
Hope that is all you need
Enjoy
The function works for A1, but does not carry through for the cells below that, it only copies A1. Thats the same issue i ran into when i attempted to write a function to do this.
Im confused... you are asking to push everything down (Log what you put into A1)
Describe what you are actually trying to do please, because something is not clear.
You want to Enter data into A1, Then you want that data to do what? what I got was that it would copy that data and push it down one row, everything that was under it would also be pushed down. So this is not what you want?
No, I have a list of data in Column A, each of which is unique in its contents. I need to copy the contents of a cell directly below it, so that the end result is I have double of each cell, next to each other vertically, without deleting any other cells' contents. So if I stepped through the process manually, it would go like this:
1. Insert Row below A1, creating blank Cell A2
2. Copy Cell A1
3. Paste Cell A1 contents into Cell A2
4. Insert Row below A3, creating blank Cell A4
5. Copy Cell A3 (was A2 at start of this process)
6. Paste Cell A3 contents into Cell A4
Etc forever.
Example:
I have this:
TB2-I16_I:1/15
TB1-802_802
TB3-I17_I:2/0
TB3-I18_I:2/1
etc to the end of the list.
And I need it to look like this:
TB2-I16_I:1/15
TB2-I16_I:1/15
TB1-802_802
TB1-802_802
TB3-I17_I:2/0
TB3-I17_I:2/0
TB3-I18_I:2/1
TB3-I17_I:2/1
etc to the end of the list.
Right - so im not sure how that would look in VBA... so I would work around it with some formulas... Copy your list into B1 of OriginatingList tab. Then on Output you will get a doubled up list on the Output column B
Duplicate.xlsx
Awesome! Thank you very much. How do we give thumbs up or congrats on this forum?
You can click the Add Reputation to show appreciation and then mark as solved!
Glad that worked for you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks