jump

Hi Why when I enter 66 as a number, this code print "Else"? it does not go the first case? any idea why? I used F8 but again jump to the last case. Thank you very much. Sub test3() Dim x As Integer x = InputBox("enter number") Select Case x Case x > 50 MsgBox...

Hello, I am trying to jump columns in excel from a cell, could anyone help? I'm trying through For sub test () For i = 1 To 5 Cells (i) .Select Next i End Sub What I need is to start in cell A, then jump every 10 columns until it's over.

Hey Mr Excel users, I'm looking for a shortcut that allows me to jump to dependent or precedent cells on other sheets. I know you can do it within the same sheet, but hate having to manually click that arrow that pops up when the cell being traced has a dependent / precedent on another sheet...

Column A B W1 W1_1 W1 W1_2 W171 W171_3 Formula B1 is: A1&"_"&ROW()-ROW($C$9). How to get W171 not jump to _3 but to _1 again? What formula would you suggest? Thanks!

Have a SS that has a ton of lines, would like a button that would jump to the next cell that does not have text. It can vary each time though. Thanks

My question has two parts to it, but I would be happy if I could just get the first part answered. The second part is mostly aesthetics. 1) Is it possible to create a link that will jump back to a previous point in an Excel document? I have a rather large document that I'm creating, and I'm...

Is there an option to jump through a list on a worksheet alphabetically in Excel 2003?

Hi Can anyone help me with a formula to look for the number in a particular coordinate?By getting the number in 4th column, 5th row of $C2 i'm using =IFERROR(IF(MATCH($C2,Dec!$C:$C,0),"confirm",),"") to look for an entry. can i still use this formula to look for that number...

I got an idea but none on how to do it. Rather than scrolling thru 20-30 sheets in a work book looking for one in particular, is there a way to create a filter that will list all the sheets alphabetically and let you choose which one to jump to?

Hi I have been trying to write some code which checks if a cell is empty, if the cell is empty it moves the data from that row and the next 2 columns down a row. The problem I have is that the second column contains the address of a linked cell, hence I need to check if the address is still...

Morning all, How would this be possible please. I have a worksheet where in column B is the customers name. The first cell is B8 and continues down the page for however long. My request would be to jump to a specific first letter of there christian name. Not sure how it would work but lets say...

HI When i'm filling in the cells on tab "contact" it jump always to tab Offerte pp. i don't know how it is possible :-s THx kristof https://www.dropbox.com/s/1dtcank73s66z7k/CalculatorV2.1%20Komito%20Pool.xlsm?dl=0

Hi I'm using a a dropdown to jump between sheets, but the problem is if I jump from one sheet to another and want to jump back it gets stuck, then I have to pick a different sheet. Is there a way to fix that? Sub MovetoSheet() Dim dd As DropDown Set dd =...

Hi I'm using a a dropdown to jump between sheets, but the problem is if I jump from one sheet to another and want to jump back it gets stuck, then I have to pick a different sheet. Is there a way to fix that? Sub MovetoSheet() Dim dd As DropDown Set dd =...

Sorry I meant sheet not workbook Hi I have 1 workbook, example, I have 1 sheet named 'Calls', in cell C4 a value will be entered for example '1 day' I have another sheet on the bottom 'Collection' I want it to log/copy '1 day', from A1. But I still want this info to remain on 'Collection'...

Hello! I have an excel sheet with 25 different pie charts that take up 250 rows (10 rows per chart). I used data validation to make a list at the top where you can choose which chart to jump to so you don't have to scroll down manually every time. Unfortunately, I don't know how to do this. For...

Hi all is there a better way of doing this ? as I was always taught to avoid the "goto" instruction MSG1 = MsgBox("Pressing this will COMPLETELY replace ALL of the data in the 'Tabs'" & vbCrLf & "Continue ?", vbYesNo, "Sort raw Data") If MSG1 = vbYes Then GoTo jump Else End End If...

Such as Col A a a b c c e k k e I need result in column B (duplicate value is not my concern, just jump to next different value) ColB: a b c e k e

Hi all, I am trying to get the basics for a new project collating data from various sheets and loading it into the last sheet in a workbook. I have a workbook with 5 sheets named Alpha, Bravo, Charlie, Delta and Echo. I am using checkboxes in Delta to select all or a combination of the various...

Hi -- I am using the INDEX function to pull values from a named range on another tab with matching row and column headings. Example formula is: =INDEX(DebtOther,MATCH($A12,INDEX(DebtOther,,1),FALSE),MATCH(CM$2,INDEX(DebtOther,1,),FALSE)) Where: DebtOther = named range on another tab $A12 =...