new row

  1. M

    Drop down list to populate next drop down list and then auto add row after selection

    Hi all, I want to create a sheet where there will be a drop down list on first column and a second connected to first one on the next column. Once I select a value on the first one, I want the next column to bring up the relevant drop down list from predetermined values ( essentially the first...
  2. D

    Insert row below named range while extending that range

    Good evening all, Question... (obviously) Is there a way of making a VBA to insert a single row below the last 'Dep' 'C:C' while extending the range, "B4:J8" has been named "Third_Party", "B9:J10" = "QC", etc... While the formulae in "D8:J8" (also in the named range of Third_Party) would just...
  3. P

    Create a new line for each match instead of concatenate

    I am using a vba code that compares column "C" on two work books and concatenates the matches found onto one cell. I need to be able to add the first match to the existing row in workbook1 and then create a new row for each match instead of concatenating, copying over columns "B", "C" and "D"...
  4. M

    New row isn't being added onto my table

    Hi there, I have a spreadsheet which uses a userform to enter data on to a sheet called "Readings". Everything seems to work fine except for a couple of things: - It misses out the first available line in my table - My table does not expand to encompass the new line I have checked my...
  5. C

    VBA Copy and Paste with If statement

    Hey guys so I am having a issue getting my VBA to recognize my if elseif statement in macro. I want it to read the value of a cell and if the cell is not blank then copy the entire row say A45 to S45 and then copy it, go to a different sheet, insert a new row after the last row of data, and then...
  6. C

    Copy one row from one sheet and past into different sheet on next blank row in a given range in VBA

    Hey! So I have been looking everywhere on here and cant find anything that helps my problem to do excactly what I need it to do. I have been trying to find any types of macro code that allows me to copy the row from one sheet, an the data in this row changes periodically, to a seperate sheet...
  7. M

    VBA to add a new row in reference to a specific row/cell

    I have a worksheet that has my companies action items and client action items. I have macros that add new copied rows with conditional formatting and formulas. The macros I have work but they add a new row under a specified row (18 and 29) which obviously causes issues if I add 4 or 5 rows to...
  8. dannyok90

    The Classic 'Add New Row Button' Macro

    Hi Guys, I'm aware there is tons of information on the net about this and I'm sort of biting the bullet asking such a generic question. I have a spreadsheet which is a template at the beginning of its life so there is literally no data in there what so ever. I'm wondering if someone could help...
  9. H

    Add a new row at table bottom

    Hi, I need your help with a code that will add a new row at the bottom of the table. The code is working but i need to add on this new row in "H" column the Application.UserName and on "F" column the Date. This is my code until now: Sub Insert_New_Rows() Dim Lr As Integer...
  10. S

    Add new row and copy the formula from the above cell

    Hi, I have a macro that currently populates a table for me at the click of a button: In Columns G, H and I (on the Job Database) there are formulae, what can I add to the macro above so that the formulae automatically populate when the other information is added. I have tried converting it...
  11. P

    Insert new row with data

    I want to insert new row with data from textboxes in userform. For example, before clicking on button in userform Sheet1 loooks like this: <tbody> A2 NAME PRICE A3 GROUP 1 X A4 GROUP 2 X </tbody> But after clicking button on userform Sheet1 I would to achieve this: <tbody> A2...
  12. M

    Compare two sheets with rows inserted and data upated

    Hi Everyone! I've been working on this problem for a while and I still can't figure it out. Essentially I will be taking a snapshot of data, and then comparing it to new data months later to find out what changed. I need a <acronym title="visual basic for applications" style="border-width: 0px...
  13. P

    Expand table with a row when pivot updates and expands

    Hello, I have been looking for answer in the forum but can't seem to find it, or maybe can't formulate search properly. In any case, I would appreciate your help with automating the excel sheet. It is not a formula specific question, so if you have a better workaround for the whole thing let me...
  14. R

    Inserting rows then deleting data but leaving formulas and formatting

    Hi This is my first post and am new to using code in excel sheets. I have a spread sheet that is keeping track of requested report from 3rd parties. This sheet will need to be password protected as multiple users will have access, so i am trying to sort out a macro that will allow some one to...
  15. R

    Inserting rows then deleting data but leaving formulas and formatting

    Hi This is my first post and am new to using code in excel sheets. I have a spread sheet that is keeping track of requested report from 3rd parties. This sheet will need to be password protected as multiple users will have access, so i am trying to sort out a macro that will allow some one to...
  16. N

    Force the workbook to save after data entry

    Hi, I have a table that is being used as a log to record safety tests on our products. Each row is a new test (with a unique ID number in column A), which will be edited on multiple occasions upon completion of various tasks, including raising the request, producing the item and performing the...
  17. M

    Separate Comma values in the cell and replacing in a new row by copying the original content

    I want to split the content in a column (Vendor 1, Vendor 2, Vendor 3) into different rows. <colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody> Name Type Name Vendor 1 Vendor 2 Vendor 3 Manager Available Apple 1 Kashmir Padma whole sale Fruit Junction; Juice corner...
  18. C

    Sub called from another workbook (Insert new line)

    Hi everyone, I'm trying to call in the parent Workbook (test) a sub in another Workbook (test2). This sub is supposed to insert a new line the test2. That is where the code is originally located. If I run the code seperately it works fine. If I try to call it from test, it doesn't. Do you have...
  19. A

    New Lines in Tables have Cell Styles

    Hello all! I've got a small issue on Excel 2010. I have created a table and some custom cell styles. I've noticed that each row I create in said table, copies the custom cell styles of the first row I ever created (that row now contains different cell styles, but the cell styles being copied...
  20. K

    Macro to copy data from sheet1 to sheet2 based on a criteria.

    I have two sheets. First sheet contain this information. BANK ACCOUNTS <tbody> COMPANY ACCOUNT BANK STATUS 0001 12584563 BARC LIVE 0002 12865845 HSBC LIVE 0002 45864856 HSBC CLOSED </tbody> I want the second sheet to bring row automatically when status in the above table is...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top