| Thread | Last Post | Replies |
|
| Can't separate spreadsheets | 15 Feb 2007 14:32 GMT | 9 |
Using Excel 2000, I've suddenly lost the ability to have different spreadsheets appear in different windows (ie, to open Excel in different windows) which I can move around the screen. They all replace each other in the same window. I can toggle between them using the list in the ...
|
| Sort duplicate fields | 15 Feb 2007 12:33 GMT | 5 |
I currently have a spreadsheet setup where when you put data into cell A2 the current time automatically inputs into cell B2. I now however would like to know how to set it up so then it finds the duplicate of colomn A in this instance (A3) but then inserts the duplicate B (B3)
|
| General multiple new user questions | 15 Feb 2007 11:09 GMT | 1 |
I have to test for Excel 2000, the problem is I have experience on Excel 97 & Excel 2003. I need a quick source for information on built-in features, fundamentals, formatting, formulas & calculations, and entering data in general. Any help is greatly appreciated.
|
| macro to insert x checkboxes down a column | 15 Feb 2007 09:09 GMT | 2 |
I'm trying to automate the process of putting checkboxes with their associated cell link down column Q - say 100. It is tedious to do it manually. The macro I've recorded looks like this: Sub CheckboxesDown()
|
| Autocorrect in Excel - "m2" (square meter notification) | 15 Feb 2007 09:08 GMT | 6 |
Hey guys Do anyone know how to make the autocorrect-function expresse "m2" (square meter) to a format where "2" is shown as superscript? Regards
|
| Spreadshet Help | 15 Feb 2007 04:10 GMT | 1 |
Hi, Trying to create a Purchasing Book. Having trouble with having columns attached with the previous column. eg A2 = B13 (Code) B2 = Stationary (code details) Could some one please help me
|
| Macros on exit | 15 Feb 2007 04:09 GMT | 4 |
Is there a way to run a macro on exiting a cell. For example if I answer Yes in cell A4, then I would like it to automatically go to A10 on exiting A4.
|
| Formatting A .CSV file | 15 Feb 2007 04:01 GMT | 5 |
This is more of a general question, probably not pertaining directly to excel, but worth a try. Any help would be appreciated. If I have a .csv file containing say 200,000 lines of data, which is the best way, or suggessted way to format it (eg add columns, format columns
|
| Help: how to "merge" rows while summing some values | 15 Feb 2007 02:49 GMT | 3 |
sorry for the title, but I have no simpler way to put it: here is the issue: I have a worksheet where different orders from the different customers are shown. I would like to get a resulting sheet where I have only one
|
| Disable Automatic Hyperlinks | 15 Feb 2007 01:32 GMT | 4 |
I have a spreadsheet with names, addresses, phone numbers, and e-Mail addresses. Is there ANY way to stop Excel 2003 SP2 from automatically turning the e-Mail addresses into Hyperlinks every dern time I copy the address or in
|
| append a string of text to all cells in a column? | 15 Feb 2007 01:21 GMT | 2 |
Excel 2003 Is there a way to do this? The cells that I want to append to all contaio plain text. Thanks!
|
| Database design | 14 Feb 2007 22:27 GMT | 8 |
A little while ago (on one of these NewsGroups) there was a thread about using Excel as a database and database design. I undertook to consolidate my thoughts (which were over several posts) on an information sheet. I have now done this and the first effort may now be seen at -
|
| using environment variable in macro path | 14 Feb 2007 22:25 GMT | 1 |
Hiho, at first i am sorry for the double post but i hope to get an answer here because some peaple don´t look in the programming newsgroup but do here... I have a problem with a macro which is linked behind an excel button.
|
| order form | 14 Feb 2007 22:12 GMT | 1 |
help please.... i am trying to create an order form. normally this would be easy enough...item price x quanity etc, but there are some other variables. allow me to explain....
|
| Excel problem | 14 Feb 2007 22:02 GMT | 1 |
I am working on an Excel file for work and thought that maybe you could help me out with the formulas. I initially thought that a combination of an If / sum function would work but I am having a problems.
|