Dear Friends, In an excel sheet, for a particular column cells, say for eg Column A, I have to choose the values in each cells, similar to combobox in VB. i.e...

Need formula to figure amount of sales per person in a given month. columns currently a Inv#, Date, Sale, Net $, Salesman # Need formula for monthly sales...

I have a column which includes dates when items were purchased. I have used the DATEDIF function to find the number of years between that date and today's...

Hello. I have a Excel file that contains a large list of Tracking Numbers. The tracking numbers are from two sets of order types- Internet orders and Mail...

students are required to complete a designated number of homework assignment, then receive a bonus or penalty for every additional or deficient...

I made the mistake of getting up from the computer without saving and my son closed my workbook. Can I recover the workbook with the new items as I...

hi community is it possible to print data from different location example: i want to print colum B and data from colum H when I used ctrl+select and do a...

hello, i've been reading up on all the sumproduct related posts, but can't figure out what's wrong with mine... this is my...

Hi how would I write a formula to calculate the following cell b2 contains 0.02169 cell B3 contains 0.01590 cell D2 contains 5860 and column G contains...

CRAIG KEITH WEEK 31-Mar PET REG 07-Apr PET REG 14-Apr MAIN PET REG 21-Apr PET REG 28-Apr MAIN PET REG 05-May PET REG MAIN Ok, the above rota shows who is on...

Hi im pretty new to this forum, tho dabbled in a bit of excel before. Basically i have the following FName SName Install Date aaa bbb ...

It is possible to create quickly an excell table with borders and shadings (with rows darkened and lightened alternatively) like it can be done with Word...

Ive created a macro and I would like to send it to another user in order for him to run it on his proper excel files. Ive sent him the file with the macro...

I have created a number of headings to choose from depending on what action or actions I am to take with an item. I am used to using Access where I...

I have a list of 600 names. I would like to generate a random number between 1 and 600 for each person but not have any repeating numbers. So far I have...

Since the spreadsheet I use is also shared by many other users and manipulated (sorted etc), I'd like to insert the validation list on a diferent worksheet. ...

I am new to Excel (and this forum) & want to make my own General Ledger, Monthy Synopsis, Trial Balances, Financial Statements etc. for a new business. I am...

Cell BM6 Sheet1, has a formula that gives me a numeric total. The total belongs in Column D1 Sheet2 after the last entry, and there will be cells that will...

I'm new to excell and want to print gridlines. (Office 2003) With the gridline box checked or unchecked the gridlines do not print. Obviously, I must be...

everytime i copy and use paste, an item "hello!" appears, i cannot use the copy or cut on shortcut keys , please help.