find & insert

  1. M

    Copy items from sheet1.range(X:X) to next empty cell in range located in Sheet2.

    As the title says I have a sheet1 and sheet2 where I neeed to check if in range H193:H271 item count is more than 0 and if yes, then copy this value + two offset values to the left, into sheet2 in empty cell in range B11:B30 and C11:C30 and if that range is full then copy those values into...
  2. V

    VBA - Press button of find all inside find dialog box

    Hello guys, firstly i want to sorry my English, because i'm not using the translator. I hope you can understand what I writed. So, i maked a macro that open the find dialog box and search for the word "lote". My macro: Range("A1").Activate SendKeys "^lLOTE" Range("A1").Activate...
  3. J

    VBA SELECT THE FIRST CELLS THAT CONTAIN TEXT AND SHIFT THE VALUE BELOW IN THE RANGE

    Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...
    • jhonatan321
    • Thread
    • cell columns excel find & insert insert move row select vba vba & excel
    • Replies: 0
    • Forum: Excel Questions
  4. 0

    Copy cell from sheet to sheet if first cell in row in Sheet1 is the same as the cel in unknown row in first column of Sheet2

    Hey guys, hope someone can help me. I'm trying to write vba code to copy a cell from sheet to sheet. I have a case where I want excel to find my typed word in cell A5 (Sheet1) on sheet2 of column 1. Then copy the row of the found word or cell next to the found word. I wrote the code, but it...
    • 09Tina
    • Thread
    • copy from sheet to sheet find & insert vba
    • Replies: 5
    • Forum: Excel Questions
  5. B

    Excel VBA : find PTS01 and do things in loop

    Dear beloved VBA enthousiasts, I've already tried my best to program the following macro on my own. I think my request is just too hard for me at this moment (because I've just recently discovered Excel VBA). My request is the following: So the macro must find a certain word (for example...

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