break

I have a loooong list (2467 rows) of "bad" units of measure that I need to breakdown into a different format for a software conversion. For instance, I need to take Col C, and break it down into Col's A & B as follows. <tbody> A B C Bag (58 oz) Case - 6/58 oz Bag 6/Case - 58 Ounce Bag...

Dear All Is it possible to do start and pause the time on VBA Form..? For example, I have select any activity type from Combo box 1. Time start in Text box. after half an hour, user wants to take a break. Here, user can click a button say, "Pause". It will stop that time, and if he selects...

Hi all, I have the following table to Discount the annual rate to get the present value. I am wondering if there is any formula that i could implement to get the monthly Discount factor so that i can figure out the difference. <tbody> Annual rate 8,00% Discount factor PV...

Hello! I've had this issue crop up a few times now in the same project, and I can't make heads or tails of it. The most recent time: I have 5 comboBox shapes on a worksheet, and when 1 of the comboBoxes changes it resets the other 4. Code looks something like this...

Hi Everyone, I need a macro to add horizontal page break every 40th row within Sheet "Data" range AD3:AJ851 So first page break is AD43. also I need it to set it so its One page wide. Any ideas how I can do this? Thanks Tony

Dear All I have a break time calculation excel marco enabled. with this file, i will get the total break time of my staff in a day and weekly total working hours and break timings. i try to get the daily working hour and break time on daily basis but it not worked. the daily working hours...

Hello experts, I have the following the dataset. <colgroup><col width="111" style="width: 83pt;"><col width="99" style="width: 74pt;"><col width="91" style="width: 68pt;"><col width="103" style="width: 77pt;"><col width="88" style="width: 66pt;"></colgroup><tbody> Queue Start Time End Time...

Hello- I'm still new to VBA and do most of my coding with recording and modification so I may need a LOT of help here. I have a table that lists Part #, forecast values, and dates-in-months. I need to find an easy way to convert the months and values to weeks. E.g. P0421 - 2018M03 - 30000...

Hello Does the page break I set on a worksheet change while I open the workbook on a different pc? My friend is having that issue with a workbook I sent him. There is this button on the form that creates and opens the pdf of the print area of that worksheet. It works fine on my pc but on his...

I'm currently trying to create a formula that automatically calculates a win/loss record based on increases and decreases in postgame rating. The following formula was working great for me until we decided to make changes to how we record time spent...

I apologize in advance for the novel that follows I have created a technician break schedule for a project that can run 20 hours or more. The schedule is dynamic in that it will expand to the number of technicians that are onsite on any given day, which varies from day to day. The technicians...

Hi all, I use VBA to enter array formula linked to external file (cloud). At the end of my code, I break all links. This results in cells with no values. This is because Excel needs a bit of time to download the content but because I break links immediately after the code, the values are...

Is it possible to have a conditional format rule on a cell based on whether or not in column M it says "Break". Basically if the text anywhere in column "M" says Break that cell should be conditionally formatted. Any help would be much appreciated. Thanks!

Hopefully I will explain this well enough to understand outside my brain. I have 2 columns of shift times (Shift Start and Shift End) all on the even rows. Under their shifts is the row that has their Lunch break start/end times. I need to get an interval count of the number of people staffed...

Can't seem to find this on the net. If I offer a discount of 10%, how many more units do I have to sell in order to break even on GP$. I can't seem to find this formula. There are plenty of charts, but that does not help me.

I want to place my userform in a specific position on the screen. When I run the code in break mode and step through it, it works fine (slightly down from the top and a bit in from the right) When I run it outside of break mode, the userform gets placed in the upper right corner of the screen...

Good afternoon, Can anyone please tell me why the following formula will not put a line break at the end of the first two statements please (like ALT-ENTER when in a single cell)? =CONCATENATE("Title ", TEXT(INDEX($B$18:$B$2517,MATCH(E$10,E$18:E$2517,0)),"#,###,##0"),CHAR(10)...

Is there a way to break a cell of numbers so that each digit has its only column? i.e. cell contents are: 2345, is there a way to break that into four columns so 2 is its own cell, 3 is its own cell, 4 is its own cell, etc.? Scenario: each number represents an edge condition, each edge...