cut

Imagine you have a very long roll of material, (Rolled up like a big spool) and out of that material, you cut sections of material out of it. For an example, we're dealing with a 72" wide piece that's 1000' Feet long. If you were to never cut anything from it, and look at it as if it was...

Hey everyone, I'm pretty new to this so sorry if this is a rookie question. I have a pretty hefty spreadsheet at work that I'm wanting to do some enhancements to, so I'm working on it at home with a mockup of the same format (false data and not such intricate formatting is the only real change.)...

Looking to do something like this on a Command Button If Range("N9").Value = Range("E8").Value Then 'Run another if statement code here' If Range("N9") = "" Or Range("O9") = "" Or Range("P9") = "" Then 'Do Nothing' 'If Cut Section, Length, And Width Is NOT Empty...

So.. I'm trying to create something in excel that can help us keep track of cutting fabric. Let's say I started out with a 500' X 72" roll of fabric. and then let's say I start to make cuts on it. So let's say I cut off 130' by 40" wide. It would leave me with 370' X 72" and then a remainder...

Is there a way to look down column C and remove the row and paste to the bottom if a certain name appears? ie if any cell in column C has "Totals for SELF PAY", it would cut the row and place it at the bottom and keep going down the work sheet?

hi everybody! i am having some trouble in using pivot table after a few years break so so if anybody might guide me what am i forgetting i am working in garment cutting and for every new order i have to maintain a record of the measurements 1: cad pattern 2: first garment 3: first garment...

I have a sheet which is populated using index match formulas pulling data from other sheet locations. Is there a formula that I can place in a "helper column" that turnsthe index match formula results to text so I and then do a search? Essentially a formula that works like a "cut and paste as...

Hi How can I start that wizard from the menu/ribbon without using these short cut? I want to consolidate sheets using pivot table-->consolidate Thank you.

Hi, I've just added a right click event to call a macro which works fine but it also it is bringing up the normal cut and paste menu. How can I disable just the cut and paste menu? Thanks Dan

Hi, I have a complex procedure I'd like to do in a macro, and I'm having trouble getting it to work. I work with contract management for support contracts. When I download a customer's contract information, the output file looks horrible, so I'm working on a macro to clean it up. I've already...

I'm sure this is a very basic question for the folks here but, not being an Excel guru I figured I would ask the experts here. I am working with an Excel sheet on a regular basis which I update each week. This involves a lot of cutting and pasting. Sometimes when I do my updates and use the cut...

Hello, I'm looking for a VBA script for the following scenario, kind request to suggest a method. Ques: I've a series of columns Range (A:HZ) (around 200 columns) with 10rows (fixed). I want to cut every 2 columns (following from C:D, E:F till HZ column) and concatenate the cut columns data...

I am looking for some help building a file. The basics are that we sell a product that we can often buy in many different lengths (500', 1k', 5k', etc.). This product is then cut to length requirements and sold to the end user. I would like to accomplish two things with this, first determine...

Hi Excel Community, Long time code thief, first time poster.... I'm looking for assistance with Cutting, Pasting and Deleting rows from Sheet 1 to Sheet 3 ("#PRU"), based on a list of values from Sheet 2 ("Codes"). I have investigated several codes from this and other forums, however I can...

Hi there I have a cell which contains the following formula: =INDEX(C7:L46,MATCH(1,(A7:A1048576=O1)*(B7:B1048576=MROUND(O3,0.1)),0),INDEX(4:4,MATCH(MROUND(O2,25),6:6,0))) I need to cut and paste this cell into Sheet2 in the same workbook. The formula references automatically update as...

Hi All, I have VBA code modified from Ken Puls post here VBA Express : Excel - Disable Cut, Copy, Paste, that blocks users from Drag/Drop and Cutting (all except the Cut on the Ribbon) but an unintended consequence is that it affects the clipboard so users are not able to paste data from other...

I am hoping someone can point me in the right direction. I have some simple code that I got help from here and it allows a user to click on a cell then it activates another sheet. How do I stop anyone from right clicking on tab and looking//amending code. I would also like to stop anyone being...

Dear MrExcel members, I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me. I'm looking for a macro/vba code/solver solution for the following problem: I want to make groups of 4/5/6 products that are...

Is it possible (with VBA) to "cut" the contents of the EDIT COMMENT box from the active cell and paste these into a USERFORM TEXT BOX? Thanks Al

Hi, Not really sure the best way to describe what I need to do but I'll give it a go. I have a stock listing for one of our customers of all we hold for them and they want to see a cut down version of this on a different sheet in the same workbook but only items that meet certain criteria...