|
Moving in a column by first letter of data in cells
Hi to all ,
I have a large worksheet (only a few thousand rows...) which makes it really
cumbersome to move/scroll. I want to move around in one column by the first
letter of word to enter data in the other columns (The same way we scroll in
contacts of mobile phone by their first letter). I have sorted it
alphabetically but still it's slow to move/scroll due to some codes and
pivotta...
|
9 |
12/5/2008 2:32:13 PM |
|
|
How can I create a monthly planner
I have seen some preformatted Excel calendars and planners but I have
seen nothing like the one I would really like to have.
Can you help me find one or explain how I can create one. I use Excel
2003.
Here are the details of what I am trying to create ....
--------------------------------
(1) I would like each day to be on a separate line. On the left it says
"Tuesday, January 1st...
|
6 |
12/5/2008 11:46:52 AM |
|
|
How I create lots of copies of the same document in once?
I have an excel file and I must create many times the same document to
be filled by the clients.
I must create at least 600 copies of the same document?
Is there any way to do it in once, instead to copy the document one by
one?
Regards
Alberto...
|
2 |
12/5/2008 10:26:01 AM |
|
|
XLL Add-in
I need to understand how to make my C++ functions available in
Excel-2003. I'm using Visual C++ 2008. I'd like to use the most direct
interface, hence I ~believe~ XLL is the way to go, not DLL. Correct?
I tried to Google the topic and I could not spot a very basic
explanation or guidelines. All links assume previous competence on the
topic. I would appreciate is someone can give me directio...
|
4 |
12/5/2008 4:22:53 AM |
|
|
Excel 2003 - vba - Test to see if worksheet present
HI All:
I have this working in one workbook, but when I transplant it into another,
it fails to function as expected.
Issue: I would like to check my current workbook to ensure that a sheet does
not exist, before trying to create it.
In a UserForm, I allow the user to input a sheet name that they would like
to import. Upon their depressing the "AddListBut" on the userform (ListForm)
i...
|
4 |
12/5/2008 2:15:28 AM |
|
|
Help with converting data in Excel
Hello all,
I have been working with a client of mine for the last few weeks to
get a simple data conversion taken care of. However it has turned out
to be more difficult than I expected. I was provided a *.txt file
that had tons of columns and extra data that wasn't needed. The
client just wanted the names & addresses from the files so they could
use those for mailing labels.
I was a...
|
7 |
12/4/2008 11:43:05 PM |
|
|
Get values from validation list; else type in values?
On Sheet1 I have a three-column table: ItemName, Value1, Value 2. I
created a dynamic named range for ItemName so I can use these names in
a drop-down list in Sheet2 via Data Validation. That way, I can add
new items to the list and they will show up in the drop-down list.
On Sheet2 I have a "calculator" that will need the values from the
table on Sheet1. So when I use the drop-down in C...
|
7 |
12/4/2008 11:42:13 PM |
|
|
2003 macro working in 2007 - inserting a jpeg
I have written the following code which inserts a jpeg file in a cell
(B171)
If Range("R4") = "DW" Then
Range("B171").Value = "Dave Woodgate"
Range("B171").Select
ActiveCell.Select
ActiveSheet.Pictures.Insert("S:\Tsunami Axis\Purchase Orders\Sigs
\Dave Woodgate.JPG").Select
Selection.ShapeRange.PictureFormat.TransparentBackground = msoTrue
Selection.ShapeRa...
|
4 |
12/4/2008 11:10:09 PM |
|
|
How to use goal seek on column
Hi!
I have a formula in cell C which is dependant on values in cell A and
B. I use goal seek to adjust the value in cell A to meet the goal for
C. This works perfectly. However I would like this to be performed on
all rows in column C. Is this possible?
Example:
Column A Column B Column
C
1
1 =A/B
5
3...
|
5 |
12/4/2008 9:16:09 PM |
|
|
Macro help, generating list
I want to cerate a macro in Excel 2007 that does the following:
Starts at the top of a list of numbers and goes down through each,
checking the cell to the right of it to see if it is blank. If the
cell to the right is blank, takes that number (in the left column) and
puts it at the bottom of a list of previously checked numbers whoes
cell to the right is also blank.
Below is an example ...
|
10 |
12/4/2008 5:55:31 PM |
|
|
Averaging non consecutive cells excluding zero's
how can I average non consecutive cells in a row excluding zero's
eg.
A1=2
D1=6
F1=0
J1=4
all cells in the range (A1:K1)have values in them but only the sum of cetain
cell need to be averaged
any help is a appreciated.
...
|
5 |
12/4/2008 5:04:01 PM |
|
|
Moving data around automatically
Does anyone know of a fairly easy way to move a row of data to another
worksheet when a certain criteria is fulfilled. I.e. when i click on a
certain cell/change a cell colour/insert a symbol it moves that whole row
into another spreadsheet.
I am fairly new to prgramming but if anyone knows the function that will do
it then I will go and do some research.
thanks in advance!!...
|
1 |
12/4/2008 2:48:03 PM |
|
|
Xfr Spreadsheet Problems
Greetings ...
I have big need to transfer a working spreadsheet to various blank pages in
an Excel 2007 workbook. I've tried everything I can think of ... can't get
column widths, formulas, formats or blocked-cell template to transfer.
Source
file was created with Excel 2003. Can someone please tell me how to do
this?
Radio426
...
|
2 |
12/4/2008 10:59:45 AM |
|
|
Formula to prevent circular references
Hi All,
I need help with the following information. I have some calcs to run
however I keep getting circular references. The information is below.
I get a circular reference at "c" and another one at "f". Does someone
have a formula / array function that can work this out accurately
without the circular reference?
Thanks
Package 100,000.00 a
Sal Sac...
|
2 |
12/4/2008 10:36:46 AM |
|
|
EXPORT any record (row) to a formated txt file
Hi
I want export every row to a seperated text file.
with MS-Word mail merge wizard I can read the xls file and create a formated
(with some content) file.
but I can't export it to seperated file.
1- In excel is any formula for export any row to the txt file (that have
some content).
2- How can this senario, with mail merge wizard in MS-Word.
---
My Excel file have this content:
MY...
|
3 |
12/4/2008 6:07:40 AM |
|
|
Select a range based on system date
Part 1
I have a spreadsheet that I want to open protected (locked). However,
I want to unlock a specific range for data entry based on the day of
the actual system date.
For example if today is 11/5/08 then we want to unlock row 5,
specifically cells B5:I5.
I have experimented with several functions, which return the desired
results, but I am not skilled enough to place them into a we...
|
4 |
12/4/2008 2:54:49 AM |
|
|
sumproduct with two criteria on one column??
I have Window Vista, Office, Excel
Col A contains Mon or Tue or Wed or etc days of the weel, Col B
contains the date Jan 1, Jan 2, etc, Col C contains a dollar amount
for each day. I want to count how many Tue, Wed, Thu, etc there are
that have dollar amounts not 0 or blank cells. Each cell in Col C has
a formula that calculates the dollar amount from another page of the
work book.
I ...
|
4 |
12/4/2008 2:41:24 AM |
|
|
Excel 2007 Custom Formatting using [ColorXX]
I like to use custom cell formatting for simple cell coloring of positive
and negative numbers (leaving conditional formatting for more intensive
tasks). In Excel 2003 you could use [ColorXX], where XX is a number
corresponding to a color in the color palette of the active workbook.
Determining what number resulted in a specific color was straight forward as
it matched the layout of the...
|
5 |
12/4/2008 2:36:36 AM |
|
|
Unable to Tranfer Spreadsheet
Greetings ...
I have big need to transfer a working spreadsheet to various blank pages in
an Excel 2007 workbook. I've tried everything I can think of ... can't get
column widths, formulas formats or cell block template to transfer. Source
file was created with Excel 2003. Can someone please tell me how to do
this?
Lin
...
|
3 |
12/4/2008 1:52:42 AM |
|
|
Refer to NamedRange, Col1 in formula to find value?
I have the following formula:
=((LOOKUP($I5,$A$2:$A$7,$D$2:$D$7)-J5)
I'd like to replace $A$2:$A$7 with "NamedRange, Col1" and $D$2:$D$7
with "NamedRange, Col4". How do I create that reference?
Ed...
|
4 |
12/3/2008 8:51:54 PM |
|
|
Column Headers (MS SQL Server, OLAP)
With MS SQL Server 2005, MS Excel 2007.
Suppose the database in SQL Server contains Customers and Addresses. Each
Customer has two Addresses: Shipping and Billing. The Address contains a
City and a Country.
Now we design the cube. There are two dimensions: Shipping and Billing.
When opening the cube in MS Excel the list of field looks as follows
Billing
Billing.City
B...
|
1 |
12/3/2008 8:20:03 PM |
|
|
open xlsx files in office 2000
I installed filesconverter.exe from microsoft site but still can't open xlsx
files although docx files are opening. I have office 2000 with SP3 on Vista.
Any suggestions?--
Any Help will be appreciated. Thanks
Don...
|
4 |
12/3/2008 5:55:01 PM |
|
|
Cell Protection and External Data
I have a worksheet that has user input to calculate data that will be
put into a database for testing. The worksheet also has a Get External
Data to get that data once the test has run.
I'm trying to preserve the formulas and outputs by protecting the
cells, but when I protect the worksheet, I can't get external data.
Is there a way to protect some cells on a worksheet, but still get
ext...
|
3 |
12/3/2008 5:01:37 PM |
|
|
Excel interprets date input as non-US
When I enter November 1, 2008 as 11/1/08, it is interpreted as January 11,
2008. This started happening recently, probably after I unwisely downloaded
the latest MS updates (I'll never do that again). What's the deal? My
preferences are all for US, so what's the problem? ...
|
9 |
12/3/2008 3:51:36 PM |
|
|
Data Validation List from different sheet
In Excel 2003, can I use a data-validation drop-down list that reads
its data from a different sheet?
thanks
M...
|
21 |
12/3/2008 3:07:15 PM |