Adding New Columns And Moving Old Columns

Jul 19, 2013

Using VBA... I have Column N (eFIUnitRebate) which I want to swap with Column M (FFUnitPcnt)

Now with Column M as eFIUnitRebate and N as FFUnitPcnt I want to create an extra column (adjUnitCost) where Column N is and push FFUnitPcnt to become column O, etc.

Here is how the whole process should work:
Swap M and N
Insert new Column in N
Insert new Column in P
Insert new Column in Q
Insert new column in R

There is more information on the sheet after these columns so for all column inserts it needs to push whatever was there over.

So the layout is as follows:
J
K
L
M
N
O
P
Q
R

Units
UnitCost
UnitRebate

[Code] .....

These columns are thousands long, so I would like the formulas for them to be applied to the whole column as well.

View 5 Replies


ADVERTISEMENT

Lock Cell From Moving When Adding/Deleting Rows Or Columns

Jun 16, 2008

Will excel allow text to be permanently be positioned in a specific cell even if rows or columns are added?

View 6 Replies View Related

Moving Data From Two Columns Into Multiple Columns?

Feb 24, 2013

I have a large database of research data where the first column contains different categories (labelled as I, II, III, IV, V, and VI). For each row there is a data value in the second column that is numeric. What I need to do is move the data so that the data are displayed in 6 columns with the data values listed each column heading according to the category label. In the example I've shown there are 6 different categories, but the number of categories (and hence the number of columns in the final resulting sheet) will change for different data sets that I'm using. Also note the the number of cases for each different category is different (so that each column will not be even in terms of the number of rows of data under each column heading). I hope I've been able to explain what I'm looking for clearly.

I've attached a sample file showing the sample data input that I have on one sheet, and then the desired re-tablulated outcome on the second. I have done this using the auto-filter function and copy/paste, but this will take far too long for the larger datasets I'm working with.

View 2 Replies View Related

SumIf On Moving Columns

Oct 3, 2008

I am doing a SumIf function on some Imported data a follows "=SUMIF(FMEFactors!B:B,Long,FMEFactors!B:B)". Now, this is fine if the columns are imported in the same order but if Column B data gets moved to another Column the SumIF will give false information. I need to find the correct column to do the SumIF on.

View 3 Replies View Related

Concatenating Moving Columns

Jun 17, 2009

I receive a report which, amongst the other columns of data, has 7 specific columns with four digit codes on each row. I would like to find a way to concatenate these 7 columns into Column A, inserting a - between each code and adding -uu at the end of the last (7th) code.

I wouldn't be requesting assistance at all with this if the codes were always in the same column. Sometimes, they move 1 or 2 columns left or right depending on the additional (unwanted) data in the columns in-between. The column names, however, never change: Code 1, Code 2, Code 3, Code 4, Code 5, Code 6, Code 7

I was wondering if there was a way to still concatenate these columns into Column A but also take into account that the columns shift...

View 9 Replies View Related

Moving Rows Into Columns

Jul 13, 2009

I am trying to move row data into column data. Here is visually what I need.

Before:

After (one row of data only):

We are trying to import data into our accounting software but we can't until we get it into the right format.

View 9 Replies View Related

Moving Columns So That The Data Matches

Jul 21, 2009

I need to line XYZ to XYZ as well as the information attached to XY&Z
i dont really know how else to explain it but i was hoping there was a macro or something out there that i could use to do this would make it a lot easier

View 8 Replies View Related

Moving Rows And Columns With A Macro

Jun 5, 2009

I have a massive data file with thousands of lines of data. Each line is a pair, for example

View 6 Replies View Related

Moving Rows Up Into Columns Where Value Is Equal To

Jul 29, 2009

I am running through some old accounting documents in excel 2003 (originally from SAP), that contain information in row form that I would like in Column form. Column E indicates to me whether this was an invoiced amount or payment amount or "other." I have limited VBA exposure, but am fairly proficient at what I do know. This is just too difficult for me!

Where the "Assignment" #'s are equal, I need the script/macro to move "up" YP's, YQ's,

See Original Layout.jpg
Then What I'd Like.jpg
Then End Result

View 9 Replies View Related

Moving Data From Columns To Rows

