pcs

Hey Folks, I have been running a excel file for a while now with no issues but recently i have had a problem on my PC. I have Application.Visible=False on This Workbook and it works fine on other PC's but on mine it closes the App then opens it again immediately. The code must be good...

Hi guys, I have to make an ERP (by day it looks more complex) like a database in excel with: production type, ok PCs, ng PCs, time and other losses; key machine parts replacing, these parts lifetime; employes's on the shop floor with their leaders; lines, processes; ..... (for abbreviation and...

<tbody> A B C D E F G H I J K L M N O P Q R S 1 SR. PRODUCT BAG PKT STRIP PCS QTY1 QTY2 QTY3 QTY4 QTY5 TOTAL QTY BAG PCS PKT IN BAG STRIP IN PKT PCS IN STRIP 2 1 MD 19 PKT 3 STRIP 8 PCS 380 240 150 20 8 798 960 24 4 10 3 2 FR 2 BAG...

1 BOX = 600 PCS 1 BOX = 15 PKT 1 PKT = 4 STRIP 1 PKT = 40 PCS i.e. A=290 PCS B=100 PCS C=350 PCS D=132 PCS E= 460 PCS F= (A+B+C+D+E) = 1332 PCS NOW I WANT CONVORT THIS QTY IN BOX/PKT/STRIP/PCS i.e G= BOX H= PKT I= STRIP J= PCS I WISH TO GET RESULT LIKE BELLOW G=2BOX H=3 PKT I=1 STRIP...

I have this paper I would like to input into a excel sheet so when someone add the number to the "pcs ran" it automatically completes the rest. "Ind 1 X 2" would be pcs ran time 2 added to the current number in the line above it. How can I do this? <a href="https://ibb.co/m654yA"><img...

Excel 2007 <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody> Voucher Number Date Party Name Item Name Item Group Item Description MRP Item HSN Item GST Acutal Quantity Rate Unit Discount Discount Amount Amount 001/S/18-19/PN...

<colgroup><col><col><col><col><col></colgroup><tbody> Posting Date Document G/L Acct/BP Name Inventory UoM Qty FG00017 500 Litre Water Tank White 02.08.18 SI 2109 Finished Goods Pcs 14 02.08.18 SI 2109 Finished Goods Pcs 13 02.08.18 SI 2111 Finished Goods Pcs 11 02.08.18 SI 2111...

Hi , I would like to hide some row that doesn't have any value for each cell within a row, here below sample table : <tbody> Items / Stocks Nov Dec Jan Feb Office Desk 3 pcs 6 pcs 10 pcs Office Chair 20 pcs 40 pcs 10 pcs 80 pcs Printer fax machine 3 pcs filling cabinet...

Welcome, I've got data as shown. My role is to sort them / group them under some conditions simultaneously: condition no 1: for one group of 'H1' maximum 'PCS' sum is 25 / for H2 is 9 (condition no2 must be kept) condition no 2: sum of val multiplied by 'PCS' is not greather than 9 for...

I have 3 sheets that contain data as shown below: Posted sheet: <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> Item Code Name Date Trans. Type Trans. # UOM Pack Quantity Total 101 Patty -Whopper 3/30/2018 Out 18873 CAS 144 2 288 103 Patty -Chicken Roya...

This seems like a really simple problem but I keep running into this issue over and over again. I'm a student and I have assignments that ask for specific themes/layouts in Excel 2016. I have Excel on both my PC and my Macbook, and most of the time the theme that was requested will be available...

I have a small Add-In that I created on my local PC. It is saved on our network shared drive and I need to get it on the rest of our computers (a dozen or so). Is there a way to easily install it to each one without having to manually copy the file into the AddIns folder. If I browse to it when...

HI EVERYONE IM NEW HERE IN MREXCEL. I'M WONDERING IS IT POSSIBLE TO PRINT PC AND PCS IN EXCEL 2010. I've tried using if function in cell B1 =if(A1<=1,"PC","PCS") successfully when I type 1 in cell A1 I got "PC" when I type 2 or up I got "PCS" my problem is if i type nothing it showed "PC"...

I work in an excel file every week, and the file size is so large it crashes my PC. Is there any way to get around this? Would storing the file in sharepoint be a way of not using my PC's memory to open the file?

Hello, I have a order sheet where we type in orders from our customers. It has some cells where we type in quantity for each product, now i want to "transfer" the cells wich have som contents in it to another sheet. I need to create this csv file for importing into our accounting system. I...