break

Hello folks, Is there a way to Break links (changing links to values) while keeping the rest of the formula? Example: Before: =[File1.xlsm]Sheet1!A1 * B1 = 5 * 1,01 = 5.05 After: =5 * B1 = 5 * 1,01 = 5.05 My objective is that I might want to change cell B1 afterwards. Thanks you for your...

HI so recently I have this code below which ends my macro. The vba I use below on my computer works fine and closes the active workbook and doesn't save it like its suppose. On another computer it started to break in red below. I can not figure out why I tried everything. I even removed that...

Thank you for your help, I understand the break lines now are char(10) and ctrl-J So if i have in one cell the following <tbody> John Smith 123 Main street Mycity, 123445555 </tbody> So if I want name and address and city in different columns then I use text-2-columns and the delimiter is...

For some reason, when I try to change the number of columns that will appear when I print using "Page Break View" I'm now getting only every single cell highlighted -- a mass of squares -- and only half the page is shown when I hit print. This has happened in the past, and I don't remember how...

Hi, I am looking for some help to expand the formula i have. On the table below i want a message box to appear when column D is higher then column C which i have managed to code myself. However where i am struggling with is that i want the message box to display how much higher D is than C...

I am trying to find a name from a list of data on a separate sheet and pull it through to a cell on another sheet: Sheet1: <colgroup><col width="166" style="width: 125pt; mso-width-source: userset; mso-width-alt: 6070;"> <col width="140" style="width: 105pt; mso-width-source: userset...

Is there a way to do V Lookup with multiple parameters. I will try explain as best as i can below what i'm looking for: <tbody> Paid Breaks Name Break Time Available Break Time Used Agent1 Agent2 </tbody> this is what appears on sheet1 On sheet 2 i have the following data...

Hi there. I need tot get the value that is between a set of times. need to get the times that fall in the time bracket 8:15 to 9:20 from the (start time) Also it must only reflect the time (Break times) longer than 35min within the time parameters of 8:15 to 9:2 The second is the time bracket...

I work in an oil field. First 15 days (without any break, without any weekend or holiday) are my working days. Just after every 15 days, I got a break of exactly 13 days. Then I again join my duty for next 15 days and this cycle goes on. Now I want to calculate total working days between ANY two...

Hi All, I have a workbook having 10 sheets. Out of 10 , in 3 sheets I have set a range(i.e.A1 to K30) in page break preview. Now I want user can only type in that particular range but not able to increase decrease the column/row size. Also he/she not able to drag the blue line(showing in page...

Hello! I'm stuck trying to gaps into a table, I hope this makes sense It starts off like this with around 10,000 rows and some redundant columns to delete but I need to (currently) go through and manually add a break in the table to add the order total and total size I'm wondering if I can...

<code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em !important; color: rgb(0, 102, 153) !important; border-radius: 0px !important; background: none...

Hi All I have a rota on Excel that originally referenced a specific cell to determine whether or not to include a lunch break in the total hours cell. I would prefer to simply add this into the IF statement and eradicate the unnecessary extra cell where a lunch break is manually selected...

I have not setup any error trapping. I am just stepping through a macro that I have been working with for about a year. Now, during most commands I get the message, "Can't execute code in break mode". How do I turn this off so it doesn't keep prompting me?

For the table below, I need formula that will calculate the number of straight Time Hours btw the clock in and clock out times, but I also need it to add an hour for everything break hour that is worked through. I tried a combination of conjunctive IF's with AND/OR with no success. Any help is...

Hello All Excel Gurus out there, I need help with designing VBA code to do the following: <colgroup><col><col></colgroup><tbody> Example Desired Outcome *First Line*Second Line*Third Line *First Line *Second Line *Third Line *First Line *Second Line*Third Line *First Line *Second Line...

I am getting 400 error. I was able to run the program once and it worked. However, I get the error now. Data: <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> Original List Planned PO1 Break End PO2 Planned PO3 Break End...

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody> I need help turning one list into two. Can you help? <colgroup><col><col><col span="3"><col><col></colgroup><tbody> Original List List 1 List 2 Planned PO 1 Planned PO1 Break Even PO2 Break Even...

Hello, If A1 has the work TROPICAL, is there a formula that can break apart the letters so they appear as follows: (Note: A1 could have varying lengths of words) A2 = T A3 = R A4 = O A5 = P A6 = I A7 = C A8 = A A9 = L

Hi All, We have introduced a new pay scale at work and I am really struggling to calculate hours correctly. Would really appreciate some help please. I have the following, which allows for a shift start and end, as well as 3 separate break periods. The pay is determined by the time of day...