| Thread | Last Post | Replies |
|
| Move data within workbook | 27 Aug 2007 18:50 GMT | 2 |
I need to know how to move data from worksheet 1, A2 to D13 to next available row in worksheet 2 of the same workbook using a command button. Cells contain text, currency, and dates.
|
| Macro error when worksheet is protected | 27 Aug 2007 18:42 GMT | 2 |
I have the following macro in Excel 2000: Private Sub Calendar1_Click() ActiveCell.Value = CDbl(Calendar1.Value) ActiveCell.NumberFormat = "mm/dd/yyyy"
|
| Dynamic dropdowns | 27 Aug 2007 18:22 GMT | 3 |
-- What I need is in auserform a way of selecting a value from a dropdown list and depending on the result 1 of 3 different lists of data being loaded into a second dropdown list box in the same userform. I have seen http://www.xldynamic.com/source/xld.Dropdowns.html But cannot ...
|
| Need help in creating a formula | 27 Aug 2007 18:16 GMT | 5 |
I need to create a spreadsheet where I take daily totals (mon-fri x 4 weeks) and come up with a billing total of hours. For instance we charge $1.75 for a half hour and $3.50 an hour for care. I need to be able to put in something like 3.5 on a mon and say 2.0 hours Tues etc. ...
|
| See Data behind Pivot Table | 27 Aug 2007 18:04 GMT | 2 |
I have a source sending me reports in Excel Pivot Tables that I don't really want. I need the raw data, and I keep getting Pivot Tables. I've been searching the help files for how to get the Pivot Tables off so I can see the data behind them, and I'll I'm finding is ...
|
| Excel 2003 Using the keyboard | 27 Aug 2007 18:02 GMT | 13 |
I need to use the keyboard in Excel rather than the mouse for health reasons. Does anyone know where I can find a list of keystrokes for Excel commands. I'm not so much looking for keyboard shortcuts, it's for things like accessing the "Name" box (above column 'A'), or filling a ...
|
| Insert New row if Column G = "P" | 27 Aug 2007 18:00 GMT | 1 |
I can't seem to get this, but if I wanted to run a macro that would start at cell G50 and move upward to Cell G18 testing for the
|
| How do you get outlook to select from list on a form | 27 Aug 2007 17:54 GMT | 1 |
I want to send an email to a group of people from a listbox that has been populated from selecting from another listbox (and sheet). How does outlook take the new list and send the form or sheet to the people in the selected box?
|
| Help?! Format Cells for ALL CAPS | 27 Aug 2007 17:42 GMT | 1 |
I am setting up a template and need to format some cells/columns to come in all caps for State abreavations. I expected to find the all caps option in the format text menu but did not. The only info I've found gives me a formula to pull in text from another cell and make it ...
|
| Circular Reference | 27 Aug 2007 17:22 GMT | 2 |
I am working on an inventory spreadsheet. I am trying to get a total for each item in a separate column. Each item has multiple rows due to the number of locations. The formula I have tried to use =IF(A2=A3,V3=V2+U3,V3=U3) does not work. (A is my item number column, U is my ...
|
| tough cookie | 27 Aug 2007 17:17 GMT | 3 |
I have readings (hourmeters of water pumps) in random days. In column A i have all days of the year, which means i have holes in my table. column B has the hours when the readings were made and column C has the readings. In column D i have the reading of a certain day minus the ...
|
| Adding Dashes to a 25 digit alphanumeric cell | 27 Aug 2007 17:02 GMT | 7 |
I have a column of 30-5k consisting of a 25 digit alphanumeric code. I need to reformat these to have dashes every 5 characters. example: XXXXXXXXXXXXXXXXXXXXXXXXXX to
|
| Excel background gridlines on worksheet-how do I remove from view | 27 Aug 2007 16:53 GMT | 8 |
How do I get rid of the gridlines that appear automatically upon opening worksheet?
|
| Excel graph legend | 27 Aug 2007 16:52 GMT | 2 |
In Excel 2003 I have created a graph with a legend for 3 x data series but inadvertently deleted the legend for one of them. I have looked everywhere - how can I reinsert this?
|
| linear adjustment in excel | 27 Aug 2007 16:50 GMT | 3 |
I am trying to take a set of columns of numbers and adjust them so they are all the same length. I.e., i have data that looks like 1 0.2454
|