add row

Hi all, I have a macro giving me headaches.. Its goal is: 1. To copy 8 columns from 'Global List' to 'Front'. Global List sheet has some merged cells and Front sheet can't have them so as to be aligned with the rest of the info already there when I copy these columns. I use this code: Sub...

Hi I'm new to creating macro's! I've found some code that adds a new row below a specified range and I've got this working. However the issue I have is that I have created multiple macro buttons for each sub-element of the schedule and when I click "Add Row" and a new row is added to the...

Hi All I have a data set like this:- <tbody> Item Category Item Sales Shoes Sports Shoes 100 Casual Shoes 200 Others Sandals 300 Slippers 400 </tbody> I want a row after each unique value in column A along with unique cell value pasted in the new row. Like the below mentioned:-...

I have a spreadsheet with several hundred files, each has n number of images in it. What I need to do is insert a row for every image, below the original file. So I put the number of rows to insert into the main row, and would like to use that as the reference value. Like this: <tbody>...

Hello! I have lists of product information on a worksheet and I need to add Screws to an order if one of our products exists in the list on the worksheet. First, I need to find the part I am looking for in the column, sum the quantities and then add 2 rows to the last row with data...

Hi everyone, first post here. I'm new to macros in Excel but I've done some VB coding so they make some sense to me. Here's my situation: I have an Excel sheet that is linked to a SharePoint list. (I'm using Office 2007 and had to download the Synchronize Excel and SharePoint add-in to do...

Hi guys. I have a strange excel document that I need a bit of help with: The first sheet has a user input for just one thing - a "Project Code". When this has been entered by the user, I want the sheet to auto display an "expenditure item" and "value", looked up from the second sheet in the...

I have a very large spreadsheet that I need to add rows to. I would think a macro would work but I am kind of new to this. In column A I have a list of account numbers when the number changes I need a new row, is there a way to do this? Column A 175X105SELK 175X105SELK 20X14KMWA70...

Hi, I have quite a complex macro question to ask (at least in my mind anyway :rofl:), but seeing as though people on here like a challenge i thought i'd post it: First of all see screenshot of my spreadsheet for reference: What i am trying to do is to create separate macros to do the...

Here is my issue. I'm combining 3 spreadsheets into one. I would like for all the spreadsheets to update the one...including when rows are added to them. I have been able to link individual cells from one worksheet to another but that doesn't solve the problem of added rows. I wondered briefly...

I need to insert header files at top of each page break Setup as follows: ABC Company Payroll Pay Period 24 ending 11/21/09 Account Business Office: DEPT EMP.NBR EMPLOYEE NAME SHOP QTY 883 12345 CHICKEN LITTLE...