If I have the following data: Date No 07/04/2010 170 07/04/2010 175 08/04/2010 170 08/04/2010 170 08/04/2010 719 09/04/2010 1190 09/04/2010 340

Can someone please tell me how to assign Macros to a Button?

This may be simplier than I can think of right now. I have 12 monthly budgets on a worksheet. Two of the columns in each budget indicate INCOME and...

Hi everyone I have a spreadsheet where I have locked cells and password protected. within this sheet though I have not locked a specific range of cells as...

Is it possible to send excel docs to onenote?

Here is what i want to do: I want to set up a template/form in Excel that i can send a group of sales reps. They will then save this template on their...

Here is what i want to do: I want to set up a template/form in Excel that i can send a group of sales reps. They will then save this template on their...

have information from different people and want to consolidate it in one single sheet using pivot tabel (without using macro) sample- Data -...

I have a spreadsheet for working out hours worked that ends like this..... Total Hours _ Add Credit brought forward _ Deduct debit BF _ Total Hours for the...

Hello! I have 2 woorksheet. One contains raw data one is a summary sheet. In the raw data shhet, under the "catergory" column, I need to count and filter...

Hi, I'm using Excel version 2003. I have the following formula =IF(SUM('Section 3'!$H$1675:$J$1686)=0,"",SUM('Section 3'!$H$1675:$J$1686)) and would like to...

When I open the excel 2003 document in 2007 we cannot edit nor view any formulas in the formula bar, plus the ribbon is greyed out. The workbook is not...

I need to set up predefined text lists and then link them to certain cells and limit the entry in that cell to the predefined list - how do I do this???

Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to...

I want cell F5 to insert NOW() when D5 has a value entered Not sure what the formula looks like Cheers!!!

how do I get the colors set up on the page to print? My printer does color and I did not have this problem with the 2003 version

Help, my VLOOKUP is just putting the formula into the cell. =VLOOKUP(A13,'Tasks'!A2:D10,2,FALSE) Where A13 is on same worksheet as the lookup cell. What am I...

Is it possible to attach the pop up calender to the worksheet to be able to share or email Or am I using the wrong one and there is another? Cheers!!

I need to use some kind of a Lookup that will grab 2 references for the Lookup conditions. Look up a reference which has more than 1 exact match, so then i...

I have a two columns merged together. I have given each merged cell a name. However, the name appears not only in the name box but also in the cell itself....