new row

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...

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...

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...

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...

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...

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...

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...

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

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...

Hi everyone, I have a limited understanding of VBA but IM learning as I go :) The following code adds a new row at a given point (Based on a fomula in a column returning "1") The code works well BUT I want to merge this new row from column A to coulmn M Im not sure how to do this, (I dont want...

Hi all, I am trying to copy a row and then paste this on a row that the user has selected. Once this row has been inserted I then want to edit the formulas within each cell - This is where I am having trouble. Because the row will be different each time (as the data is pasted into the...

Hi everyone, I've seen some threads about this topic but can't find the answer I am looking for. I am running a Macros against a variable lenght file and at the end of file I need to insert a new row with data. For example, I would need the new line to have "Payment" for column A, "Detail"...

Hi, A sample spreadsheet of what I have is provided below: <tbody> ID NUMBER CHEMICAL NAME HAZARD VALUE 1 chemical a carcinogen recognized 1 chemical a Respiratory, blood, kidney suspected 2 chemical b immunotoxic, carcinogen suspected 3 chemical c liver, carcinogen recognized 4...

Hi, I want to add a 'link' cell when a new row is started. THe cell would open a PDF using the phone number as a file name. I have the code to create the reference (written in VBA in MS Access). I just need to auto add the button to open the macro. In Access I just add a field on the on open...

Hello Excel Experts, I am new to the forum. Anyway, I have a hard time describing this issue so I'm not sure if it has been posted previously. If you know of a thread, please let me know. We currently have a workbook where the users can employ selections via column filters. They would use...

Been trying for hours to figure this out. I receive 2 daily reports (same format/headers, unique entry numbers) but the info may be updated and new rows of data added. Master sheet columns A to Z show the report data, but columns AA to AZ contain static data added manually corresponding to the...

I am in the shipping industry and often have shipments from not so popular places. I am looking for a way that excel will identify the status as "active", recognize the origin city/state and create 3-5 rows with other predetermined city/states that I have placed on another spreadsheet. On the...

Hi. This is the macro that I currently have. As you can see it starts w/ rows(21:21), however, if row 21 is enter and you run the macro again, it starts again at row 21 hence copying down whatever is currently in row 21 to 22. I do not want this macro to do that. i want it to start at the next...

Hi there, In column A I have locality names (ranges from 5 to 20 localities) separated by a line feed (Alt Enter). Columns B to G contain a number or word that relates to the group of localities in column A. I want to split the localities into separate rows and copy the values in columns B to...

I am new to the VBA side of excel so basically I am a bit of a newbie. I don't know how to code in VBA yet but am attempting to learn. I am creating a dynamic spreadsheet to record my stock portfolio. I want to make a macro that creates a new row below Row 1 or above Row 2 (Always a new row in...