new rows

  1. C

    split cells & copy across rows - what's wrong with my vba?

    Hi All! First up, new poster, and VBA isn't my best programming language. So, apologies if I've stuffed up something stupid -- I'm learning :laugh: Now, I've got a database full of rows of different cases, and I'm trying to split the cases so that there is only one "citing judge" per row. Each...
  2. S

    Dynamic Range - When new rows are inserted

    Hi, I've been searching to find a solution for my problem for about a week now. Can you please help me on this. I've a vba code to hide a number of rows based on a selection (Yes or No) in a cell. I've another code to add rows in a table above those rows. Every time a row is added in a table...
  3. K

    excel worksheet getting new data every month how to update formulas on new incoming data rows

    I have worksheet with column A,B , C, D, E , worksheet updates once a week through data connection to URL Column A,B, C, D are populated during refresh but column E is calculated column for instance =(B/C) what the best way to trickle down the formula to new rows every week automatically...
  4. E

    Help with building macro to create new rows and copy and paste cell content into new rows

    Hello, I have been manually doing a process all day long and I want a macro that allows me to highlight a row and do the actions automatically. Can someone on the board take a look at this and help me make a macro? The column looks like this originally: <tbody> Serial Date Title Name A Name B...
  5. G

    Insert new line on three worksheets

    I'm afraid that my VBA skills are minimum but I have been asked to create a sales order workbook that contains 4 worksheets, of which three are to contain order-lines. For each item sold, a sales person will enter a new row on sheet 1 and the same data is copied to sheets 2 and 3 but with...
  6. C

    Keep table row creation function in protected sheet

    Hi, I have a table in a spreadsheet so users just begin typing in the next blank row to carry down the formulas and validation data from the row above. However, when I protect the worksheet, the table new row functionality stops working. I have tried ticking / un-ticking all the protection...

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