delet columns and rows

  1. R

    Generate dynamic templates with varying mandatory and non-mandatory fields depending on the product type chosen.

    Hello Everyone, I am trying to generate an All-in-One sheet which will auto-populate templates as sheets based on the product type chosen. Currently, we share a single Google Drive folder containing 450 templates, and they chose which to download and enter values. Each of those excel files...
    • RajK2005
    • Thread
    • copy sheet and rename data valadation delet columns and rows highlight data valia template new sheet vba
    • Replies: 1
    • Forum: Excel Questions
  2. F

    With...

    Hi, I want to delete one column. Generaly It could be done like: Columns("AY:AY").Select Selection.Delete Shift:=xlToLeft But how to do it in "With...." With sourceWb.Sheets("Sheet1") .Range("A1:B6").EntireRow.Delete LastRow = .Range("CW65536").End(xlUp).Row '....delete...
    • Forestq
    • Thread
    • delet columns and rows with selection with statemet
    • Replies: 5
    • Forum: Excel Questions
  3. A

    Macros need whole line moved to new worksheet automatically

    I want to create a macro that when date is inserted into certain cell, have the whole line moved to a new worksheet, and re move from original sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> attempted to create the formula, but...
    • aboyal
    • Thread
    • copy and paste cells delet columns and rows macros
    • Replies: 12
    • Forum: Excel Questions
  4. M

    Need to remove multiple unique groups of numbers

    I am looking for an if then formula that will help me remove groups of data from sheet 1. I added sheet 2 which only has 1 column of unique id's that I want removed from sheet 1. In sheet 1 there could be multple rows that have the id that was found on sheet 2. Does anyone have a formula that...
  5. S

    Delet columns and rows

    dear sir, i most of the time use excel. i want to know that, i want to keep columns from A to H and Rows from 1 to 55. i want to delete rest all columns and rows and it should not generate the columns and rows again and again. pl, help me thanking you shrikant

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