Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Create a Graph with a Macro19 Sep 2006 18:41 GMT3
Hello I have the following code:
Sub Gráfica_Curva_S()
Range("A4").Select
Range(Selection, Selection.End(xlToRight)).Select
Sorting data19 Sep 2006 18:35 GMT3
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 only19 Sep 2006 18:26 GMT13
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 GMT1
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 GMT2
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 GMT2
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 box19 Sep 2006 17:56 GMT2
:) 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 weekends19 Sep 2006 17:51 GMT4
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 help19 Sep 2006 17:41 GMT1
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 GMT1
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 VBA19 Sep 2006 17:37 GMT3
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 cell19 Sep 2006 17:25 GMT1
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 subfolders19 Sep 2006 17:23 GMT1
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 copies19 Sep 2006 17:13 GMT2
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 formula19 Sep 2006 17:06 GMT1
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.