help me

i need to update a time stamp whenever a sheet is updated, but not opened. i do not have macro privelages. i am also a newb to excel so a walkthrough for a 2 year old would be nice

I appreciate any help in advanced. I have promised my boss a Excel Spreadsheet calculating accrued interest to date on judgments we were awarded by first thing in the morning. Now at 3:00am I am ready to give up! Here are the columns for my spreadsheet related to my question for with an...

Hello everyone and thank you for checking this thread. My problem is kind of complicated but I'll give you a general idea of what I'm hoping to achieve. I am creating an audit sheet. I have an "Expectation", "Measurement Criteria", "Weight", "Number of Deficencies", "Score", "Positive...

Hi everyone, I hope that my question comes across properly. I have three cells, one cell has a date the next cell a number (for an amount of days, like 5) and the final cell has the formula. When a date is entered into the first cell, the formulated cell adds the number to the date. So say...

Hey All, I have a spreadsheet here that I need help with. You can download it here (the file name is Prices.xls): http://www.sendspace.com/file/mysnw2 I have a macro that is affecting each "Day." (i.e. Day1, Day2, Day3, etc.) Here is what it's doing: Private Sub Worksheet_Change(ByVal...

I have a list of 200 names in Excel. I need to randomly select 3 names from the list of names making sure the person does not receive duplicate names or thier own. Placing each name in a different cell next to the person's name on the list. Example... Their Name Person #1...

for some reason i have up to row 91 and then it skips to 4107 there is nothing hidden. the row number from 2-91 are blue. i can not find them please help

Good Morning all from the UK, I am trying to create a Vlookup to return the value from a cell that falls between the range of two others. For example cell value is 6 thich falls between 5 and 10 so returns 0, I dont want to list every number as this will make the spreadsheet to big...

hello im having and issue trying to index and match. i am trying to index & match K3 number to a array on a seperate sheet. the number in K3 is in Column A and i need to match the according number from F3 to the same sheet as well. down and then over and have those results in J3. please...

this may be harder then the last issues i have had, i hope i can explain it well enough for some to understand and help. here it goes i created another sheet with my table array Height across the top in row 2 columns B-AO and value 1 is in row 3 column A and all the associated values between...

I have a very large file with two columns with about 40,000 rows, is there an excel formula to match the same numbers in column A to the same numbers in column B and all the other non matching numbers to be pushed to the bottom of the columns?? please help me

hello, i posted yesterday for help on my IF formula and worked great. now i want to move the data that is the lookup to sheet 3 and lock sheet 3 so it cant be messed with and its out of the way. how would i change the folowing formula to reflect this. =I4-VLOOKUP(H4,$Y$3:$Z$36,2,0) thank you

hello my name is skylar and i am trying to use the following formula in a cell. it is comparing height vs weight standards of individuals...

hi guys, basic question...i think!!!! how do i copy sheet1 to sheet2 so that when any changes are made to sheet1 these will be reflected in sheet2??? assignment due 8 hours ago :biggrin: