| Thread | Last Post | Replies |
|
| Create a Graph with a Macro | 19 Sep 2006 18:41 GMT | 3 |
Hello I have the following code: Sub Gráfica_Curva_S() Range("A4").Select Range(Selection, Selection.End(xlToRight)).Select
|
| Sorting data | 19 Sep 2006 18:35 GMT | 3 |
Is it possible to create columns using data from a single column? I have four columns of data. The fourth column of each row contains of one of three different values(PT,OT,ST). I would like to use these values as column headings to sort the rows of information.
|
| wrap text function causes data to disappear in cell (visually only | 19 Sep 2006 18:26 GMT | 13 |
When I use the wrap text option for a cell, the data in the cell is no longer viewable when I move to another cell but is clearly still there when the cell is activated again. The data string can be any length so exceeding the maximum number of characters in not the problem. ...
|
| Excel 2003, how do I save without having to say overwrite? | 19 Sep 2006 18:24 GMT | 1 |
When I go to save a previously saved Excel spreadsheet, I get the message that the file "may have been changed by another user since I last saved it. In that case, what do you want to do?" I am given the option of saving a copy or overwriting changes.
|
| Time calculation assistance need...., maybe.... | 19 Sep 2006 18:17 GMT | 2 |
Hi all..., I have a range of various times arranged in a single column..., <D2> = 8:29:46 AM, <D3> = 9:57:59 AM, <D4> = 1:38:40 PM..., etc. Using a formula or function in the column to the right, I want capture and display just the hour
|
| update calendars in Excel? | 19 Sep 2006 18:04 GMT | 2 |
Is there an easy way to update calendars from one year to the next? I know there are templates posted for upcoming years, but I would like to be able to update a template for attendance tracking of my employees and the only one posted is for 2005. See Attendance calendar 2005 ...
|
| Picture in comment box | 19 Sep 2006 17:56 GMT | 2 |
:) hi community i can insert picture into the Comment Box but the picture seems to expand and becomes blurr, how big is the Comment Box size, anybody know ? appreciated :)
|
| Pivot table grouping excluding weekends | 19 Sep 2006 17:51 GMT | 4 |
The data has a field called "Date". In the pivot table, the grouping is set to display the dates in 3 day groups. Is there any way to do this type of grouping but only use the weekdays and exclude the weekends?
|
| Data Validation help | 19 Sep 2006 17:41 GMT | 1 |
I am using Data Validation in cell A1 to choose 1 of 30 items and then I would like to use validation again in Cell A2 but the list of information in the pull down for A2 is dependent on what was selected in A1(30 different lists). How do I make the A2 validation list dependent ...
|
| Why would hyperlinks in a spreadsheet change to an invalid path? | 19 Sep 2006 17:38 GMT | 1 |
I created links in a spreadsheet to external Word docs stored on a shared network drive. When I opened the spreadsheet today, the path had been changed to C:\Documents and Settings.... How can I prevent this from happening?
|
| Copy/Text To Columns/Transpose in VBA | 19 Sep 2006 17:37 GMT | 3 |
I have a string of numbers, each separated by a space, in a single cell. I want to take that string, do a text-to-columns, and then copy-paste special-transpose into a single column. I tried recording this macro, but I have too many numbers and it will exceed the 256
|
| how do i copy data from one sheet to another by d clicking a cell | 19 Sep 2006 17:25 GMT | 1 |
i have two worksheets. one store inventory and one sales reciept. all products have item number in first column. when i sell an item, i want to be able to double click that cell and auto copy other data in that row to the sales reciept worksheet.
|
| Opening files in folders and subfolders | 19 Sep 2006 17:23 GMT | 1 |
Hopefully someone can help me with a minor glitch in the following marco. The macro is set up so that it opens a file in the C:\Output folder formats its, splits each worksheet into a separate workbook and saves it before moving on to the next file in the folder. While this works ...
|
| is it possible to progresively number multiple copies | 19 Sep 2006 17:13 GMT | 2 |
Is it possible to print multiple copies of a worksheet with a progressive page number on each copy
|
| transfer a highlighted cell to another worksheet using a formula | 19 Sep 2006 17:06 GMT | 1 |
Hi - I am trying to transfer a highlighted cell to another worksheet by use of a formula; the cell will not always have data in it and more importantly require just the highlight itself.
|