Hi T. Valko What does One do to become a "MVP" ? Regards John Greetings from Montreal,Canada

I accidently deleted the last 2 hours of excel 2003 data. I have not saved the revised sheet and the undelete shows not available. Is there a place where I...

Hi I have thefollowing macro to transfer information from one sheet to anothe however it doesnt like the 'Lr = lastRow("DestSheet")' can anyone please...

I am creating a form whereby applicants will need to check a box next to a set of criteria, and then points assessed to those criteria will be applied. I...

I have a set of data which I have highlighted values 3 in red and values 0.3 in green. Using these criteria all of my blank cells end up with green...

I am in the process (still) of making a Bill of Lading in Excel that transfers data onto the Packing List (our program at work is horrible). I have a total...

Dear Expert, How to split a cell into 3 parts if they are like this please ? Befo 9j36 in one cell After: 9 j 36 in 3 different cells Befo 10°32 in...

I am running some simple percentage formulas, but the rounding errors are driving me nuts.. If I add the numbers and use that to find my percentage it gets...

Not sure if this is even possible but here's the scenario. Want to change date on worksheet 1, have the lookup function find the date match on worksheet 2...

I am in the process (still) of making a Bill of Lading in Excel that transfers data onto the Packing List (our program at work is horrible). I have a total...

I have tabs in an excel spreadsheet set up for different individuals. I want to put in a password that allows that specific user to open up their tab only...

I would like to create a spreadsheet where I can I can exclude weekdays. I want to only show weekends for this year, 2009

I have a spreadsheet that pulls and stores data for a quoting tool, in the on the proposal sheet this information may sometimes need to be changed before the...

I have multiple columns of data and my first sort by is A to Z, then by a custom list that is by size - xs, s, m, l, xl, 2xl, 3xl, 4xl. The sort request...

Can anyone let me know if it is possible to protect a sheet, but still be able to merge certain cells. I tried to allow users the access to 'format rows' and...

Thanks for your response Rick, I was really very poor with my explanation but here it is: I have 2 sheets as follow: 1 with a list af purchases done thru the...

Is there a formula that will take a dollar figure such as $15,231.23 in one cell and have the written value of that cell to another? If the dollar amount is...

I am looking for a way to count dates in a range of cells and have Excel calculate how many cells have a value that is not equal to 0. Basically what I want...

I have a column where I have a list of items numbered both by section (call it integer M) and by the item within the section (call it integer N). Thus the...

I need to use a DAVERAGE function to determine the average annual salary. Here is my information: =DAVERAGE(Table2,"Table2Salary]] Salary]",D16:D17) My...