As you know in office you can add a formula to a cell and then drag this formula down the colum, for example when doing household credit and debit accounts. ...

I created a concatenate function to build the columns out for an internal wiki page. The page is a formated table of values. In order for the page to...

I need to crease a dependent list where the use can select multiple options to the validation selection. for example, my list contains each state, the...

Hi I have got a problem with an If Statement that I am trying to create. Cell A1 is a variable number (but I will use -24, for the example) A3 = -9 A4 =...

Hello, I'm creating a spreadsheet, and I'd like to have some of the cells default to negative values no matter what value is input (positive or negative).

In Column 'D' I have a list of dates in the form MMMM/YYY Column 'E' contains whole numbers which represent a no. of months In column 'F' I wish to deduct the...

Hi all, I have a problem splitting up data into seperate workbooks. I have a workbook with 3 worksheets. One is data of one worklist, second is data of...

I need a way (formula, format, etc) for the background color in one cell to be determined by the data entered in another cell. For example: Cell C6 will...

hi, I have a macro in a worksheet that selects the last populated cell in a range (D18:V18), copies the formula from this cell and pastes it into the next...

my worksheet has changed to some kind of coding can anybody help me to put it back on normal veiw?

Hi... My question has probably been answered somewhere in the community; but either I cant find it or I'm just confused. I have 2 workbooks, Workbook A and...

I once created direct links to my hard drives / pen drives so that they appeared on the left side of the SAVE window, and have forgotten how to do it. Any...

Hello All, I'm very new to this excel macro writing and have been able to create and run a macro to prohibit printing. It runs in the VB editor, but not in...

This seems like it should be an easy question, but is there a way to subtotal by an amount, then sort the groups by that amount? i.e. get total Acct....

I have a macro that loads a variable length data spreadsheet (n rows) into an instance of a template. I then want to copy a formula into a blank column of...

Hello everybody! I have a big problem accessing programmaticaly the metadata of the document, I have create the document with a sharepoint library that add...

Is it possible to take a series, such as the Item Number example below, and then filling it into a column that already has text in it? What I want for it do...

Hi I hope someone out can help me with this one. I will attempt to explain as clearly as I can. In column A I have a range of numeric values 0 -5,000,000 in...

Hello, all!! We are in desperate need of some help. In sorting two different workbooks with similar data, we are experiencing an unusual headache. Following...

Hi, I would like to round time to the nearest minute in Excel. For example have a time that is 7:03:01 and 7:03:59 and they both appear as 7:03 with the...