| Thread | Last Post | Replies |
|
| Edit Sheets in Excel Addin | 28 Nov 2007 17:00 GMT | 2 |
I created an excel addin and used the menumaker code I found in another post (http://www.andrewsexceltips.com/multi_menu_maker.htm) to create the menus for the addin. The menu maker code lets you type the caption / macro name in a "Menu"
|
| Currency automation | 28 Nov 2007 16:58 GMT | 3 |
I'm having Numaric values in a range from X18:BI52. I wanted to put a dropdown box (Form Combo box) to select currency symbols(USD,HKD,GBP,CNY,INR). By default all values in the range according to USD, the moment when I select other currencies from the list then the values
|
| Sorting Groups of Rows | 28 Nov 2007 16:56 GMT | 1 |
Because I am using data exported from another program, my spreadsheet looks has multiple rows of data for each "item" I wish to sort. For example: Column A Column B Column C Column D Row 1 Dan
|
| Excel slow to open | 28 Nov 2007 16:39 GMT | 1 |
I recently bought a computer that came with a 60 day trial of Microsoft Office Home and Student. Not realizing this, I installed my own full version of the same program. Upon doing so, the Office suite became very unresponsive. The programs opened fine, but individual ...
|
| Monthly Postage Book | 28 Nov 2007 16:35 GMT | 1 |
Has anyone got a template that I can use for entering postage details on for work?
|
| Excel 2007: Selecting multiple objects by drawing a selection box | 28 Nov 2007 16:34 GMT | 3 |
I want to select multiple drawing objects in Excel in Office 2007. The previous version of Excel (2003) allowed you to draw a box around the objects that you wanted to select. This option was selected by clicking the pointer icon at the bottom left hand corner of the screen. ...
|
| Indexing a formula from Sheet to Sheet | 28 Nov 2007 16:30 GMT | 3 |
I have 52 tabs (one for each week of the year). I want the formula to index from one sheet to the next so that I get a cumulative total. The formula does not seem to index; instead, it just copies over. How do you do this?
|
| Graphing | 28 Nov 2007 16:24 GMT | 1 |
Can someone please tell me if this is indeed possible? I would like to make a graph with 2 different Y axis's. First I would like a stacked bar graph (easy on its own; the total range of this stacked graph will most likey be from 1-10). Essentially I am
|
| Excel to Word | 28 Nov 2007 16:18 GMT | 2 |
Is it possible to convert an address in Excel to a label in Word?
|
| Auto Filter question | 28 Nov 2007 16:16 GMT | 4 |
I have a worksheet with 12 pages(tabs). On 11 of these I have a filter on one column each...total of 11 (one per tab)...How can I set up an auto filter so the whole worksheet gets update automaticly?
|
| Move Rows to Columns | 28 Nov 2007 16:15 GMT | 3 |
I have a list of names and addresses that are in rows. Does anyone know of way to move the address and city state zip to columns so that I can do a mail merge and print labels. I know I could cut & paste but that would take a long time.
|
| Macro | 28 Nov 2007 16:12 GMT | 5 |
Question re. macros. Im not a programmer thats writes them but someone who simply records and plays. Got a question about something.... Lets say I have formulae in cells D2, E2 and F2. I have data in A2, B2 and C2 down to A10, B10 and C10.
|
| Find text and move | 28 Nov 2007 16:08 GMT | 7 |
need a formula or macro to find text in columns and move that to the frist column of row. sample the text(apple) in the column M58 or K90. want to move to A58 or A90 by formula or macro.
|
| Format/size | 28 Nov 2007 16:03 GMT | 2 |
Hiya, Currently I'm making Labels for my binders/folders in excel. But the Labels should be of 1 size But if I change the Letter type/size/font the Label get's bigger or smaller.
|
| Conditional Formatting based on a cell value | 28 Nov 2007 15:47 GMT | 4 |
Do you know of a way to do the following: I have to choose if cell "C5" is either "direct" or "stock" - got that part down (validation) In cell G5, I want to have one set of conditional formatting if C5 is
|