| Thread | Last Post | Replies |
|
| Using a macro to edit a macro | 02 Dec 2007 11:44 GMT | 1 |
Short summary: I want to create a macro that will open up the excel vb/macro editor and simply edit existing subs/macros with some fairly sophisticated search and replaces. Note: the macro actions I intend to create are
|
| Vlookup Or ccount if comands | 02 Dec 2007 10:54 GMT | 1 |
I want to to display the data in column B if column A="Sack" I assume the Vlookup will work or the count if. Many thanks
|
| How to reduce Excel worksheet view and find horizontal scroll bar | 02 Dec 2007 01:02 GMT | 5 |
I can't see the bottom of my Excel workbook including the tabs and the scroll bar. What can I do to fix it.
|
| count number of column's with Yes IF column A is a 1 | 02 Dec 2007 00:43 GMT | 4 |
I hope you can help. I have very limited knowledge of excel so treat me as an idiot please.... This is my table so far: 1 yes no yes no
|
| Need to re-arrange a field | 01 Dec 2007 22:50 GMT | 7 |
We entered about 1000 records including a date column (entered as text) but in the wrong order.. it was entered as ..... dd/mm/yyyy .... e.g. 10/06/1886 I really want it to be ... yyyy/mm/dd.. e.g. 1886/06/10
|
| Defining a numeric system | 01 Dec 2007 20:29 GMT | 19 |
I am trying to get Excel to build a list for me using a special type of alpha-numeric system. I would like to be able to fill in the first 3 cells and then be able to drag it down from the bottom right corner to create a list. Here is the format I am working with...
|
| Remove 1000 separator space problem | 01 Dec 2007 19:40 GMT | 3 |
I am importing through a query numbers which the 1000 separator is a space. To calculate with this value isn't possible in excel because the 1000 separator is this space. I am try to remove the space in excel with find and replace " " to "" but
|
| saving excel files | 01 Dec 2007 16:06 GMT | 2 |
How can you save multiple files (3 at a time or more) to a flashdrive . Thanks.
|
| Scheduling Workbook | 01 Dec 2007 13:20 GMT | 1 |
Kind of an awkward situation really. My boss has asked me to set up a worksheet that allows him to "color in" the cells corresponding to the shifts that workers request/will work. I did so by giving him a legend to copy from that has text in each item that matches its
|
| Updating a workbook | 01 Dec 2007 13:15 GMT | 1 |
Hi I have been updating a copy of a workbook with a new sheet and a couple of macros. I have done it in a copy of the original for trial and error purposes. Is there anyway of easily copying the new stuff to the original(s) now
|
| find biggest numbers in row | 01 Dec 2007 10:45 GMT | 2 |
Is there a way in excel to scan across certain columns, per row and find the highest value? EG: Col1, Col2, Col3, Col4
|
| Changing color of cell | 01 Dec 2007 05:13 GMT | 1 |
Excel: In an if statement can i change cell fill or background color if correct
|