loop and insert

  1. 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
  2. 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
  3. 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
  4. 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...
  5. 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
  6. 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...
  7. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top