Sep 24, 2009

I have the following spreadsheet with 4 columns of data:

1000001245aMr Fred Blogs
1000001270a1 Blog Street
1000001270bNorwich
1000001270cNorfolk
1000001270eNRx x99
1000001270gThe Manager
1000001270k01603 555 555
1000001270l01603 555 555
1000001270qManager
1000001270xN
1000001270yN
1000002245aMrs Fredilina blogs
1000002270a10 Blog Street
1000002270bNorwich
etc etc for about 36,000 rows.

What I need is for each unigue reference ID (column A),
I need all corresponding data moved up into a single row in serperate columns, something like this:

1000001 |245|a|Mr Fred Blogs| 270|a| 1 Blog Street|270|b| Norwich | 270|b|Norfolk |etc
1000002 |245 |a |Mrs Fredina Blogs |270|a|10 Blog Street |270|b|Norwich| etc

Each entry doesn't nessesarily have the same number of rows.

I would class myself as a beginner VBA bod, but the solution to this one is illuding me a present.

View 6 Replies View Related

Printing Columns Without Moving Or Copying

Jan 15, 2013

Without moving or copying columns I need to print Column A & Column I on the same piece of paper and not print Column B-H.

Every time I try this though it is printing column A on one sheet and Column I on a second sheet. Yes I've checked margins, etc.

This is actually possible, right?

