sign

I have two Excel file, the first one has no macro on it and the second one has a macro on it. First, i open the spreadsheet which has no macro on it. Then I open the second excel which has a macro on it. Now if I hit the X sign on the top right corner to close my first spreadsheet then it closes...

Hello Team, I need an up and down arrow sign which should show the result. If it is above that it should give green, if it is below than red. Below is the sample data. Please fill the formulae in the empty box. <tbody> Sign <tbody> Hours Required/Day </tbody> <tbody> 774:33:32...

Hello there! Is there a way to permanently save the signature setup information so I don't have to keep reentering the same information over and over again? Every time I have to keep filling out the below fields. I want to be able to sign off on a document instantly. I will likely be signing...

I need sign in sheets to populate based off of a master list. I need them to populate based off of what crew they are assigned to. For example I need a sign in sheet for all of the people on John Doe's crew to be on one sign in sheet and Jane Doe's crew to be on one sign in sheet etc. When...

I know that i can generate barcodes using the font; however, if i purchase a barcode reader is there a way to make it so that any employee(if i give each employee their own barcode) can sign out tools ( also using a barcode) and then sign them back in when done? I am basically wanting to create...

I have a workbook that I don't want anyone else to print except the supervisors. I have a list of those supervisor's ID's in a range on a tab in the workbook. All of our users have to sign into the computer using their ID. I am looking for some code that will compare the user sign on to the...

Does anyone know if I can use a QR code with an Excel document? I am wanting to use the =now() as a sign in/ sign out for my classroom and allow the students to scan the QR code with their phones. Does anyone have any ideas?

x=... y=... 5*(x-y)= if "x" and "y" are with different signs (-/+ or +/-) the formula should be like that, but if "x" and "y" are with same signs (-/- or +/+) in the brackets should stay only one value with his sign - the absolute value of (x and y). How should it look like?

Hi, I am trying to figure out how to implement a regex solution to a data field and was looking for some help. I have got a fair bit done using mid and search/find but I am still doing a lot of clean up to the data after extraction to compensate for the different way people record the same...

Hi there, I have a huge speadsheet, originally written with £'s in mind I have been given the task of turning it into a multi-currency sheet. It has literally hundreds of cells with formulas such as: =CONCATENATE(A108," £",I108) where the £ sign is integrated into the formula... I have made...

Hi, I need a way to work out if a time is between 2 times including the original time. Please see below for example; <tbody> </tbody> <tbody> Sign out time sign in time 1:00 1:15 1:30 1:45 2:00 2:15 2:30 2:45 1:00 2:15 </tbody> so IF there is a sign out time at 1:00...

Excel 2007 I'm trying to create a timesheet. I want to display the elapsed time as hours: % of hours, in other words, 6:30 should be 6.5 hours. Cells are B2 - sign in time format time - 1:30pm C2 - sign out time format time - 1:30pm D2 - elapsed time...

I have a document that I want to be signed twice. I know on Excel you can have a signature line but once you sign that once, the file is final and can't be edited without removing the signature line. How else can I capture two signatures?? If I could also have a cell auto populate the date and...

Hello everyone! I'd like to have an addition to my VBA script that will look for last entry in column C, and put text 5 rows below that entry. The same in column H. I like to have dots "......................." and text below dots - "Sign here" or something like that ...

Hi, I have a column of data that is formatted like this: "+$ 29,635.94" for positive numbers and "-$ 50,000.34" for negative numbers. How can I just get the numbers without the negative or positive sign and the dollar sign with the space after it? Thanks!

I am trying to hyperlink to files in my Matlab generated excel sheet. Unfortunately many of the folder names holding those files have a name including a "#" sign. What I can see is that Excel uses this sign for other purposes, which may cause this problem. A typical hyperlink look likes this...

I am trying to write an If-Then statement that performs an action if the header row of the column of the active cell contains a plus (+) sign. For example, if the active cell is C23, it would check if C1 contained a plus sign. I feel like I'm pretty close with the following code, but it's not...

Hi All, I have a quick question: I have a column of cells with fixed numbers. In order to process them I need to add to some the % sign and o others the £ sign. Is possible to do it automatically instead of one by one by hand ? many thanks!

Ok for some reason when I run my Macros things get moved around in my Manual labels I created. So to get around this I shut down all my formulas in my manual label sheets then rename em back in. Easy solution. But lately I have been running into issues??? I am not sure if it is because of the...

I can sign projects in Ofice 2007 but the new version of office seems to be missing this feature??? Any help available pls?