Move Info To Right

Nov 28, 2009

I have the following macro that I found through Search (written by Peterss) and have been able to modify it to work for me.


Sub MergeBooks()
Dim myFolder As String
Dim myBooks
Dim ws As Worksheet, wsMaster As Worksheet
Dim nr As Long, rws As Long, i As Long
Dim LR As Long

Application.ScreenUpdating = False
Application.EnableEvents = False
myFolder = "C:Documents and SettingsNalaniDesktopForecast"

I have been trying to get the information from the Next Workbook to move over 5 columns (E), then the Next book to move to col (I), etc.

View 9 Replies


ADVERTISEMENT

Move Info From A Worksheet To Another

Nov 2, 2008

i need to get certain info from one worksheet to another is there any way to do this automatically

View 9 Replies View Related

Formula To Move Info From One Column To Another

Nov 13, 2006

I need a formula that will take the value of one cell and put it in another cell other than the one in which I am typing the formula. I can't think of how to do this.

I have two columns, A & B (no headers), of information. The columns are not identical, and column B has empty cells scattered throughout the column. For each empty cell in column B, I want to copy the same row of information into it from column A, as if I'm just scooting the information in column A that's on the same row as the empty cells in column B.

This is simple with a cut/paste, but when there's thirty empty cells, cutting and pasting takes time. (What's really frustrating is that I've figured out a few formulas that will copy the information from column A but all the information gets pasted in the column in which I'm creating the formula (say, column F, for example). THAT doesn't help me because the empty cells in column b are still empty!)

View 9 Replies View Related

Move Differently Named Sheets In Workbook - Some Missing Due To No Info

Apr 18, 2013

I am trying to use a macro to move a range of excel tabs to the front of the workbook however some of the tabs could be missing due to no information.

If I simply record the macro by moving them manually if the procedure arrives at one that is missing it would report an error.

So in essence I need it to look for the tab and if its there move and if its not move onto the next until it arrives at the last one.

View 9 Replies View Related

Move Info In One Column Based On Data In Another Column

Aug 28, 2012

I am trying to move a column of numbers based on the information in another column. I've been looking for about a week and find macros that are close but not quite.

In one column it reads Mobile, Home, or is blank. If the number is a Mobile (column R), the area code (column P) needs to move to column S and the phone (column Q) needs to move to column T and the primary phone (column R) needs to move to column U. Home and blank cells remain as they are.

area (P)
phone (Q)
primary phone (R)
col S
col T
col U

[code]....

View 7 Replies View Related

Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow

May 12, 2014

I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?

View 3 Replies View Related

How To Fill Vertical Columns With Info From Horizontal Info

Aug 22, 2014

I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g

The info in these columns at present has been manually entered but I am sure it could be automated.

OOL Roster Final 18-31Aug14.xlsx

View 1 Replies View Related

Is There A Way To Stick A Few Row Of Cells Together So That When I Move One They All Move

Jul 7, 2009

is there a way to stick a few row of cells together so that when i move one they all move.. i have some rows that when i sort them i want them to move together with the other ones..

View 9 Replies View Related

Get Info From One Spreadsheet To Another

Feb 27, 2007

I want to be able to connect two spreedsheets.

I have a "surplus inventory" sheet and a "inventory shipped" sheet. How can I input how much I shipped in the "inventory shipped" sheet and make it take away from my "surplus inventory" sheet automatiaclly?

View 9 Replies View Related

Getting Info From Website Using VBA

Aug 5, 2014

I am using VBA to open an IE page and try to get some info however i cant seem to grab it

This is the code i have..

[Code].....

I have inspected the code from the website and it is this

[Code] ........

The problem is i dont know how to get the info in the "Metaname, ICBM".

View 7 Replies View Related

Recalling Info Into Another Row

Dec 19, 2007

I am trying to recall info from the rows in another part of a worksheet when I type the first column. For example, I have over 300 rows of:

Apples 155 12oz red
Orange 120 10oz orange
Banana 50 11oz yellow
etc.

I want to select or type only the word:

Apples

And have the rest of the columns fill in with the rest of the info, like so:

Apples 155 12oz red

A filter would work well to select, except I need about 7 in the worksheet as it is a form and excel only allows one. I can’t seem to make the advanced filter work. An IF function would work, except I'd have to put all the words to match in " " marks, which would be very time consuming.

how I can recall the info from my list to the 7 lines I need to copy them into?

View 10 Replies View Related

Get Info From One Sheet To Another?

May 11, 2012

how to use vba in excell. First question. 1) I have a spreadsheet with names in column one and other info in columns B-I. I would like to make excell do the following. If I enter the name a second time and so on, then can excel take the info out of certain cells from the first entry? Say column C, D, and G and auto enter them for this new row. 2) can I copy parts of a sheet to a new sheet and then when I make changes or new entries then they will update the copied sheets info?

