3/8

Hello, Does anyone know how to exclude words from an array? I currently use a macro that uses an array to move items with a specified thickness to another tab. The problem is it also catches screws, since they can be 1/4 FHCS, 3/8 BHCS, etc. I need a way to omit "fhcs" and "bhcs" from the...

Hi all! I would like to sort by size but its size x size like the fallowing ( I already tried creating a custom sort list but that has a max 255 characters) Any ideas how this can be done? 1/4" 1/4" x 3/8" 1/4" x 3/4" 1/4" x 1" 1/4" x 1-1/4" 1/4" x 1-1/2" 1/4" x 2" 5/16" 5/16" x 1-1/4" 3/8"...

Hello, I have a file that I work on a weekly basis to upload item options, and these item options require abbreviations. These are limited to 15 Chars. So Items options are Alphanumeric, have symbols "/" "-" etc and I've been saving the abbreviations also alphanumeric. For example, some of...

Hi, I have a program that generates a cut list of materials depending on size and type of unit. Now the guys just take the files and manually aggregate it. I would like to do this programatically. I want to sum the quantity where the width, length, thick, and Matl. match. Red totals 20 parts...

I am looking to write a macro to compare and 'match' 2 data sets. They are currently in separate sheets and consist of: Sheet 1: Sales Table with Sale Date & Sale Amount: <tbody> Sale Date Sale £ 1/8 £710 2/8 £834 3/8 £692 4/8 £672 5/8 £768 6/8 £452 7/8 £890 </tbody> Sheet...