-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
loop and insert
-
S
Adding Cells in Column O based on value on Column K
I need help writing VBA code to add a cell within a column based on a value in another column. Basically, if cell "K2" is greater than 0, I want to run a code that would insert a blank cell into that same row (cell "O2"), which would shift the current contents in O2 downward. I would like this...- Shan C
- Thread
- insert cells loop and insert range shift cells down vba
- Replies: 1
- Forum: Excel Questions
-
A
Help with looping a copy/paste function in VBA
Hi everyone, have a situation that I'm wondering how to loop the action to save me some time. I have 340 assignments, every 3 cells is grouped into a new assignment. Assignment1= Columns B,C,D Assignment2=E,F,G Assignment3=H,I,J My issue is that I need to copy/paste the formulas for B5,5C...- arooney88
- Thread
- help me with vba loop a macro loop and insert loop code in cell vba - help
- Replies: 1
- Forum: Excel Questions
-
T
VBA: search and replace txt strings with multiple search words
Hi! So I have been pulling my hair our trying to figure out how to build a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250...- techgrl
- Thread
- loop and insert mac excel text string search vba & excel 2007
- Replies: 5
- Forum: Excel Questions
-
J
VBA loop to search every cell value from one column in another one
Hey guys, I would really appreciate some help with a VBA code that I'm trying to create. I have the following data in one sheet: <tbody> A B C D E F G H I J 1 Group Alias Fruit Qty Alias Fruit Group 2 Apples 23 ME Melons RED 3 Plums 23 MA Mango BLUE 4 Melons 12 GR...- jadox
- Thread
- adjacent cell fill loop and insert
- Replies: 13
- Forum: Excel Questions
-
C
Populate cells from list box drag/drop, can't find first empty row on worksheet
Hello, I am running Excel 2010 and Windows 7. I have been working on this project for several weeks and this problem has eluded me from nearly the beginning. See Photo I have a form with a main list box and several other list boxes. I drag and drop records from the main list box to the...- C4Vicious
- Thread
- drag and drop first blank row list box loop and insert vba & excel 2010
- Replies: 2
- Forum: Excel Questions
-
S
loop through all worksheets and add sums/formulas at bottom of each
I'm working on a macro that does two things. First, it will split data into multiple sheets (with each sheet based on the value of a specific column). Second, it will loop through all the sheets and add certain sums and formulas to the bottom of each sheet. I found a very helpful bit of code to...- strangebiscuit
- Thread
- loop and insert sheets
- Replies: 5
- Forum: Excel Questions
-
R
Macro to insert a row after every change in value and copying the data into new sheets
Hey All I'm am trying to figure out a macro to run that: I want to insert a row after every change in cell value in column W and copy the Separated data into new sheets. Ex: Column w A A A A B B B B C C C C i want all the a separator between A,B,and C and all the corresponding data of A,b...- rakesh933
- Thread
- loop and copy loop and insert
- Replies: 3
- Forum: Excel Questions
