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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Using a macro to edit a macro02 Dec 2007 11:44 GMT1
Short summary:
I want to create a macro that will open up the excel vb/macro editor
and simply edit existing subs/macros with some fairly sophisticated
search and replaces.  Note: the macro actions I intend to create are
Vlookup Or ccount if comands02 Dec 2007 10:54 GMT1
I want to to display the data in column B if column A="Sack"
I assume the Vlookup will work or the count if.
Many thanks
How to reduce Excel worksheet view and find horizontal scroll bar02 Dec 2007 01:02 GMT5
I can't see the bottom of my Excel workbook including the tabs and the scroll
bar.  What can I do to fix it.
count number of column's with Yes IF column A is a 102 Dec 2007 00:43 GMT4
I hope you can help. I have very limited knowledge of excel so treat
me as an idiot please....
This is my table so far:
1  yes   no   yes  no
Need to re-arrange a field01 Dec 2007 22:50 GMT7
We entered about 1000 records including a date column (entered as text) but
in the wrong order..
it was entered as ..... dd/mm/yyyy .... e.g.   10/06/1886
I really want it to be ...  yyyy/mm/dd..  e.g.  1886/06/10
Defining a numeric system01 Dec 2007 20:29 GMT19
I am trying to get Excel to build a list for me using a special type of
alpha-numeric system. I would like to be able to fill in the first 3 cells
and then be able to drag it down from the bottom right corner to create a
list. Here is the format I am working with...
Remove 1000 separator space problem01 Dec 2007 19:40 GMT3
I am importing through a query numbers which the 1000 separator is a space.
To calculate with this value isn't possible in excel because the 1000
separator is this space.
I am try to remove the space in excel with find and replace " " to "" but
saving excel files01 Dec 2007 16:06 GMT2
How can you save multiple files (3 at a time or more) to a flashdrive . Thanks.
Scheduling Workbook01 Dec 2007 13:20 GMT1
Kind of an awkward situation really.  My boss has asked me to set up a
worksheet that allows him to "color in" the cells corresponding to the
shifts that workers request/will work.  I did so by giving him a
legend to copy from that has text in each item that matches its
Updating a workbook01 Dec 2007 13:15 GMT1
Hi I have been updating a copy of a workbook with a new sheet and a
couple of macros. I have done it in a copy of the original for trial
and error purposes.
Is there anyway of easily copying the new stuff to the original(s) now
find biggest numbers in row01 Dec 2007 10:45 GMT2
Is there a way in excel to scan across certain columns, per row and find the
highest value?
EG:
Col1, Col2, Col3, Col4
Changing color of cell01 Dec 2007 05:13 GMT1
Excel: In an if statement can i change cell fill or background color if correct
 
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.