Switching Info Around In The Same Cell?
May 21, 2014I 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?
ADVERTISEMENT
Keeping The Same Cell When Switching Worksheets
Mar 30, 2007I would like my cursor to stay in the same cell when I switch worksheets. If I'm in B40 on worksheet one, and switch to worksheet two I would like the cursor to be in B40.
I'm using very basic excel functions with no scripting at the moment.
Macro For Switching Sheets When Cell Value Greater Than 0
Jan 5, 2012I have three spreadsheets
I need to have an automatic macro where if the Cell Value in SPREADSHEET 2
for example Cell J5 is greater than 0 (Zero is the default value in the cell).
Then the macro will open up a msgbox that says "You Are Not Eligible" in SPREADSHEET 1.
This is the code that I have placed in SPREADSHEET 2.
Private Sub Worksheet_Activate()
If [J5] > 0 Then
Sheets("Spreadsheet1").Select
MsgBox "You Are Not Eligible"
End If
End Sub
However it does not go to Spreadsheet 1
Excel 2010 :: Switching Sheets While Keeping Cell The Same
Feb 12, 2014I am using microsoft excel 2010. I currently have workbooks for various things with 46 worksheets in each one (each worksheet is a store). I usually go into the worksheets daily and dump numbers into each sheet. I was wondering if there was a way to switch worksheets but keep the cell the same when i switch to a different sheet to make it much easier to dump the numbers in.
For example: Say in worksheet1 i am in cell A34 to dump in a number. When i switch to worksheet2 i want to be in the same cell to dump the next number for the next store and so on and so forth for the next 44 sheets.
Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow
May 12, 2014I 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 RelatedHow To Fill Vertical Columns With Info From Horizontal Info
Aug 22, 2014I 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
Excel 2003 :: How To Create / Run Cell A Equals Cell B Put Cell C Info In Cell D
Jan 26, 2006I need to match data in cell A to cell B and then if they equal I need to copy the adjacent cell C to cell X . How do I set up a macro to do this automatically? I have over 5000 cells to compare and match up.. I have Office 2003.
View 7 Replies View RelatedFind Empty Cell In Range Then Copy Info In Cell Above It?
Dec 15, 2011I've got a range of data in Column D approx 50,000 rows long and I need to go down this range and when theres a blank cell copy the info from the cell above. I've got some code which loops through this but I need to make sure I put "EOF and the bottom of the info to stop the loop. Is there a slicker way of writing this code?
Code:
Sub TestBlankCell()
Range("D5").Select
Do
[Code].....
Pulling A Letter From A Cell And Filling Another Cell With Info
Nov 27, 2005Here is what I am trying to do with no luck so far.
If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or
number and fill B1 with E86.
Example
A1= RS23U1R109000 B1=E86
A1= RS23V1R109000 B1=E87
A1= RS23R1R109000 B1=E84
As you can see in my example, the 5th letter could be U,V,R or whatever, but
I need cell B1 to read that letter and populate B1 with E86, E87, E84 or
whatever.
Getting Sheet Name And Info From Cell
Mar 5, 2009I 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
Extract Certain Info From One Cell
May 7, 2013Is 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
How To Get Info From A Cell / Row Of The Height
Feb 27, 2014I 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 RelatedSave Using 2 Cell's Info
Aug 23, 2008I need a macro that will, on a button click, save a workbook and naming it what is in cell B3 and B5.
View 9 Replies View RelatedExtracting Info From Cell
Nov 18, 2008I have a cell that has address and city with postal code.
I need to be able to extract the city and postal code on its own.
I know i could do Data - Text to columns but i would like to keep the cell intact and not have to split it up.
Here is an example of the cell in question:
1234 Parc street, Montreal H1A 2N2
Switching Last Name/first Name
Oct 31, 2009I have a column of cells that have the last name first then the first name. Example:
C1
Smith John
Is there a formula/macro that can switch them all?
Replacing A Blank With Info From Cell Above
Apr 17, 2009I have a long spreadsheet that is formatted and organized with six digit codes on the left, and then several lines of information on the right, in order to sort and compare to another report, I was trying to replace the blanks in the digits on the left....
View 7 Replies View RelatedRecord Data From A Cell Which Contains Info
Nov 7, 2008What I'm trying to put together is a sheet where i work out how much margin i will be making on a sale (which i done). The bit I'm stuck with is the recording the data on a separate sheet.
What i have done so far.
I created a Macro button to insert and copy cells C6, C7 & C8 (the bits i need). Which works but it takes the formular with it so everytime i chage the figure on sheet 1 it changes in sheet 2.
So what i'm asking is there a way to mirror what is display rather that copy?
How To Increase Cell Info Incrementally
Dec 7, 2010I created a small block of cells on my worksheet where i have in separate cells, the day of the week, the days date and the month. I want to design a special memory calendar for my mom in early stages alzheimers.
There are cells with specific info which i do not want to re type for the whole month/year.
I want to be able to copy all the info into another block of cells and have the day of the week and date change also the month.
Separating Info From One Cell Into 2 Different Cells
Aug 28, 2007Whenever I get information from finance.yahoo.com or from my job and put it into excel all the information seems to go in one cell and numerous rows. (I think its b/c I am putting information that isnt' meant to be in excel and forcing it to open up there.)
For Example in cell A1 I will have
"AIG , AMER INTL GROUP I , 66.08 , 1:16pm , 169.455B , 16.736 , 2.01 , 9.47 , 0.78"
Cell A2 I will have
GOOG , GOOGLE , 508.9 , 1:21pm , 158.845B , 22.361 , 17.511 , 26.29 , 1
What I want to see is cell A1 as AIG and cell B1 as 66.08 and cell A2 - GOOG and cell B2 508.9. I don't even want the rest of the stuff.
Is there any way or formula I can use to just pull the information out of cell and have it separated for me?
Removing Specific Info From Cell
Nov 18, 2008I have 40,000 part numbers that range in style.
For example:
13538-AL
BC-DIB-13
13750U
13762-1
I want to take all the numbers that have the ending tag "-XX" that are LETTERED but NOT the numbered combo (just like example 13538-AL) and remove the tag to just have the root 5-digit number.
I have all the end tag combos I would like removed. SO if I needed -AL, -LG, -CG, -SS, etc. removed, I would need the formula that would find all the 5-digit numbers with those end tags and remove those tags, leaving the other numbers alone.
Change Info In Another Cell Via Checkboxes
May 22, 2009I want to be able to change 2 cell info based on 4 checkboxes used. So based on a check box i check, it will populate what info i assigned to it the box. See below,
1 cell12342 cell
I have 4 checkboxes and 2 cells i need populated by whatver box i check. I have the following formula, but not sure how to tie in all the cells together.
=IF(A1,"Checked message",") If 1 CELL gets changed when checked, i need 2 CELL to change as well. Example, I checked box one and so 1CELL should change to, lets say to a set dollar amount like $12, and then 2CELL would also change to another entry say a set dollar amount, like $15 or whatever both based on checkbox one. BUT i also want to populate those same 2 cells with different amounts if i check the other boxes.
Commandbutton To Enter Cell Info
Jul 3, 2009Usually you press the enter key or any of the arrow key to enter cell information. Is is possible to press a commandbutton to enter the cell information and perform some operations without pressing the enterbutton first?
Rang655
Returning Something In A Cell If Another Cell Has Info Input
Apr 1, 2008my spreadsheet to return the word unit if cell a18=1 or the word units if its over 1 but i also want the cell to remain empty if there is nothing input into cell a18 is this possible
Using 1 Cell Info Automatically If Another Cell Has No Data In It
Dec 16, 2008I have a sheet that counts stock, in cell I5 i have week 4s results in k5 week 5s. what I need is in cell N5 the number in I5 if their is no number in k5 but if k5 has a number in it I want that number in N5
View 14 Replies View RelatedAutomatic Cell Info Based On Another Cell?
Jan 20, 2014I am trying to have one cell automaticall input infromation based on another cell. For example, if A1 = 10, then I want B1 to automatically equal 20.
The formula I am using in B1 is as follows - =if(A1="10","20","")
I have 2 problems though:
1st - I don't want to put the furmula in any cell because other information is put in there also. I tried putting it in conditional format but I don't think it is meant for such usage. Also, I already have something in data validation. so I can't put anything there because to my knowledge you can only put one validation per cell.
2nd - I have multiple numbers (around 7) that I need to be automatically inputed along the columns.
Macro That Mail Based On Cell Info?
Jan 29, 2014I need a macro thaw sends a mail to a specific address (and CC) based on a critiria in a cell. This is the code I have. It does not send the mail.
[Code] .....
Pass WB / WS / Range Info From Cell To VBA Procedure?
May 31, 2013I need to pass range information (eg. WorkSheets("abc").Range("A1") as text or ??) from a cell (ie the above text is in a cell on some worksheet, say "XYZ") to a VBA procedure or could directly use it in the procedure, similar to...
Sub MyProc(RngInfo as string [or?])
dim RRng as range
Set RRng= RngInfo ??? it is this part I'm really not sure how to do
where RngInfo is a worksheet that has a "named" cell that contains the above cell with the indicated range in it.
eg. RngInfo is worksheets("XYZ").Range("D1") where D1 contains the text (or ?)WorkSheets("abc").Range("A1")
I've only indicated these as text items because I'm not sure what/how you would do this. The end purpose of this is to pass variable Range information from a cell on a WS either into (or use within directly) a VBA Sub. I guess I could pass the WS and Range Address as a single string separated by a "Char" and use Split to separate them and then recombine using Worksheets(Parm(0)).Range(Parm(1)) but it seems like it should be easier than that.
Macro To Copy Paste Info From Every Other Cell
Apr 17, 2014I have a table like this:
1/2/14
2345
1/6/14
34665
1/7/14
5473457
For Column A-I would like to create a macro that will copy the info from cell A1 and paste in in A2. This will continue all the way to the last row containing info which will vary. So after the first copy/paste, it well go to A3 and copy paste onto A4, A5 will copy and paste onto A6 etc.
For Column B- The same only it will copy the contents of B2 and paste it on B1, B4 copy/paste to B3 all the way until the last row of data.
Formula Required To Pull Some Info From Cell
Apr 15, 2008i have a list of names which also contain e mails addresses after the names, they are displayed as (In column B onmy spreedsheet)
Armani Stevens/GB/companyname/GB@soso
what i need from the above is just the name (up tp the first backslash)
so i would need Armani Stevens and disregard the rest.
What i would then need to do is to take the name and then see if the names is in the list which is situated in column A,
so to sum
once i have Armani Stevens extracted from Coulmn B i would want to see if this name is in Column A
Names are obviously of all different lengths and there is always a space after the first name and surname
Macro Sub Auto_open() Add Cell Info To A Welcome Message
Jan 19, 2009When I open my workbook I get a popup that says: Welcome Back...
Using a module with the following
Sub auto_open()
MsgBox "Welcome Back..."
End Sub
I want to have it say: Welcome Back, Phixtit
Where "Phixtit" comes from the cell "C15" on my "INFO" sheet.
Example:
='INFO'!$C$15