|
Excel Macros
I'm saving my data as a Text file and use
this command. Unfortunately, it prompts for a use action to
save/replace the file and then prompts again when I close the file.
I'd like code that would not require use intervention.
ActiveWorkbook.SaveAs Filename:="I:\Configs\" & TextStr2,
FileFormat:= xlText, CreateBackup:=False
ActiveWorkbook.Close
Also, I'm trying to search and ...
|
1 |
12/31/2008 6:38:22 PM |
|
|
Question on index
How does this sum sheet1 A1 to the last thing in column A without putting a
number or foumula in D1? =SUM(Sheet1!A1:INDEX(Sheet1!A:A,$D$1))
I have use this in D1, =MATCH(9.99999999999999E+307,Sheet1!A:A)
, before to use this kind of formula but today I put the formula in without
anything in D1 and it looks like it works????
Is this the best way to do this??
Thanks, us...
|
2 |
12/31/2008 6:21:17 PM |
|
|
Like data into new spreadsheet
i would like move like data from one column into a new spreadsheet or arrange
within the spreadsheet like data from one column, i.e. take all the same
numbers in one column and show together or in a new speadsheet. thank you
for the help....
|
2 |
12/31/2008 6:10:05 PM |
|
|
How can I add (;) at the end of each name simultaneously
I want to create a contact list using email addresses of all my friends. I
have about 20 email address going down colum A in Excel. How can I add the
symbol ";" to the end of each email address simultaneously so I dont have to
do it one at a time. I want to be able to copy the list and paste it in my
email so I can send them all a message a one time such as "Happy New Year!"...
|
2 |
12/31/2008 5:50:00 PM |
|
|
drop down list populates data in another cell
I'm am creating a spreadsheet that has a drop down list to select a specific
product and I want the selection from the list to automatically generate data
for that product in another cell.
For example:
Cell A2 Drop down list will offer:
Mirror 1
Mirror 2
Mirror 3
If Mirror 1 is selected I want a certain dollar amount to appear in cell D2.
If Mirror 2 is selected a different dollar a...
|
3 |
12/31/2008 5:48:01 PM |
|
|
Clear "Help Task Pane"
I downloaded a 2009 Excel Calendar template from Microsoft's web site and
everytime I open it the Template Help Taks Pane opens on the right hand side
of the screen. From the Tool Bar under View I unchecked the Task Pane and it
closes but comes back each time I open the spreadsheet. How do I get rid of
it ?
Thanks ...
|
4 |
12/31/2008 5:42:14 PM |
|
|
Losing date format when saving .csv files
I am exporting accounting data out of legacy database into .csv file format.
The text data is not delimited, so I use Text to Columns and set the date
fields to Text (from General). The date formats retain formatting (in my
case, mm/dd/yyyy). I save the file as a .csv. When I reopen the file, I
lose the date formatting. The date fields revert to m/d/yyyy.
I have to use .csv file in...
|
3 |
12/31/2008 5:31:00 PM |
|
|
Deleting 63,886 Blank Rows Under My Data
I am working on an excel file in which I currently have data in 1,650 rows
and there are blank cells within the rows I am working on that need to stay
blank. My main problem is deleteing the extra 65,536 blank rows below my data
that randomly appeared when I copy and pasted my data to a new workbook. When
I highlight a single blank row or many blank rows beneath my data and hit
delete ro...
|
14 |
12/31/2008 5:21:24 PM |
|
|
Ctl Page Up and Ctl Page Down work selectively
I just received a workbook, and on the first sheet I can press Ctl page down
and navigate to the next worksheet. However, on all the other sheets, this
same action (or Ctl page up) does not change sheets, but shifts me left or
right, like I had clicked on the horizontal scroll bar.
I have examined all the settings in Tools, Options (using excel 2003), but
do not see anything different ...
|
5 |
12/31/2008 5:07:55 PM |
|
|
Lookup Error
In my ss I am using Lookup. It is doing just want I want it to do except in
some cells I am getting a #N/A erro. Is there away to show this error as a
zero. Thanks...
|
2 |
12/31/2008 4:58:05 PM |
|
|
Substitute to Retun a number
I am using the substitute function to split a cell containing <5 into two
cells: < and 5 using the following
=substitute (A1,"<","")
I need the 5 to be a number and this is causing it to be formatted as text.
Any suggestions? Thanks in advance!...
|
3 |
12/31/2008 4:55:01 PM |
|
|
Pull Down Menus
How can I create a series of pull down menus where the 2nd, 3rd and 4th tier
are based on the preceding choices?
I know how the validate command can work, but and not sure how to create a
dynamic way to populate to ensuing tiers based on the previous selection.
In short....you pulldown item 1, which determines what can be pulldowned
from item 2 and so on for 4 levels.
Now the real c...
|
3 |
12/31/2008 4:49:01 PM |
|
|
Lookup values and display them
I have 2 different sets of values in 2 columns that are constantly changing.
I want excel to be able to find a missing value between the 2 columns data
and list the missing values in order. Which function(s) should I use.
If you want me to email the worksheet to you, just email me at
biblequiz@myway.com
Thanks in advance...
|
1 |
12/31/2008 4:48:05 PM |
|
|
Excel to Microstation
Any suggestion how to use VBA from Excel to generate drawings in Microstation
and Autocad ?...
|
4 |
12/31/2008 4:42:14 PM |
|
|
Employee days worked (-Holidays, -weekends, Snow Days, etc)
I am trying to save time counting the days newly-hired teachers will work in
a 180-day work year. I have a spread sheet(school calendar) with all the
possible dates in column C and a variable set for #snow days (we have only 1
so far) already setup. I want to be able to place a formula off to the side
of the calendar and code it to reference the date cells after I type in an
employee sta...
|
3 |
12/31/2008 4:37:01 PM |
|
|
Color palettes switching between Excel files
I have recently found that if I open two workbooks with different color
palettes, in the same instance of Excel, the color palettes will switch from
one file to other, and mess up all the colors. I try to switch it back using
the Tools -> Options -> Color menu, but any file that I try to use as a base
gets the color palette corrupted also.
Is there any way to stop this? We use se...
|
4 |
12/31/2008 4:22:14 PM |
|
|
HELP! Growth % reflected in a visual diagram
I have the data but do not know how to show it in a visual scatter gram or
smokestacks or anything? What I would like to show is how in the last 3
years we SOWs have increased (a lot) and the revenue has doubled in the last
2 years -- I really want to make sure that they can see the 92% & 95% growth
& see the add'l work efforts that need to be applied -- PLEASE HELP me to
show that in a...
|
9 |
12/31/2008 4:21:04 PM |
|
|
how to update data without opening linked files?
...
|
1 |
12/31/2008 4:20:00 PM |
|
|
Create Toolbar Button
I want to create a couple of buttons to place on my toolbar. Some to open
commonly used files and one to load a template. Any links/pointers
appreciated.
Thanks...
|
4 |
12/31/2008 4:17:05 PM |
|
|
rounding up to nearest specified whole number
Is there any formula in Microsoft Excel 2003 that will round a cell UP to a
nearest specified whole number?
I'm trying to get a cell to round up to the nearest 5. MROUND will round to
the NEAREST 5 so if the starting number is a 7, it rounds DOWN with the
result being 5. I want to always round UP so the result would be 10.
Threre is a round up formula but it seems to only apply to decimals...
|
2 |
12/31/2008 4:31:37 PM |
|
|
Lock hidden cells
Is it possible to hide cells and stop them from being unhidden without a
password ???
Regards
Mark...
|
3 |
12/31/2008 4:36:26 PM |
|
|
Adding rows
I have a file that I thought was in a great format for my application but it
turns out its not. Here is an example of what I have:
1 12.1
1 12.6
1 12.9
2 8.4
2 8.7
3 30.1
3 30.9
3 31.0
Column A is sample number and when it changes to a new sample number I need
something that inserts 4 rows with the
1st row = UWI:
2nd row = Common:
3rd row = Curve:
4th row = Measr. ...
|
5 |
12/31/2008 5:03:01 PM |
|
|
checkbox for formula
Hi Folks,
I have a worksheet with basic formulas for addition and subtraction. For
example; when I put the number on G7 it subtracts from H6 and shows the
result on H7. I am using this formula on H7
=IF(AND(ISBLANK(F7),ISBLANK(G7)),"",H6-F7+G7)
Now I would like to place a checkbox or radio button on E7 to control
calculation on H7. If it is checked the calculation will be happened if...
|
5 |
12/31/2008 5:51:06 PM |
|
|
Excel 2002: Why occationally crashes upon pasting data ?
Hi,
Wishing you a Happy New Year 2009.
My Excel 2002 is running on Window 2000 Terminal Service Client Servers.
Frequently I need to copy data in Excel format generated by another business
system and paste it to a working file. Occationally the destination worksheet
terminate itself upon pasting the datas and send error messages to MS.
It then recovers back the lost file. Many time...
|
3 |
12/31/2008 6:01:12 PM |
|
|
RIBBON TAB NOT BEING REMOVED
I had installed an add-in "Ray's Tools" which created an additional tab on
the Excel 2007's ribbon. However, upon removing the check from such an addin,
in the AddIn's installed, the tab and buttons thereupon are still appearing,
which upon being clicked display a message such a file doesn't exist.
How to disable this AddIn and remove such a tab and buttons thereupon
permanently?
-- ...
|
5 |
12/31/2008 6:03:02 PM |