new row

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. S

    Copying and pasting information using a form into next empty row on a different sheet

    Hi, I am struggling to copy some information which has been collected on a sheet called "course entry". I want to copy the information onto the next empty row on a different sheet called courses. I have tried to re-record this macro numerous times and it still just replaces the same...
  19. S

    Macro to copy formulas to newly added row automatically

    How do you auto copy formulas from row above to a newly added row?
  20. L

    VBA or Macro

    Hello, i have a project where i am pretty sure i need VBA but i am in the process of learning. basically i have about 20,000 rows of datas and text and i have how it is formated below. if there is more then one e-mail address in column B(which can be sepearted by either a space,comma,or...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top