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 / New Users / May 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Bridge data from Website into Excel03 May 2006 20:27 GMT4
I am trying to come up with a simplified way (instead of copy and
pasting thousands of lines weekly) to pull data from a specific web
site and pull the data into an excel file.
Where I can I begin to find information on this topic? Is there a way
Searching for a specific string03 May 2006 20:05 GMT1
I need to extract a specific string of data from about 300 cells, and copy
that string from each cell to another cell.  This is what I think the search
string should be "DIR:*;"  The * indicates where a 7 digit number will be
with an _ and a username.  Is there a way to do this?
Different Column widths03 May 2006 19:57 GMT3
Can a spredsheet have different column widths within one column?
I'm trying to set up a form. I dont need to use any formulas at all in this
sheet.
Thanks,
Changing the background color of my Word Screen03 May 2006 19:57 GMT1
I don't know how messed this up, but the background of my Word Screen used to
be purple.  Somehow now it is gray.  I tried looking under "options" to see
how I could change this back, but there is nothing under options that would
accomplish this?  Can anyone help? Also, if it ...
Date Format03 May 2006 19:32 GMT3
I copy a SQL Query output and place it into Excel. The time column
shows dates as
4/7/2006  4:02:10 AM, 2/28/2006  10:37:39 AM, 3/1/2006  1:56:40 PM.
IS there a way to get rid of the hr, min and secs ?  I used the format
macro when there is none03 May 2006 19:19 GMT2
Just recreated a book, that used to have a macro in it. I have not had the
time  to put the macros into the new version, yet it keeps telling me that
it has a macro in it when I go to open the file. I can't seem to find any
references to any macros in it. Am I missing something ...
text to rows03 May 2006 18:47 GMT5
I there a way to put text to rows instead of columns?  What I am trying to
do is take a cell with reference designators separated by commas and copy
them to individual row.
ex..   C1, C2, C3, C4
Advanced Pivot Table03 May 2006 18:45 GMT1
I am trying to prepare a pivot table wherein I am not sure where I am
missing my eyeballs ;)
The first tab sheet contains data as below.
SBU, Domain, project,Emp#, Empname, exp in years, exp in months, exp
MATCHING COLUMNS03 May 2006 18:19 GMT2
I HAVE A QUESTION ABOUT MATCHING COLUMNS IN EXCEL.  FOR INSTANCE I HAVE
TWO COLUMNS ONE IN A AND ONE IN B WITH ALL DIFFERENT VALUES.  HOW DO I
MATCH COLUMN A WITH COLUMN B?  AN EXAMPLE IS BELOW
          A                                             B
uk tax calculator03 May 2006 18:19 GMT21
hello i'm trying to make a wage calculator in excel that works out your tax
and NI ( UK )  i think i need to work a formula out on my topline  but not
sure how to do this as my wages are diffrent each week.
please help
Copy column widths from one spreadsheet to another03 May 2006 17:34 GMT1
I need to copy (reapply) the column widths from my formatted
spreadsheet to another one.   I get an new copy of the spreadsheet each
week from our finance admin with updated data and I want to copy over
just the column widths (and if possible hide certain columns) without
How do I make postcards using Powerpoint03 May 2006 16:47 GMT1
I am trying to make postcards to send out to my clients and I need to find a
format to use on Powerpoint, can you help me figure out the steps I should
take to make postcards.
Problems with re-setting the last active cell in an Excel workshee03 May 2006 16:46 GMT2
I am trying to re-set the last active cell on an Excel 2002 worksheet (in
this particular sheet it should be cell DA197).  I have used both the methods
described in the Knowledge Base article (deleting rows and columns and
re-saving; and the Excess Format Cleaner add-in).
Erase All Empty Rows03 May 2006 16:28 GMT2
Hi All;
I prepared a data file but there are a lot of empty rows under the data.
Is there any way to erase all them?
Regards
Multiply hours:minutes by cost/hour to get total cost?03 May 2006 16:08 GMT4
How does one do a simple function to multiply a time (in hours:minutes i.e.
[hh]:mm) by a cost per hour (i.e. $60/hour).
If I have the time in one column, and the rate per hour in another column, I
need the total to be the total cost (i.e. 10:50 times $60 = sum??? should
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 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.