separate

<tbody> E F G Target Status (Days) Actual 3/15/2019 33 4/17/2019 4/1/2019 FALSE 3/22/2019 4/18/2019 </tbody> I'm trying to calculate a field using IF statements, but I have 3 or 4 separate situations that I need calculations for. Here is the function I'm using...

Hi all, I have a user who wishes to have an input cell and a macro will automatically filter input data based on the value in the cell. The input data that he would like to filter on is numerical but his input will be a text string. For example, user inputs: "1-3, 6" in the input cell. My data...

<tbody> Coordinates Latitude Longitude 3.321151, 101.575798 Formula to Seek Only Before Comma Formula to Seek only After Comma </tbody> Possible ?

Hi, I want to put previous 6 months' Sheet Names in last sheet of workbook. Sheet names are in MMM-YY format and each month new sheet would be added with new months data. The requirement is to put each sheet names either in separate rows or in separate columns. Can somebody please advise a...

I have a cell with thousands of values and I need to parse the values into separate cells after every third value. Text to columns only wants to separate every value, but I need to keep the values in groups of three.

Range("F26").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-1],'F:\infestor profiles\UK Holdings BP\[Things things things.xlsx]Sheet1'!C3:C5,2,FALSE)" Range("G26").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-2],F:\infestor profiles\UK Holdings BP\[Things things...

I have see the answer to this here, but cannot find it now that I need it. I need to take a very large spreadsheet and make separate tabs in the same spreadsheet based, in this case, on a combination the county and state columns. (each County/State will have a separate tab in the...

please, separate the quadruple of 8 digits without repetition ex = 09 18 27 36 = yes 09 19 29 36 = can not have 3 digits 9, so it has repeated deletion separate only quadruple with 8 digits singles http://www.mediafire.com/file/clyc9117hy6667a/quadrupla_loteca.xlsx/file

I have a sheet which hold job information and hours for several different employees for each month. Each job has its own code so for example there may be 10 separate entries that have job code A10. Is it possible to create a list on a separate page that automatically copies across the job codes...

Hello all, I'm wondering if it's possible to make 2 separate excel workbooks to talk to one another. For instance if I have a credit card receipt in one workbook and a separate workbook for projects- am I able to make the first spreadsheet talk to the second spreadsheet and add in the correct...

I have a list of addresses in Excel that include the county of each person. I would like to do a mailing for two of the counties only. How do I separate these addresses out?

Hi all, Long time user, 1st time poster :) I have about 700 lines of salary to move into three separate columns (C3, C4, C5) on the right, some of the employee numbers are in the column A more than once, depending on the different rates of pay they get and to do this manually is painful. There...

I am doing data analysis (historical data); however in the name column, i am facing the formatting issue like ["()", "extra space", "-" ]. When i try to do analysis, each name goes as a separate entity and couldn't able to make proper analysis. How to bring all the name in the same basket...

Hi I hve a cell with as many as 100 lines and which can change depending on user input. I can find how many lines there are using, but I want to separate the lines into different cells. Is a way to separate number of lines just like we use mid, left and right with number of charaters? Thanks

I would like to split the date next to my text in the cell below using a vba code, but the text will sometimes change and i only want the text in the first cell, not the date. The first column of my table is what I have and the right column is what I want. <tbody> JOHN (02/02/19) JOHN...

Hi Team, Can you please help create a VB which is helpful in creating pivot table and also details for each sub total in separate worksheet . Sub totals from pivot table must be moved to new worksheet of same workbook. kindly help.

Could someone please provide assistance in transposing every nth cell of a column to a row on a separate spreadsheet.

Hi can someone help me with some code. I have one work book with two tables "Table1" and "Table2" both are on separate worksheets. I want to copy these tables to a new workbook and each on a separate worksheet. Can someone please help me with the code of copying the two tables. I tried to...

Hi All, I have a master file, with about 30 names in it. I am trying to copy each of those names into a separate workbook, which would mean 30 separate workbooks for each name. Is this something I can do with a Macro? Please help! Thanks

Hi all! I am being asked by a co-worker if this can be done. She wants to create a file that will contain links to workbooks in 3 separate files. One main file with active links to several workbooks in 3 others. I've done research and currently use ASAP Utilities but I am not finding anything...