| Thread | Last Post | Replies |
|
| Excel spreadsheeet | 16 Jan 2008 15:34 GMT | 3 |
I am working in a spreadsheet and somehow I have evidently hit a key that is incorrect. My column which should show the results of the formula shows the formula. How to I correct this? HELP?
|
| VBA Module Function??? | 16 Jan 2008 15:34 GMT | 3 |
I have programmed the below function into a vba module: Use a VBA function like the one below call with =bonus(b26,b27)
|
| Excel List Box | 16 Jan 2008 15:29 GMT | 5 |
I need help to create a Macro to fill a list box with names from another sheet and then when the list box changes to activate another macro that will display some charts. So far I only have the following code:
|
| Linking Worksheets | 16 Jan 2008 15:27 GMT | 1 |
I have an excel worksheet that the information is populated from an access query that I created. The information exported from access goes to a template sheet I created, now I am wondering is there any easy way to link excel ranges from one worksheet to another, possibly ...
|
| Excel Sorting - Finding Duplicate Entries | 16 Jan 2008 15:22 GMT | 1 |
I have two Excel Spreadsheet with client names. But I want to find the duplicates and create one file. Is this possible without having to go through all 900 names? Thank you
|
| Combining two ideas? | 16 Jan 2008 15:06 GMT | 3 |
Thanks to the NG, I'm able to open file(s) into my CURRENT workbook this way... If Fnum > 0 Then For Fnum = LBound(MyFiles) To UBound(MyFiles)
|
| Macros do not run when spreadsheet is used on a different computer | 16 Jan 2008 15:01 GMT | 6 |
I created spreadsheets with multiple Macros. When I transfer the spreadsheets to other computers sometimes the Macros do simple not run at all or the debugger comes on or create error messages or even more confusing some Macros in the same spreadsheet run no problem. Some users ...
|
| Complex macro issue | 16 Jan 2008 14:58 GMT | 2 |
I have a very big spreadsheet which is divided out in job areas…there are 20 or so job areas and each job area has a few roles in it (can be between 5-10) or maybe more. This information needs to be copied from this sheet into 20 other sheets (so each job area goes into a new ...
|
| cell change | 16 Jan 2008 14:56 GMT | 8 |
I have the following code: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo stoppit Application.EnableEvents = False
|
| Formula to ask what Time/Date it is. | 16 Jan 2008 14:38 GMT | 5 |
Do you have any ideas what formula I could put together to set up the following criteria: Purpose: to determine what time/date a cell is populated with. Action: If the date & time are < 14:00 then put today's date, if it's after
|
| Comparing 2 different work books | 16 Jan 2008 14:38 GMT | 1 |
If I want to compare 2 word docs and highlight the differences between them I use: Sub IsDocument_Equal() Dim oDoc1 As Word.Document
|
| Range Formula | 16 Jan 2008 14:35 GMT | 5 |
I need help, I am trying to do a bonus calculation for Budget and Atual sales. In b26 i have actual sales and in b27 budget. Here is what i am trying to do. Budgeted Unit sales bonus
|
| Spin button | 16 Jan 2008 14:29 GMT | 2 |
Hiya How do you use the spin button? Arrow up arrow down ... hmm could be useful. Anyone got a quick tutorial on increasing and decreasing a cell by +1 and -1 ?
|
| Selecting the secon column of a separate range | 16 Jan 2008 14:25 GMT | 3 |
Hello, I'm working with graphs, what I want to do is a kind of difficult to explain, I hope you understand what I'm trying to say. I have The following data: a b c d
|
| Automatic calling of a macro | 16 Jan 2008 14:25 GMT | 4 |
I would like to know if there is a way to call a macro to run when a particular cell, say A1 on Sheet1 for ease, is changed. A1 will be changed by a formula calculation, not by a user hard coding an input. I currently have a button to call the macro and do its thing, but I ...
|