instance

Hi all, I have a VBA macro that copies a HTML element from a website in an already open instance of IE; the macro operates once every minute. It seems like nearly every time the macro triggers and copies the element from the website, a new instance of IE is created in the task manager. I'm...

Hello, I am using Office 365 and when I open two Excel file then it opens on the same instance. For some reason, I am looking to open in a separate instance. Anyone has an idea how to achieve it. I appreciate your response. Thank you!

I have a question regarding cell referencing (range). For instance in the vlookup function you defilé the range in the second part as i.e. C3:E9 like this vlookup(what, range, position, false). I know that you can select the range and rename this. But can I also put the range as input in for...

Hi All, I'm looking for a way to open my workbook in a separate instance of Excel and then hide the application and show only a userform called Client_Information_UF. After searching around I found this bit of code to create a separate instance of Excel, but if I change xlApp.Visible = True to...

Greetings, I have a need to identify a specific set of characters "VQTY" within a string and return the result "89752". Requirements: - The returned value of "89752" will be static and always remain the same - Regular instance of "QTY" (without the "V") should return nothing (cell remains...

Hello, Looking for a formula. If For instance in a given period, total Sales went from 9 to 11. I need Sale #10 to be at 0.5 and sale #11 to be at 0.4. Last month and this month Sales are in M2 and N2 respectively If for instance, if sales went from 35-42. I need 5 sales at 0.2 and 2 sales at...

Hi guys, Trying to calculate the instances of certain occurrences happening. Count EVERY 1 to 1 Count first instance of Group 1, 2 and 3 Do not count Absent: I want to calculate it at the bottom of the range B5:B16 (so in cell B17). can get certain aspects of the formula but not fully working...

Hi, I have a report that is run from another system, and unfortunately there is no way of altering the format of how it outputs the data. An example of what I get is: Anne 9:00 10:36 a 11:49 13:34 c 14:35 15:10 a 17:00 bob 7:20 7:45 a 8:00 8:45 9:00 c 10:00 11:00 a 13:00 carly...

Hi all, Thank you in advance! I have 2 columns of data: The 1st column is a randomized number list produced by a macro. The 2nd column has unique numbers distributed for each match using a separate criteria (many rows have duplicate numbers because the names match) For instance: AQ AR...

Hello there, thank you for taking the time to read my question. I need to combine two cells via VBA. For instance, if I'm in cell ES128 I need to combine ES1 and A126. (i.e. =ES1&A128) In a nutshell, whatever cell I'm in, I need to combine row 1 of the active column and column A of the active...

Hi Folks, I'm looking for a snip of a macro that will look to column Q, from the last row up, and when it no longer encounters the value 'Q', add a row above that last instance. My list is already sorted but the major requirement is to search from the last row up.

Hi folks, As always, I don't use excel for many moons and then struggle to write any meaningful VBA afterwards. I have designed myself a userformwhich is exactly what I need. Now I am struggling with the VBA to make it work. I need two things. When column “O” is selected onany given...

Good day all, I was having some trouble and wasn't sure if i needed a VBA solution or could actually achieve the result I want with a formula of some kind. basically i have a column of 1s and 0s like column A in the table below. What I need to happen is to create a new Column B that recognized...

Hello guys, I did have a look and search myself - but no luck on finding exactly what i need. I was after a formula that would lookup the below, find the value, and then return the value in the adjacent column. Vlookup does not work for FALSE or TRUE. However if I click control F I am able to...

=IF(AND(D17<=30,F17>9),"Yes"," ") D17 is -50 F17 is 4 The formula should say Yes if both conditions are true but it says Yes in this instance. I don't know why.

Hi, In column B I have ticket numbers and there are 12 instances of each ticket (may grow). In column D I have clients. In column E I have specific text (e.g., alert, no alert, etc). In column AM I need it to show 1 or 0. I want it to only count the first instance of colum B (ticket number) and...

Hi All I am trying to make a search button that when clicked it will find the search term in a specific column and then save the row number in a cell. I have managed to work this out but it can only find the first instance. I would like it the button can find the next instance of the search...

I have a loooong list (2467 rows) of "bad" units of measure that I need to breakdown into a different format for a software conversion. For instance, I need to take Col C, and break it down into Col's A & B as follows. <tbody> A B C Bag (58 oz) Case - 6/58 oz Bag 6/Case - 58 Ounce Bag...

I do not like the way Excel includes all open workbooks in a single instance of Excel. There are times when I need them completely separate. I can do it by typing Excel /x in the command. But is there a way to start a separate instance of Excel by clicking the icon and holding a key? I have...

Just recently upgraded to Excel 2016. I've noticed that when I open up a new instance of Excel, the default Book# file name will be sequential compared to it using the lowest book# based on what is already open For example when if I have no open Excel files and I open up a new instance, it...