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 / February 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to export to "data-1","data-2","data-3" format ?25 Feb 2005 21:51 GMT2
I need to create a delimited file where each field is delimited by a comma
and each field is contined in double quotes... like...
"data-1","data-2","data-3","data-4", etc
Can I do this from Excel?
Building a Hotlink from a formula25 Feb 2005 21:38 GMT4
Hello. I have tried a few unsuccessful runs at this, so was wondering
if anyone who has done this could help me out.
Workbook A contains one tab per person, with a detail record of assets
assigned to that person. I've named the Tabs (manually) according to
Saving worksheet as CSV after pulling data from an external data source25 Feb 2005 21:09 GMT4
All,
I am trying to load an Excel workbook. Have that workbook update from an
external datasource (oracle). Then save as a CSV.
I have tried putting code in the "on workbook open" but code is run before
Copy and paste from Vertical to Horizontal  25 Feb 2005 21:00 GMT3
Does anyone know how to copy a vertical column from excel and paste it into
a horizontal row? I have a sheet with column A 1-256 filled in and I want to
copy and paste it into a new sheet using row 1 A-ZZ etc.   Can this be done?
Can I safely enter information on two worksheets simultaneously w.25 Feb 2005 20:47 GMT1
I am setting up a database that lists informationa about different contract
employees. The first worksheet will be a summary and then there will be a
worksheet for each employee. The goal is to have a running count of the work
each has done. If I have a summary line on each ...
**Commission Calculation Problem**25 Feb 2005 20:20 GMT1
I need help on two things:
Firstly, I am calculating a new business commission of 1% over a 3 month
basis.
If the campaign doesnt run as it should in the fourth month a clawback will
Option buttons and check boxes moving25 Feb 2005 16:54 GMT3
I have encountered a problem with forms I construct in Excel. When I print
the form it will print one time okay but most of the option buttons, check
boxes, combo boxes, etc will jump to the left side of the window and I must
close the form without saving or the form will be ...
Excel Formula Reference?25 Feb 2005 16:10 GMT4
I'm looking for a decent MS Excel reference for formulae - preferably
one with examples.  I'm coming from a novice but fast-learner angle.
Has anyone suggestions - online or bound?  
Regards
Automatic refresh of external data25 Feb 2005 14:20 GMT4
I've looked and played with all the settings that I think would allow
automatic refresh of external data, but I still get a dialog box every time
I open the workbook that asks if I really want to enable or disable
automatic refresh.  Yes I really do!  Where is the switch or property ...
Become formula.25 Feb 2005 14:19 GMT5
A B C D E
1 1 1 1 1
2 3 4 5 6
3 6 10 15 21
=hyperlink()     for     mailto:25 Feb 2005 14:05 GMT2
is there a way to use the function =HYPERLINK() with URL longer than 220
characters?
I did tryied a lot but it returns #ERROR and the link does not work anymore
until I reduce string size.
Extracting hours from time25 Feb 2005 12:38 GMT2
           Sorry I seem to have a problem getting my thick head around
this.
I need to enter a starting time then a ending time i.e.. 4pm to 9.30pm, A
formula to calculate the amount of hours worked eludes me.
Excel to Access25 Feb 2005 12:34 GMT1
How can we transform Range of cells from excell to access table?
i.e.
name      number1         number2      number3 ....
John           50                   60               55
STDEV down, but not across, two cols??25 Feb 2005 11:32 GMT2
I don't understand Standard Deviation very well - I was just told to use
this function.  Up 'til now, I've only had one column of numbers.  Now I
have two columns of five data points each.  Each set across is one pair (two
measurements of the same item).
Deleting or Adding Zeros25 Feb 2005 11:27 GMT1
I have two lists in CSV format that I need to join tables in Access.
One list, which is too large to open in Excel has no zeros at the end
or a letter. The other list has zeros or a letter.
How can I add zeros to one list or delete zeros from the other list?
 
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.