multiple rows

Hello, well I have a UF working but each entry fills only one row, the problem is that I can't always place a single row of certain Item with a qty=4 (e.g.), instead I could need four rows with qty=1 each, or two rows with Qty 2, etc. (it varies according to the item). So I need a TextBox...

Hi, Is there a fast way to insert numerous rows at once. Eg, I want to insert 37 rows into the middle of existing data. Can I do this quicker than just inserting them all?

Hi I have an excel based Purchase requistion (PR) form which I am trying to transfer data to a master invoice log sheet The form is in 2 sections Top half containg date, Supplier Name , Currency, Cost Centre, Account Number The bottom half contains line number, description cost , cost...

Data is set up as such, with first row being titles: --A --------------B------------------ C----------------- D Blank0 ------Luxury Status -------Region--------- Region Flag ---------------Non-Luxury ----------Central ---------------Non-Luxury ---------- East ---------------Non-Luxury...

By way of explanation, I am going crazy breaking down some data that was compiled as totals rather than line by line. So..after each process type, I need to add 30 blank rows and then add the dates September 1 - 30, 2014 to those rows. And go through a lot of other manual stuff to normalize...

Hi, Would be great if someone could help me with the below request: I have a a large database of about 200 rows. I am looking to split individual rows into additional rows without changing the preceding cells. The below is an example: What I have: <tbody> Name Country Sector Industry...

Hello, After a couple of hours of Googling and checking out these forums I decided to register and ask for help. I need a Macro that will Copy/Paste a selection of cells (that could change) "N" times vertically, without changing the order of the pasted selection. I found a macro which ALMOST...

Hello everyone, I'm sure there is an easy solution to this but I just can't find what I need, can anyone help me please?! I have a table which contains headers of the same title RED and GREEN, as shown below (except the APPLES and GRAPES cells are merged with the cell on their right to give...

Hi All. I trying to make a chart in Excel grow dynamically based on a couple of user inputs. I have data from 24 months, but I want to be able to choose how many of these month to show, and which month should be the first month in the chart. I have followed this guide Chart the Last 12...

Hi there! I'm a beginner when it comes to excel but I found found these forums useful to do a few basic things when it comes to using it. After a while searching I could not find anything which I can do myself. I am look for a way to send out an individual email to a list (Column A) in my...

I'm using PowerPivot with Excel 2010 to try to create a report on Video Conference Unit usage. I've only been using Pivot Tables for a couple of months and this is my first foray into the fabulous world of PowerPivot. I thought I had overcome all my newbie errors (date grouping, in particular)...

Hi I am using MS Excel 2007 and I am trying to create a macro which will copy column E and paste the data in column E to the bottom of column D. However each week the amount of rows in these column with vary, they will always be the same amount of rows in column E as in column D but there may...

Hi, how would I perform the below using either formula or VBA? Thanks <COLGROUP><COL style="WIDTH: 48pt" span=7 width=64><TBODY> From ('Sheet1') To ('Sheet2') Position HC PA Position HC PA Test1 5 RIG1 Test1 1 RIG1 Test2 1 RIG2 Test1 1 RIG1 Test3 8 RIG3 Test1 1 RIG1 Test1 1...

The issue I am having has me perplexed and I can't seem to get it right. Maybe I have just been looking at it too long. I have a list of cells that are item numbered. These item numbers range from 1000 - 10000. Each item number contains data relevant to that item. What I am trying to do is...

Hi everyone! I have a problem that I hope someone could help me with. I need VBA code that copies data from Sheet3 (Range A1:G3) and past them into different rows in Sheet1. Which rows the data should be pasted in is determined by cell values in Sheet3, Column I. e.g. Sheet3; Cell I1 says 10...

I'm using a bar code scanner to enter information in a excel spreadsheet. In cell 2c I have a quantity of 19 so I need to be able to scan 19 tags and 19 serial numbers. My question is how do I get cell 2E (Tag_No) and 2F (Serial) to automatically split into 19 rows or any specified number of...

I would like to get your help on the following: I would like to create a calendar within excel that would be linked to a series of recurring events. Those events are happening every 15 days, and expected to occur for a period of up to 15 months (so 30 times in a row). We have about 1000 events...

Excel 2010 & Word 2010 I have a spreadsheet with 600 records (Rows). I am trying to populate a table in a word document from multiple records in spreadsheet as part of my mail merge. As an example: The first 40 rows need to be in the first document, the next 7 rows go into another...

Hi all: I have a spreadsheet with 5500 rows. I am looking to join certain rows by a unique identifier. My column layout is as follows: Account Name Current Investments foo1 PE foo1 FoHF foo1 HF foo2...

Greetings, I've got my massive project almost up and running (thanks in large part to the awesome help I've received here). One more hurdle to clear: I've got a master report, from which I'm looking up multiple lines from the database and dropping them into a finalized sheet. The records...