answer

i need 00901002409 as 009-01-002-409 with the preceding 0's when i try <colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> </colgroup><tbody> 00901001120 =TEXT(G4,"???-??-???-???") 00901001122...

EDIT: Nevermind - I figured it out. Used xlPasteAllUsingSourceTheme. Hello, I'm trying to paste a sheet from one workbook to another (in the exact same formatting). The code works really well, but I'm having difficulty getting it to paste in the exact formatting. I tried xlPasteAll (gets me...

So I have 2 worksheets. Sheet 1 contains 425 rows and the last column being used is O currently. The first column contains a unique identifier number. Sheet 2 is used to send out mail merges it contains less rows until it is filled and the last column being used is S currently. Now in Sheet1...

Hello I am trying to get a shift name based on a timestamp in a different cell. For example if my timestamp says "6/19/2019 13:41:37" I want the word "First" to show up in the next column to identify the shift name. I have searched and searched for an answer to this and cant seem to find it...

(I am simplifying the data to make explaining easier) I have a table G60:G75. Some with data some with blanks. I then have H60:H75 all with data. I need the sum of the number of times the data in G60:G75 matches the data in H60:H75. 1 5 2 2 3 3 4 4 5 So for the...

Hi all Me again So I have another one that doesn't give me any errors, but it is also not executing the code. It gives the correct msgbox and filename but when pressing save absolutely nothing happens. It doesn't actually execute the code. Not sure why. Private Sub CommandButton3_Click()...

I am finding the differences between adjacent numbers in a column. All have been verified by ISNUMBER enquiry. The answer is always 0, no matter the format of the answer cell. Please! Why this happening and what's the solution?

https://1drv.ms/x/s!AnJwxxiz0Ezpg8c6oid-OUrUmz6fiw I need help with a if statement in P16 answer show AWAY and P17 be HOME Thanks You Thomas

Hi, if i had cell value for example =21+22 answer should be 2 as it has used 2 value in the formula =41+40+41 answer should be 3 as it has used 3 value in the formula now in adjacent cell i need the count of values in that formula <tbody> =21+22 2 =41+40+41 3 </tbody>

Team, I am trying to get a "new" formula in cell B3 that if I type a number in cell C3, then the answer in B3 needs to be 0. The current formula in cell B3 is =(A3/5.5)*3.1 Thanks for the help. Roy

hi trying to set up a job sheet template to keep track of hours and materials on the job can get the material side of things sorted ok item cost quantity and total all add up fine . but when i try sum to add up the hours worked on the job it comes up with the wrong answer ? is there a way to...

Hi, Hope you can help me? I am using the below string and it is giving me most of the answer, however I want it to be blank if either R13 or S13 are blank...

I am using the following formula, =B84*C84+E84+G84. and when the previous cells are empty I get zero for an answer, is there some addition to the formula that will get rid of the zero's?

Hi all, :) I know many of you use a specific window when you put the VBA code you use in that forum. I would like to know how you do it . Many thanks for your answer Regards

Hello. Im new around here. I wasn't able to answer the question I was looking for by googling, so wondered if I'll find it her. Maybe someone will answer. I'm looking for a way to make in formula bar sum numbers to be colored, like here. I want numbers to have different colors. In example every...

Hi guys, i want to conver the data on A1 to separate question and answer as expectation. Could you help me to resolve it? I have many record like A1, i want to automatic. Thanks. <tbody> A B C D E 1 <tbody> 1. Which of the following applications/software can be used to create a...

Good Evening, I have a range of cells that are filled with text that is either Green, Amber or Red. If all the cells are Green then the answer is Green, if there is a mix of Amber and Green then the answer is Amber, if all the cells are Amber then the answer is Amber, if the cells are a mix of...

Hi - first time posting here. Hope you can help. I'll try and be as clear and as concise as possible. I have 12 questions (which form part of an assessment). Each question carries a simple "Yes" or "No" answer. This gives me 4096 different possible outcomes (2^12), for a completed assessment...

I have this VBA to auto generate an email upon completion of a form and a submit button, however, due to consistent issues with their information I need to add the ability to not create the email and attach the form if the text boxes are not filled out. Does anyone know of a means to do that by...

Firstly thank you for taking the time to read. I am tryingto put together a spreadsheet that has simple maths questions, subtraction andaddition. So if I have in cell A1 the number 2 and in cell B1 the number 3 Iwant cell C1 to turn green when the number 5 is entered and similarly if...