separate

Hi, I have formed a template that will be used for monthly reviews. Each month has a separate template in a separate sheet to be filled in. First sheet includes a copy of the template and is for January, second sheet includes a copy of the template and is for February, and so on. If I want to...

My data looks like this: <tbody> c2=\Data Tab\Get & Transform c3=\View Tab\Show/Hide\Ruler I am looking for a function - for this example named Parse where Parse(c2,"",1) equals Data Tab Parse(c3,"",2) equals Show/Hide </tbody> Public Function separate(field As String, separator As...

Hi all, Is it possible to view 2 different worksheets from the same workbook on separate desktops on a Mac? Thanks!

<tbody> Joe & Sue Smith 123 Main St Chicago, IL 60601 Lets say I have a large column of data in this exact format. Any way I can separate this out quickly in excel into a name, then address, then city, state, zip formats? </tbody>

Hi Guys Need your assistance in separating the words given in the subject line For eg : the subject line as below Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information I want to separate word which comes after Returned CI till ":" or "-". In this...

An easy one for the forum I'm sure: I have a list of these: <tbody> Wed Aug 01 11:13:36 2018 I would like to take the date only and have them in a separate column like this 01/08/2018 All help welcomed, tia </tbody>

Hi All, good morning! What i am trying to do is when 2 sets of criterion are met (e.g. Name match not blank, and then if another cell is "yes") i want to copy the data from the input form and into that specific row (for the individual with that name that has been matched) which has been...

I am very green with Macros. I have a worksheet where a Macro is being used to hide or unhide a separate worksheet based on a dropdown value in a particular cell. My issue is, I need to do this to a 2nd drop down that will hide or unhide a separate worksheet from the previous as well. I am not...

Hi, I have a workbook consisting of a large number of worksheets that I'd like to separate, using VBA code, into a number of smaller workbooks, with the criterion used to separate the sheets being the date in cell A6 of each sheet. Each sheet has a date in cell A6 in the text format...

Hello all, I am newbie in this forum and excel VB. I have a hard time to find duplicate value when comparing multiple values in 2 separate cells. As there are many record i'll need to compare, so would like seek help here and solve the problem by VB. Example as below...

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!

Hi excel gurus, I have a set of data with many number range within a cell which i want to separate into individual numbers. Example of the cells as follows: <colgroup><col></colgroup><tbody> 37441; 37443-37448; 3745; 37460; 3749 37449; 37477; 37488; 37493-37495; 37498 37410 297...

=SUMIFS('GJS2'!$C:$C,'GJS2'!$A:$A,GJNETS!$A8) I need to be able to add 0999 client separate from 999 client and it's adding them together. Iv'e for mated it as text and tried putting the whole code in a SUMPRODUCT.

I received a spreadsheet that was submitted from an outside source. I have invoices in one column then the line items of that invoice all in one cell to the right, then the corresponding charges. Is there any way to separate the codes and charges to be in separate cells on multiple rows...

I need help understanding how this formula works =SUBTOTAL(9,C2:C187 This is used for payroll, the sheet has employees with hours worked over a two week period. I have totaled the hours by employee in a separate column and it does not equal the total in C. Any help will be appreciated!

separate the trios with 6 different digits example = 06 13 25 = we have 6 different digits. yes can not have digit repeat ex = 01 12 24 we have the digit 2 repeated no can not only to separate in a list next to trio formations without repetition of digitios...

Hi All, hoping you can help me here - <tbody> Bevan010: Available 255 / Required 424 </tbody> The text above is an example of data that is exported from a system we use, what i would like to do is to grab the numbers of of this string into two separate columns. so in the example above...

Hi all, I've got a large data set (roughly 1,500 cells) that I need to split out. They are currently formatted like this: <colgroup><col></colgroup><tbody> CHICOPEE, MA TO Rocky Mount, NC MCDONOUGH, GA TO ROCKY MOUNT, NC ATLANTA, GA TO ORLANDO, FL I'm trying to separate this into four...

In a particular cell we have multiple lines (separated by alt + enter), I need to be able to get a number of these entries. For example if in this cell I have A A A C on separate lines within the same cell, I want the formula to return 3 for A and 1 for C. At the moment it is returning 1...

Hello. New to the MrExcel. I'm currently building a form that requires separate instances of cells being cleared based on cells from other worksheets changing. Private Sub Worksheet_Change(ByVal Target As Range) 'When E1 changes, E2 clears, and c20, d20 .... j20 all clear. If...