pipe

Can anyone help me adjust my macro. I just need it so that any rows with Value 'Q' in Column A are skipped and not exported to the pipe seperated sheet ? Thanks. Alex Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord As Range Dim myField As...

I have a large Excel file with over 85k rows, that I feed into our system to read and apply the data. I have a field where my values are separated by a pipe as shown below: NU001|NU002|NU003 BA001|BA001 BE001|CS001 I am trying to figure out how to identify rows where the data on...

Hello, I have 475 feet of pipe that I need to cut to the following sizes. Each pipe is 40 feet long (480 Inches) so I want to optimize the cuts in order to stay as close as possible to 12 pipes. <colgroup><col><col></colgroup><tbody> Inches QTY 8.00 20 10.00 6 12.00 8 27.00 2 32.00 6...

is it possible to exclude some entry on grand total? let say i have this pivot table. i dont want Pipe to report/count on the QTY column There's another data for him (length) that he will counted. Is it possible to achieve this in Pivot? Thanks guys...

Hello I am working an PQ view that will allow me to use the current column (Pipe Length) that I have added to sum but only if the column (PRGM_Code) is equal to"1". Ten I need to divide the (pipe Length) column by 12. We I use the dialog box "Grouped By" there is not conditional formatting...

Hi, I have a number of tables (in a single sheet). Each table has some properties (temperature, presssure) pertaining to a particular pipe material group. What I want is that when i select one of the material groups (in another sheet), it displays all the values related to that table underneath.

Hi All, Going to do my best to explain what I’m looking for here :-). So I’ve created a table that calculates a quantity of an item (eg the amount of pipe required for a project by room) this results in a range of pipe lengths. What I’m hoping for is a formula to group the data (as efficiently...

Rearranging numbers so column c before is column a in next row but also need it to but the last c row number in the next row if it applies <tbody> <colgroup><col><col span="2"></colgroup><tbody> Pipe DTH03528 DJ-0936 Pipe DTH04898 Pipe DTH02677 MLA-0435 Pipe DTH03024 Pipe DTH05084 DJ-0925...

This is a complicated question to ask and I am not sure exactly how to ask it. I am attempting to make a pipe sizing tool to speed up one of my work processes. The procedure is pretty straight forward. Do some math to figure out GPM going to drain (done elsewhere) and then look up the pipe...

Hello everyone, I've been scratching my head on this one and as a mere dabbler in excel formulas I think it is far beyond my skill. I'll lay out exactly what I want to do. Firstly, Check whether or not an inputed value falls within a given range determined by checking individual cells in a...

Modification to the attached excel sheet that uses Microsoft Power Query as follows. Keep all functionality working with these modifications. Employee Schedule Sheet- Option to sort by trade I would like the option to sort by trade then jobsite then alphabetical… Also dates should remain in...

I am looking to calculate the overall pipe length required for manufacturing... For example, the known data is a Pipe (50mm diameter), a bend with a Radius of 600mm and an ANGLE of 45 degrees. The Data is laid out as; Pipe Size 50, Degree 45, Radius 600, Cut Length ??? The sample...

Hi all! Are there out in the Forum, one or other person, with good math understanding? I need some help, to find a way to calculate an outer measure (outer to outer of the bend), on a pipe which are bended 2 times, in an angle on 180 degrees on each, and to make a formula in Excel, for this! I...

I am trying to use VLOOKUP to match the text in Field C with the text in Field A and then populate Field D with the values from Field B. The formula I am using is =VLOOKUP("*"&C2&"*",$A$2:$B$7,2,FALSE). The first table below is the results I would like. The second table shows the results that I...

I have searched the internet but have not find the proper solution; however it seems that several users have the same problem. My current client receives a .csv comma delimited files from the source. In these files, some fields contains commas that appear in a text file in double quotes. Editing...

Inherited Script that needs a modification. Unfamiliar with VBA code. Script creates file a text successfully and formats columns with Pipe, however I need to Exclude First and Last row (header/footer) with "PIPE". Sub pipey() 'Create a text file with each row cell delimited with "|" Dim...

When I converted excel to text file via VB code, the default text file is tab delimited. Why is it so? I've done: Sub ConvertToText() ActiveWorkbook.SaveAs Filename:="E:\EXCEL\TEST.txt", FileFormat:=xlCurrentPlatformText, CreateBackup:=False End Sub Can I change the default delimition...

I want to be able to have this code work with any selection within a worksheet, currently it starts at "A1". I thought I could fix it with the following: Set rngLastCell = Selection. _ Currently it works, but targets at "A1" rather than the selection. Any help would be appreciated...

I am trying to use ConvertXLS.EXE from the webpage listed below. I have 4 Excel files with 3 tabs of data each. I am trying to convert to a pipe delimited text file. In the output folder I designate, I end up with 4 files. Not only that, each file pulls data from only one tab. How do I...