The days of the week consists of 'Name' 'Date' Hours' The 8th sheet consists of 'Name', 'Days of the week in their own column (7 columns in total)', 'Total Hours' and 'Total Days Worked' Now. Allport structura si dezvoltarea personalitatii. The first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours. I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. I just need true or false response as to whether all three values are the same or not. I don't care about obtaining detail about which value matches which. So essentially it would be like doing =IF(a1=a2=a3,'match', 'nomatch') But of course this isn't possible. Of the three values there is no master, Each value may be different. I am trying to find a way to compare all three values to establish if they are the same. Hey I have three columns containing last name values from 3 different sources that I've brought into one sheet. Is there a way to lock the position, let's say, in the upper right corner and have it stay there? This would be quite useful for an EXIT button, that I have created, that will close the program without saving (it's a read-only file.) Thanks to all the wonderful people here that have been so helpful and give us their valuable insight and time. No matter what I select, the object moves off the screen, when the user, scrolls to the right of the spreadsheet. I find the properties of an object, I see how I can 'lock', 'size and move with cells' or 'not move with cells'. I have searched and read all the help files. I have got a formula that works for a single cell but I can't figure out how to get it to apply to more than one cell. If any of these values are greater than 2% I would like a 'Fail' to display in cell B1. If all of these values are less than 2%, I would like a 'Pass' to display in cell B1. Here is the problem: I have a column of 14 numbers in cells A1 to A14. I am looking for some help with a spreadsheet I am making. Hello, I am new to using Excel and I am not very computer literate. My outlook express (using same account and SMTP server) works fine. View the training video before you study the complete VBA code given below. In end effect, we actually use the SMTP (Simple Mail Transfer. Any suggestion to remove the error message? When I tried to execute the following code, the got the following error message: - Run-time error '-(80040211)' The message could not be sent to the SMTP server. The SMTP server name is the same as I set up my outlook express outgoing mail and which works fine. I stole the following code from Ron De Bruin's website with minor modification.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |