I am trying to make a budget worksheet that will highlight a cell a certain color if a certain percentage of the budgeted amount is met. Currently in A1 I...

I am trying to sort numbers like this in one cell: ..875 x 1.655 x 96.75 ..500 x 1.800 x 97 ..875 x 1.655 x 108.75 I can get the first 2 sets of numbers to...

Hi, I am creating a spreadsheet to track the number of hours I work in a given day then adding them up for the month. Column A is my regular hours, column B...

I would like to ask how one can use the copy paste utility in the terms of coping image (photos from My Documents) and paste the pathway of it in an excel...

Hi All, I am developinga spreadsheet where the user will enter the following data for each entry which will accumulate in a table. Start Date ...

Hi. Thanks for helping. How can I lock in the custom column width adjustments that I have done with my cursor? When I change the column width, save the...

Wish you a Happy New Year I have to maintain our representative database & send it to our head office lilke A B C ...

Thanks for reading this :D ive made, and been using a cricket score sheet for some time now on excel. for those who dont know all i do is write down names of...

Hi All, E.g. in cell A1, sheet1, I have =sheet2!D12 to reference whatever is in sheet 2, cell D12. I want a formula that looks into A1 to see what is...

I am getting closer I think. Here is an example: =MATCH(N1255,'1 HOUR ha ANALYSIS'!$N $8:$N$3000) This brings the cell number of the match which in this case...

I am using excel 2000. I am trying to create a drop down list but not able to give the range of input as there is no option in Forma Control. How can I give...

hi, i need to copy row high from one worksheet to another worksheet, is there any way to copy the row high ? ( just like paste colom widths )

Hi I have a rota with 4 people who's initials I put in next to a corresponding date. When someone is on holiday I want to be able to change the validation on...

Hi, Could somebody pl. help me find the value of my return at the end of the nth year using compunded annual growth rate formula? I am unable to get it. My...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: methods and. tactics -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= They deliberately set out to harass in a way that would...

I wish to have the active workbook being worked in sent as an attachment to an email once a hyperlink to an email address has been clicked, is this possible?

Hi, wish happy new year to all, i want create the printing software with use macro/vb , thr is any possible iam new to the vb and macro , kindly guide me...

I have tried to develop a formula that returns the 15th of the month (if today() is = to the 15th) and the end of the month's date (if today() is greater...

Hello! Here's my situation. I have a workbook that has 12 worksheets titled the months of the year. When I copy the entire January worksheet to the...

I have two columns for employees to enter start and end times, If there is less than 10 hours off from the previous off duty time, the next on duty time...