View 7 Replies View Related

Goto Next Row Of Info

Oct 31, 2008

i have this code that gives me 1st row of data , from Row 10 of every sheet in workbook, how can i modify to give me row 11 ,12,13,14,15,16 as well upto row 21 if there is Data in Col C ( max range is C10:C21) ,

For intX = 1 To Sheets.Count
For intY = LBound(arySkipSheets) To UBound(arySkipSheets)
If Sheets(intX).Name = "MachCapRpt" Or Sheets(intX).Name = "MachAdSht" Or Sheets(intX).Name = "Times" Or Sheets(intX).Name = "MachSchd" Then
Else
.Range("A" & intNextRow).Value = Sheets(intX).Name
.Range("B" & intNextRow).Value = Sheets(intX).Range("B10")
.Range("C" & intNextRow).Value = Sheets(intX).Range("C10")
.Range("D" & intNextRow).Value = Sheets(intX).Range("E10")
.Range("E" & intNextRow).Value = Sheets(intX).Range("H10")
.Range("F" & intNextRow).Value = Sheets(intX).Range("M10")
.Range("G" & intNextRow).Value = Sheets(intX).Range("W10")..............

View 9 Replies View Related

Lookup Value And Return Info About The Value

Dec 18, 2013

How to return the value of what i looking up. for example i want to find the value of A1 from a range of B1:B10 if A1 is B1 then it return the value beside B1 for example the value of B1 is C1

View 2 Replies View Related

Pulling Info From Spreadsheet

Jun 5, 2014

I have a spreadsheet with info about students in a summer program. I need to pull out the students who have allergies along with what their allergy is and their emergency contact phone number. I would like this new info in a new spreadsheet.

Here is an example of the spreadsheet:

allergiesnamephoneallergy type
nobob410.555.1234
nojim410.555.5843
yesmeg410.555.7458nuts
nolex410.555.1159
yeswill410.555.5005fish

Is there a formula that I can use?

View 1 Replies View Related

Pulling Info From Column

Jul 8, 2014

I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes

When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)

The problem I'm running into is obtaining the dollar amount within the cell. For example:

A1 contains: 11112222 $1234.56 Sample, Name Sample Note

I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.

Further, the dollar amount varies from $1.01 to $10,000+

View 9 Replies View Related

Switching Info Around In The Same Cell?

May 21, 2014

I have names in cells in this format.

Smith John

I would like to switch that around so the name in the cell looks like this

John Smith

Is there an easy way to do this?

View 6 Replies View Related

Transfer Info From One Worksheet To Another

Jun 20, 2007

Im trying to take information and have it copy to a different worsheet when a certain selection or type is put into a column.

Example:
On worksheet "Alpha"...
Column "A" will have "Maintenance, Supplies, or Payroll" in it.
Column "B" will have a currency.

On Worksheet "Bravo"...
I would like to have everything from Column "B" on "Alpha" to be placed here that has "Maintenance" in Column "A"

On Worksheet "Charlie"...
I would like to have everything from Column "B" on "Alpha" to be placed here that has "Supplies" in Column "A"
Etc...

View 10 Replies View Related

Automatically Insert New Row For New Info

Apr 4, 2008

The spreadsheet is used to keep track of shares that are purchased / sold

It will make all tax calculations as well as provide a single statement showing all transactions rather than having to sort through dozens of individual statements.

I seem to have most of it working but could use some help with the following.

I would like to be able to have a spot (maybe on a separate worksheet) where you could enter the four items from which everything else is derived, share price, date, number of shares and whether it was a purchase or a sale, and have it automatically:

1. add a new row (complete with formulas and formatting info) to display the new information

2. sort the new data to fit into the right spot in the spreadsheet by date.

View 8 Replies View Related

Getting Sheet Name And Info From Cell

Mar 5, 2009

I have about a 100 sheet workbook for a project my company has upcoming. All the sheets are numbered 1-100. I also have another sheet that has the description of each pay item on ROW B of the sheet. Well here's my question. I'm trying to get a function that i can just copy and paste in each sheet instead of changing the number on each sheet.

For instance...

I would be using =Descriptions!B2 for sheet 2, and then =Descriptions!B3 for sheet 3 and so on. My question is does anyone know how i can get the sheet name so then i could just copy and paste one function that would be like =Descriptions!B(SheetName)

So that way i can just copy and paste instead of having to change it each time. I found this function to get the sheet name but can't seem to incorporate it into the =Descriptions!B

View 4 Replies View Related

Sorting Info In A Column

Apr 17, 2009

I need to sort information in a column containing both numbers and words. In the "asending" & "desending" it only gives two options to choose from. (none) & PartNum.

View 14 Replies View Related

Splitting And Extracting Certain Info

Aug 6, 2009

I have a spreadsheet which contains addresses split randomly into several columns and need to extract the postcode for every row.

WEST STREETCF34 9AF MAESTEG
DERWEN CLOSESA5 4QQ SWANSEA
GOETRE BELLAF ROADSA2 7RL SWANSEA
TALIESIN CLOSEBRIDGEND CF35 6JR
TALIESIN CLOSECF35 6JR BRIDGEEND

Above is a small example of 2 of the columns, most addresses are in 3 columns.

The postcode can appear at the front, end or anywhere in the address field. Depends on who typed it in. I need to somehow extract the postcode and have it in a separate column.

Text to columns wont work i think because the info isnt uniform, I've tried the search for the various postcode starting letters but still cannot extract the entire postcode.

View 10 Replies View Related

How To Link 2 Worksbook Together To Get All Info

Mar 21, 2013

I have tab1 with (master list with contact name) and tab2 (list with no conact name)

i want to have formula or macro that llnks the contact persons name with the company name, address, city, and state.

i know copy and paste--but thats not what will work..this is an example worksheet, the real verson will have thousand of line of data and i would like to creat a link or formula..

Can this problem work in excel or is this more on an access promblem? in where i need to build a database...

Master list example 1.xlsx

View 1 Replies View Related

Extract Certain Info From One Cell

May 7, 2013

Is it possible to extract certain info from one cell. Example in cell A I have a description of a product plus price I only need the price, The price has a $sign in front of it. Example below

I have over 2000 products so I was hoping I wouldn't half to go through one at a time. Is is possible to extract just price and place it into cell b.

1 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $22.50 Stock Quantity: 107 YD

2 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $28.50 Stock Quantity: 107 YD

3 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $19.50 Stock Quantity: 107 YD

4 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $119.50 Stock Quantity: 107 YD

5 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $67 Stock Quantity: 107 YD

6 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $89 Stock Quantity: 107 YD

7 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $25.50 Stock Quantity: 107 YD

8 and so on

View 2 Replies View Related

Merging Updated Info Row With Old Row

Aug 8, 2013

a little task that I'm trying to accomplish. twice a day, a coworker of mine puts out a report on all the jobs we have going for the next couple of days. I paste her report into my own, hide the columns I don't care about, and format the way I like, and add in column U, which holds my comments about the job. It ends up looking something like this:

escelex1.PNG

Later that afternoon, I get the updated copy of her report, in which the B number and customer name always stay the same, but some of the info might change, for example the HOLD column, or the boards or sten columns might change.

What I would like to do is to paste in the afternoon copy of the report, and to have excel merge duplicate rows in such a way that I have the afternoon information from her report (columns B-Q) and keep the comments that I had put in the morning record's row.

When I paste her afternoon report into my spreadsheet, I get duplicate entries looking like this: escelex2.PNG

But I want to be able to merge the data, so that it looks like this: escelex3.PNG

Does that make sense? I want the afternoon version of the data, with no duplicates, but I don't want to delete the comments that I put in in the morning (which is what the "remove duplicates" button is doing)

View 2 Replies View Related

How To Get Info From A Cell / Row Of The Height

Feb 27, 2014

I am trying to get info from a cell/Row of the height just like "=CELL("width",A1)" Only I need Height info returned, is this possible?

View 10 Replies View Related

Updating Info On Ribbon

Mar 13, 2014

I am using this code to show met the amount of sheets listed.

[Code] ...

I use a commandbutton on a userform to add sheets regulary, is there a command that can then update the ribbon to the new count.

View 7 Replies View Related

Macro To Get Info From One Sheet To Another

May 29, 2007

I need to make a macro to get sales information from sheet one to sheet 2 in a different order with a few other things that need to be added in everything I need is in sheet 2.

Sheet 1 is what I work with and I need it to look like sheet 2 using a macro I wrote what I need in sheet 2A13-...

View 14 Replies View Related

Autofill Only If Adjacent Row Has Info...

Nov 4, 2008

Below is my current code. I created this to work for a spreadsheet I had. Works mint. Then I use in another spreadsheet which is almost identical but has less rows. Everything works, but then im left with a bunch of extra rows that have DIV error. Rather than select range 2:34, is there a way to select the entire column, and autofill only if the column next to it has a number in it?

View 6 Replies View Related

Checking Info Entered

Aug 5, 2009

I want add some code into a macro of mine which checks to see if J8 >20 and DA8 = "TRUE" then a msgbox appears saying "no auto margins".

View 2 Replies View Related







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