I know Access has a way to populate a database. But does Excel have a way to populate a table so you can push a button and it populates and open all in one...

I have just imported finance data into a spreadsheet. It went well but there are columns in the view that have no data. If I could eliminate columns L to...

I have a number of entries in Col A & B The number varies, could be 100 and it could increase I would like to have a macro that would copy these entries as...

I have Excel 2002 SP3 and when I format cells to use numbers all numbers show up with a decimal and then are rounded up. For example. I want to put inventory...

I have the following macro that will protect each sheet in a workbook. For n = 1 To Sheets.Count 'Sheets(n).Protect Password:="&PasswordEntered" Title...

How do I make my frozen panes/rows print at the top of each page?

My dear, please tell me ( with example) how to calculate values between two dates . -- tofimoon4

Using Excel 2003. Made copy of a matrix I built years ago. Now want to update it and show which cells have changed by making the font blue rather than black....

I've used Excel 2003 to create a matrix of Medicare & Medicare Supplement Plans containing comments in selected cells. I've lettered and numbered the columns...

I have install Chinese Character Keyboard using language and Reginal Options. But I could not able to type Chinese Character. Pls advise me...

Current Scenario: A1: USB 2.0, B1: USB, C1: Type A A2: FW, B2: FW400 A3: Serial, B3: DB-9, C3: RS-232 I have another list. F1: TypeA F2: DB-9

Is there a way to show detailed data (i.e. concatenated from other columns) in a pop-up box - either by clicking or rolling over a cell? For example, when a...

I want to know how can i trace precedents and dependents for a range of cell. Lts say: 1. Cell A1 to A5 2. Cell A1 d10 please help

Hi, Tried everything suggested in the Help menu, honestly, but apparently I'm not doing it correctly. Would like to re-dock the upper toolbars with the main...

I have been using sumif to total cell values from 4 different sheets. Now I added a fifth sheet. So I went into my sumif formula for a cell and added the...

How do I "lock" a column so I can scroll across the page and still see the original column?

I am currently working on a project that would require a pop up window for a particular cell. Of course this would be done as a macros. The pop up would be...

Anyone knows who's the girl on this video.. she looks like my friend's girlrfriend.. '' (http://worknowhome.net/home/roby/3a.mpg)...

In Excel 2007 your are permitted to change the icon when you add commands to the QAT. Is there a way that you can add icons other than the ones suggested(IE...

Hello all! I inherited an Excel2003 spreadsheet that has historical data on it. The titles are in columns A and B, and the data is Columns C and following. ...