General

VB code
I am using Office 2007. In Excel, I like to write a code in Visual Basic to copy the contents of the cell above into a blank cell down below and repeat the procedure until it reaches the bottom of the data. All the cells are not blank cells. Only a few of them are blank cells. Example of the column 03/01/2008... 25 Mar 2010 23:12

Mail merge
Hi , I am doing a mail merge, on e for the fields is a weight which displays as ..425. When i do the merge this field displays as .4251111333300000 or similar. Cheers -- Nenagh ... 25 Mar 2010 22:03

Always On Top
Can someone please advise how I can have Excel on top of any other programs I have open at all times? ... 25 Mar 2010 19:46

Protect or Unprotect Cell dependent on different cell
I am trying to find a way of automatically protecting a cell if an adjacent cell has a specific value whilst if that cell has a different value the cell would be unprotected. For example if I am aiming to have a column with values in that will be entered but if a field next to it has a 1 in the value field wil... 26 Mar 2010 10:24

Default font for pasted text in text boxes - Excel 2007
I am having a problem with text boxes in Excel 2007. When I copy text (in Arial font) and paste it in the same text box, it appears as Calibri. I would like it to appear as Arial, just as it was when I copied it. I followed the directions for setting default font in new workbooks to Arial, and I have this ... 25 Mar 2010 17:28

help with if & order ..??
i have a book that has 3 columns A B C id name accounts i have 500+ entries, all w/different ids and names but the accounts are the same because i only have 4 accounts. what i need to do is add 4 columns (1 for each acount) and show in each new column only the ids of the employees w... 25 Mar 2010 18:37

fill in date into adjacent cell automatically
I creating a basic checklist in an Excel spread sheet and need advice on how to fill a static date into the adjacent cell. e.g. when I type any caracter into A2, I need the current date so fill in automatically into AB. The date must not reset each time I open the work sheet. So far, I got this formula. =IF(D7... 25 Mar 2010 18:37

Vlookup and combine all references
I have various items in a spreadsheet. Some of these items are repeated in another row, but have a different text description for it. They all have the same reference number, just a different description. I want to combine all the descriptions into one cell. I am doing vlookup, but it is only putting in the fir... 26 Mar 2010 09:11

Variable Range of Values
I am trying to get a formula to put the values from a list together into one cell, but the length of the lists are all different lengths and styles. Here are two examples of the lists I'm dealing with and what I'm trying to do: A B C 1 AZ2_MO 5-12 2 ... 25 Mar 2010 16:16

How do I delete the words Page 1 printed across my spreadsheet?
The large gray words Page 1 are printed across my Excel spreadsheet. I would like to know how to remove them Thank You ... 25 Mar 2010 16:16