SWITCHING BETWEEN FORMULAS
Apr 22, 2007
I am trying to figure out commissions with 3 different commission structures depending on type of product. So on C2 I have a drop down box with the 3 types of products. So what I would like to do is when C2 shows say "New" I want it to calculate using one formula. When "used" is selected, I want to use a different formula. And when "scratch_dent" is used, I want it to use a 3rd formula.
View 9 Replies
ADVERTISEMENT
Jan 21, 2009
I am currently creating a massive bilingual report using Excel based on data gathered from a customer visit, as most of the engineers are non-native English speakers, and most everywhere else in the world wants reports in English. Currently I am using this roundabout method:
I have a lookup Table sheet: .....
View 10 Replies
View Related
Oct 31, 2009
I 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?
View 9 Replies
View Related
Nov 25, 2006
Working for a dutch company and using a lot of excel and access it is sometimes a pain that when you are looking for functions. for example "left(b3;3)" in dutch is "links(b3;3)" now this is an easy one but some are hard to guess.
I wrote some neat code which condionally formats cell's in an Excel range and dependend on a value in column "Q" (= status) then sets the color of the field. it works fine
However when working with an english version of Excel I need to use "left" instead of "links"
how to check the local settings for Excel?
[code]
'Conditional Format status cell's
.Range("G4:P" & (xRcount + 3)).Interior.ColorIndex = 4
iRow = 4
iRow2 = 4
View 9 Replies
View Related
Jun 12, 2007
From a workbook, I need to open a further workbook called 'transfer' and then switch back to the original workbook. Presumably I need to save the current workbook name to a variable, open transfer with Workbooks.Open Filename:="c:debworkTRANSFER.xls"
then switch back to the original
How do i pass the original workbook name to a variable, and then reactivate it. I have tried numerous options but just cannot get it to work. Do i reactivate with workbook. activate or windows.activate
View 9 Replies
View Related
Feb 11, 2008
I made up a small subprocedure that searches through a large list of zipcodes (These zipcodes are in a separate sheet). Whenever I execute my subprocedure in another sheet, it jumps to the zipcode sheet and then goes back to where I originally executed the subprocedure.
Is there any way that I can prevent the sheets from switching back and forth?
View 9 Replies
View Related
Sep 30, 2009
I want the people filling in the form to put the date into a box. I did have a calendar box but this wouldn't work on a lot of PCs , so I've switched it for three combo boxes, Day-Month-Year.
I've got the 'Add' button to put it all together - DayBox.Value & "/" & MonthBox.Value etc
This seemed to work fine and excel processes this as a date. It automatically switches to the US date format (MM/DD/YYYY) which would be fine as users don't see it and I know it's at least consistent.
But it's not.
1st August 2009 = 08/01/2009 (ie MM/DD/YYYY)
13th August 2009 = 13/08/2009 (ie DD/MM/YYYY)
And while I can format cell to show me the month name in the first example, the 13/08/2009 refuses to change format even though it's recognised as a date.
View 9 Replies
View Related
Oct 7, 2006
I'm trying to write a piece of VBA code which will switch back and forth between 2 workbooks, but I was hoping that I would not have to name both workbooks in my code.
So far I have been able to name the second file as a variable, open it and copy the data I need, but I now need to switch back to the original file. Is there any way of doing this without hard coding the file name?
View 5 Replies
View Related
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
Oct 23, 2007
I'm having a problem with how excel opens my files. Up until yesterday when I would open any of my spreadsheets they would open seperately. I would have multiple files open across my taskbar and could easily switch between files with a simple Alt-tab windows function.
Now when I open multiple excel files it opens them under "one" file so to speak. The only way to switch between files is if I go to Window>then select the file I want or minimize within excel so I can see the other spreadsheets.
View 2 Replies
View Related
Oct 4, 2009
I need help with stopping the screen to swiching to different worksheet. Everytime I execute this macro, the screen is switching to different worksheet.
View 8 Replies
View Related
Nov 13, 2009
Stop sheets switching. I have a simple autofill macro
View 4 Replies
View Related
Mar 18, 2014
I have a macro that launches another program (Windows Title - Storm). I then use sendkeys to have it export the file to an excel file. (This launches another instance of excel.) I want to be able to focus back to (Storm) so I can sendkeys to close the program down. I can get it to the end result using sendkeys, but I am trying to have it switch back to the Storm application so the user does not need to close it manually.
View 2 Replies
View Related
Oct 7, 2002
I often find myself moving from one sheet in a workbook to another over and over. I wanted a shortcut that moved between the last two sheets selected.
Similar to how Alt+Tab works with windows.
Does anybody know a keyboard shortcut or if not is there a macro that could be added to perosnal.xls that would mean i would aways b able to switch between two sheets quickly.
View 9 Replies
View Related
May 9, 2007
I have 3 workbooks open, the main WB has my command button + code in it, and the other 2 were opened up using the existing code in my main workbook.
Using general code e.g( Thisworkbook, activeworkbook, workbooks(1)), how can I activate one out of the 3?
I know the main workbook can be accessed using "thisworkbook", but when I activate it, I can't activate one of the others in my next line of code using activeworkbook.activate, or workbooks(1).activate.
View 9 Replies
View Related
May 19, 2014
how to switch cells per date entered?
View 3 Replies
View Related
May 21, 2009
Which version of excel allows you to do a Track Changes without switching to a shared workbook? I am awared the Excel 2002 version allows Track Changes on the conditioned that the workbook is switch to shared mode.
View 3 Replies
View Related
Jun 22, 2009
Is there a way to switch back and forth between workbooks without having to use the Activate command? I have everything planned out but this aspect is still a source of confusion. The Project: I need to have qty purchased and price in a table from Worksheet B entered into the matching customer index location in Worksheet A. Worksheet B contains customer number, sku, qty purchased and price. Worksheet A contains customer numbers in row 3 and sku's in column A. Minor data manipulation will need to be done on Worksheet B before before accessing it which I plan to do after opening it in this macro.
View 4 Replies
View Related
Feb 5, 2010
I need keyboard shortcut for switching through worksheets.
For now, I have this VBA macro and shortcut Ctrl+R:
View 7 Replies
View Related
Nov 30, 2011
I am creating a code that loops through several list and Copys and paste the value in a given cell to another cell. However I would like it to do so without switching to the other tab. Additionally I also don't want to freeze the worksheet because I have a display that shows progress through a conditional formatting thing. I need it to stay on the "Rotation" tab.
Sub Roladex()
Dim RegionPaste As Range
Dim row As Integer, row1 As Integer, row2 As Integer
[Code].....
View 3 Replies
View Related
Aug 4, 2012
I've been programming my VBA script to import data from an XML file which looks like this:
HTML Code:
<response responseStatus="success"> <result xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:type="apiPagination"> <currentPage>1</currentPage> <list xsi:type="apiReport"> <Variable1>Name1</Variable1> <Variable2>41</Variable2> </list> <list xsi:type="apiReport"> <Variable1>Name2</Variable1> <Variable2>20</Variable2> </list>
So far everything works great and it imports everything correctly to Excel 2010. This is the code I'm using:
Code:
Sub test()
Dim WS As Worksheet: Set WS = ActiveSheet
Dim req As New XMLHTTP
Dim Link As String
Dim PageNumber As Integer
Dim Url As String
PageNumber = 1
[code].....
The problem is that I only import page1 (only link [URL])
How do I get all URLs so that it also imports the data located on other pagenumbers? For example [URL]
View 1 Replies
View Related
May 2, 2013
I am looking for a code that would enable switching of sheets. For example, on Sheet1 (Master Sheet) I have got Industry1 to Industry3 and the companies within the Industries are on Sheet2 to Sheet4. When someone clicks Industry1 on Sheet1, it should navigate to Sheet2 (where it gives a list of companies within the industry), and when Industry2 on Sheet1 is clicked, it should navigate to Sheet3 and so forth..
View 3 Replies
View Related
Oct 10, 2013
I have a sheet of about 10k rows that I need to switch some things around on. The string is below:
Acura|TL|1995^^Acura|TL|1996^^Acura|TL|1997^^Acura|TL|1998^^Acura|TL|1999
It needs to say:
1995|Acura|TL^^1996|Acura|TL^^1997|Acura|TL^^1998|Acura|TL^^1999|Acura|TL
How to fix this with a macro or formula. The Make Model and Year on each string will be different. Basically I need the format to be Make|Model|Year.
View 9 Replies
View Related
Mar 30, 2007
I 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.
View 9 Replies
View Related
Oct 22, 2009
Workbook Name Changes – But Workbook Does Not For Five Seconds?? MS Office Excel 2003 / SP3 Installed. I have noticed an odd occurrence from time to time while switching between workbooks. When I switch from one workbook to another, (typically via the “Window” pull down – but the same result happens when switching workbooks on the tabs at the bottom of the screen), the “switched to” workbook name will instantly appear at the top of the application, but the actual switch to the selected workbook is delayed for several seconds, (five seconds or so).
While not a major issue, it is annoying. I suspect that it is a memory allocation issue, (I have a Duo CPU System / XP Pro / 2 GB RAM), and with that in mind I have both restated MS Excel and also performed a complete re-boot. While either option does (seem) to result in the issue being (temporally) removed from my machine, it does return. I may go for several days without this issue occurring, and then it appears for no known reason
View 2 Replies
View Related
Feb 1, 2007
I select workbook 1, cell A4, then I select workbook 2, cell A4, but when I'm in workbook 2, it does not select cell A4. Am I doing something wrong here? See my code below.
Sub CopyData()
Dim i As Variant
Workbooks("1_2007 Forecast (Ancillary).xls").Worksheets(1).Activate
Cells.Range("a4").Activate
Workbooks("1_2007 Forecast (LGBU).xls").Worksheets(1).Activate
Cells.Range("a4").Activate
End Sub
View 4 Replies
View Related
Apr 7, 2007
I have a column in a sheet that has two different values in it "SB" and "SEI".
I want a macro that will allow me to switch the auto-filter between the 2 at with a shortcut button.
I have a macro that will switch the auto-filter on and off, but I was wondering if anyone had anything that will automatically switch it between two values.
View 5 Replies
View Related
Jan 5, 2012
I 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
View 9 Replies
View Related
Jul 25, 2013
I have both Excel 2003 and Excel 2007 installed on my computer, using VBA code is it possible to specify which version I open an excel document in?
View 2 Replies
View Related
Jan 2, 2014
I'm having an issue with some emails that I send out automatically. I use Ron de Bruin's code to send with the Range to HTML function from Mail Range/Selection in the body of the mail.
My issue is when I view in OWA, all the formatting is lost. There is no issue viewing in Outlook itself, but some of our sales people use the web app and the view is corrupted. Back when I did this manually, I would just copy and paste the range of cells into the body of the message, and there was never any problem with formatting in OWA.
Is there a setting that needs to be changed, or have code for pasting a range into the body of a message that works?
View 1 Replies
View Related