I want to make the value of the number I enter be * 2
example: if I put in 1 i want it to equal 2 in my sum in another column
- Sep 10 Mon 2007 20:39
how do i make a value entered be * 2
- Sep 10 Mon 2007 20:39
Using relative reference in macro
I want to copy and paste a range from 1 column to 1 row (transpose). This is
no problem. Then i want to shift some of the cells to their final location,
- Sep 10 Mon 2007 20:39
cells.find amp; stopping the search
I am using a macro based on the cells.find feature, and I want to make
it stop searching at a certain row. Otherwise, it always finds the
- Sep 10 Mon 2007 20:39
Calculated Items in Pivot Table
It seems that Excel calculates all possible permutations or a calcuation.
For example:
- Sep 10 Mon 2007 20:39
carriage return that works when pasted into a text file (eg. Notep
Is this possible?
- Sep 10 Mon 2007 20:39
Auto populate several cells based on a selection from drop down li
I'm working on creating a form in Excel that needs to contain different
information in the body of the form based on the selection from a drop down
- Sep 10 Mon 2007 20:39
multiple worksheets
We use a spreadsheet for the years cashbooks, with seaparate worksheets for
each month. Is there a way to insert a new column and its formulas once and
- Sep 10 Mon 2007 20:39
Compare 4 columns?
Hi guys,
- Sep 10 Mon 2007 20:39
Selecting part of a series for a chart?
My data comprises series of data (hours) by months for various projects (prj
1, 2 ,3 etc) My chart plots these series, and the X axis covers say, June 05
- Sep 10 Mon 2007 20:39
when opening a .xls file it seems to want to open in word, what d
When I attempt to open an Excel file (not through Excel) by double cliccking
on file, the default appears to be word, so cannot read file correctly.