(I didn't want to move or copy columns as the spreadsheet is for someone else's use, plus my formulas buggered when I tried to so I didn't want to add that complication for the other person of double checking the formulas every time she wanted to print this two column version of the sheet.)

View 3 Replies View Related

Spin Buttons - Moving Columns

Nov 21, 2007

ive seen a spin button used to move hole rows up and down.

what i would like to do is.

I use cells I9-N9-S9-X9

can i use a spin button to move collums?

how do i write the code, say if i select cell S9 and i want to move it to I9 using the spin button how do i go about that?

View 9 Replies View Related

Moving Data From Several Columns To Tabs

Jul 24, 2007

i have data that has several bits of information for each different account number.
is there a way of writing a macro to transfer the information from the main sheet onto different sheets automatically titled for each of the different account numbers?

ie. Account Cost
E1 £100
E1 £200
E2
E2
etc

i want different sheets for the info next to each of the account numbers

View 9 Replies View Related

Moving Data (Addresses) From Rows To Columns

Dec 12, 2008

I have address data all in column A (each paret of the address is on a separate row) which I need to move to separate columns on one row for each address:

ie:

Mr Bloggs (row 1)
123 The Avenue (row2)
The town (row 3)
The postcode (row 4)

Mrs Smith (row 6)
456 The street (row7)
The postcode (row 8)

needs to be: (I have used || to indicate different columns)

Mr Bloggs || 123 The avenue || The town || The postcode
Mrs Smith || 456..... || .......

The problem you see from the above is that they are not always consistent ie. the postcode (zip) isn't always 3 rows below the name for example. Also although generally there is a blank row between each record (this may sometimes be 2) and equally there may also be times when there is a blank line in the address.

Any ideas on how to do this.... I have 1000's of records and really can't afford to go through each one making it consistent before moving it to columns?

View 7 Replies View Related

Stuck Moving Columns To Rows - Transpose

Nov 2, 2011

I have following data on spreadsheet, which I need to import into other place but I would need to reorganise rows and columns first.

Product1-Sep2-Sep3-Sep4-Sep
SKU1112345
SKU22212131415
SKU3339876
SKU4444444

Basically I would like to have this data in 3 columns like this:

DateSKUOrders
1-SepSKU1112
1-SepSKU22212
1-SepSKU3339
1-SepSKU4444
2-SepSKU1113
2-SepSKU22213
2-SepSKU3338
2-SepSKU4444
3-SepSKU1114
3-SepSKU22214
3-SepSKU3337
3-SepSKU4444
4-SepSKU1115
4-SepSKU22215
4-SepSKU3336
4-SepSKU4444

I tried transpose etc. and not able to figure it out. Is this something that can only be accomplished with VBA?

View 2 Replies View Related

Moving Data From Single To Multiple Columns And Merging?

Dec 16, 2012

Current Data:
File 1:

Each set of data is listed in either two or three rows

Eg.,
ID
Date
Filename

ID
Date

ID
Date
Filename

The goal is to move them to separate columns (rows can be 3 or 2 for each data set, and may or may not be separated by space/additional row)

File 2:

Has a common field 'ID' as that of File1, does not have Date, and Filename, but has a new field 'Detail' (already in the expected format)

Eg.

ID Detail

The goal is to merge properly formatted data from File 1 to File 2

Eg

ID Date Filename Detail

View 14 Replies View Related

Searching Columns For A Month Then Moving Data To Userform

Mar 17, 2014

I have an excel spreadsheet where the columns have the 12 months of the year in Row 1. What I need is code that will find the month (from the column) which I select (via a listbox in a userform) and then go down that column and move the data that corresponds to that month to the userform.

So, If I select January from my userform, all data below January will then be moved to the userform and the same thing will occur with each month I select. I know how to move the data from the sheet to the userform, I just don't know how to match my data with the selected month.

View 3 Replies View Related

Moving Row Of Info To First Empty Row On Another Sheet Into Specific Columns?

Feb 20, 2012

[URL]

I have a workbook which serves as a master database at work. it contains two sheets: current residents of our facility (let's call this Sheet1), and those that have left/been discharged (Sheet2). It contains 87 rows and 34 columns of info.

I'm looking for a macro that will do the following:

When I click on a cell in any row (i.e. I need relative references) on Sheet1, the macro will (once activated):

1. Select the info between column D and column AH (inclusive) on the row where the selected cell is... i.e if I click on cell F4 before the macro is started, it will select the info from D4:AH4.

2. It will COPY this info

3. It will paste the info into the first empty row on Sheet2, starting from column C (i.e if the first empty row is 200, it will paste the info from C200:AG200)

4. It will then have a popup asking for: a. 'Date Left' and b. 'Reason', with two empty fields to input the info into. 'Date Left' is (obviously) a date value and 'Reason' is a text string. Once OK is hit on this popup, the Date Left will be pasted in column A of the same row (in our example, A200), and 'Reason' will be pasted into column B (again, in our example B200).

5. The macro will then go back to Sheet1 and delete the info that was selected between Columns D and AH inclusive (in our example, D4:AH4)

6. The macro will then save the workbook.

View 9 Replies View Related

Moving Data From Multiple Columns To Single Column

Mar 28, 2012

in moving data from multiple columns to a single column. I have attached a sample image from an excel file which details the requirement. The first column contains a qualifier, that should remain constant when the data from columns B to the end move to a single column "B". The number of columns for each row is different, however, there is a maximum number, say 25. As mentioned in the image, when the data from columns B to the end is moved in to column B, column A is retained fixed, to the original value, and the original data below it is pushed below. Any pointers to how this can be achieved by VBA or without VBA?

View 6 Replies View Related

Moving Columns Automatically When Date Changes Business Days Only

Aug 7, 2012

I would like to move columns to the right as the date changes. For example, the top of the column has the current date. Within the column are about 40 rows of data. as the date changes, I would like that column to automatically move to the right and show that column with yesterday's date, and have that data associated along with it moved. I am looking for 6 months of columns to store, with the current date in the first column and subsequently moving right with the previous dates and info.

------------------------------------------------------------------------------------------------
August 7, 2012 | August 6, 2012 | August 5, 2012 | August 4, 2012 | August 3, 2012
------------------------------------------------------------------------------------------------
Accepted Processed Accepted
Rejected Accepted
Processed Processed
...
and so on

View 2 Replies View Related

Moving VBA Generated List Between Columns And Setting Arrays

Jun 21, 2013

I have been working on a few different spreadsheets, and I have gotten almost everything to work. There are just two things that I just can't get right. Here is the first problem:

It seems to me that I should be able to change where the list will display where it says: sh.Range("a10").PasteSpecial xlPasteValues

I change the range to anything in column A and it works, but If I change the column, the entire script seems to run in one row, and the days of the week don't move.

Code:
Sub Workbook_Open()
Range("a2:d300").FormulaR1C1 = Clear
Dim sh As Worksheet, dyArr As Variant, rng As Range, c As Range
Set sh = Sheets("Summary")
[Code] ....

Now the second issue, I need to know how to set the array to look at every single worksheet without listing every sheet. Here is an example:

Code:
dyArr = Array("apple", "explorer", "firefox", "google", "java", "safari", "templates")

Now, in the future I might need to add a worksheet in between google and Java, and I don't want to have to change the script every time.

View 3 Replies View Related

Moving Duplicate Rows To Columns For Mail Merge

Jul 28, 2008

to prepare an excel spreadsheet for a mailmerge but as all of the info for 1 recipient needs to be in columns instead of rows. I need to convert 2 columns' data into columns but only when there are duplicate invoices, see below;

View 9 Replies View Related

Multiple Choice (add In Columns For Whether The Ship Is Moving Or Not And The Speed Of The Wind)

Nov 24, 2009

Working on the same piece of work as in:

http://www.excelforum.com/excel-gene...n-formula.html

Howver this time i need to add in columns for whether the ship is moving or not and the speed of the wind.

Currently have this formula to calculate the kinetic energy fo the plane:

View 2 Replies View Related

Moving Data Cells From Multiple Columns To Single Column

Nov 14, 2011

I'm trying to work out how to take all cells with data from multiple columns and stack them in a single column.

Here's the history...

I have multiple part numbers in single cells in column A. I perform a text-to-columns function. The resulting part numbers spread across multiple columns (say, B through K). Now I need to get all the part numbers, in their own cells, stacked in column A for one continuous list of single cell part numbers.

Is there a VBA option for cutting only the data cells from Column B-K and pasting the data at the bottom of column A while avioding blank cells?

View 4 Replies View Related

Excel 2010 :: Moving Data Organized By Columns To Rows?

Nov 26, 2013

import it into to Stata to do statistical analysis. I always receive spreadsheets like this:

country
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000

[code].....

and I have to manually reorganize it like this to import into Stata:

country
year
value

Benin
1991
20

Benin
1992
254

[code].....

Is there way I can quickly design a macro to do this? The problem is that I generally have a list of about 60 countries, and years from 1991-2011. So, it's really time consuming copying the column of data corresponding to the year, pasting below, repasting the list of countries and the years...then again..then again...then again...I'm using Excel 2010.

View 7 Replies View Related

Moving Data From Rows To Columns - Depending On Unique Content In A Field In Column

Jun 24, 2014

I have a worksheet which contains 2 columns which is needed to work my problem.

Unique Work ID and Description

The unique work ID are the same for each description, but there are up to 5 different description associated with each unique work id.

I'm looking for an automated process but where to start to convert the 5 rows in the unique row and 5 column for the descriptions

View 8 Replies View Related

Adding Columns

Dec 16, 2006

I wish to have a column of values. It will be dates. There will be a value in each cell (hours worked by employee) I want to know only the total hours for the last 30 calendar days. I still need to see previous values, but I just want to total the last 30

View 9 Replies View Related

Adding In Different Columns

Jul 14, 2009

i have two columns

column1: status
column2: total time of status

infinite long

now what i need to do is count the total time a specific status has.

f.ex.

column1: status1, status2, , status1
column2: 0 days 4 hours, 1 day 0.5 hours, 5 days 3.5 hours

how can i make a formula that looks up
if (in column1= status 1)
time= column2

the result i need is:

status1 = 5 days 7.5 hours
status2= 1 day 0.5 hours

i thought about a countif over column1 but i dont know how to add the second column

View 9 Replies View Related

Adding Numbers In Columns

Aug 14, 2008

What's the fastest way to display the sum of each column in one row. Here's a picture of what I want to do: http://www.filefreak.com/ppublic/33833/excel%20help.bmp now I want the sum of each column to be displayed in for example row 10. I have tried manually clicking "autosum" (sp?) but that will take a lot of time as I have about 400 more of these.

View 2 Replies View Related

Adding Columns And Formulas And All That

Nov 6, 2008

I would now like to as remove the first column and add another column a and b. A would say "Service From Date" and column B would say "Service To Date" In addition I would like to add a column between "5202 Meals Provided" and "5221 S.A. Facility Lodging" a column that reads "7025 Number of Days Care" and that tallies like the rest of them.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved