|
|
Formula Help by
Denise
I need to take the formulas in one spread sheet such as : =991643*35.45 and
have just the multiplier (35.45) be entered into another spread sheet for a...
|
|
1 |
57 |
|
|
|
|
2 |
134 |
|
|
linking between spreadsheets by
Ed
Hi,
I am trying to to link data from 4 various spreadsheets, I'll call them sub
spreadsheets, to one master spreadsheet. The four various spreadsheets are...
|
April 27th, 2009 11:10 PM
by Ed
|
5 |
104 |
|
|
|
|
6 |
88 |
|
|
flashing cells by
MAX
I tried the code below for flashing cells, and it didn't work.
Will you please help me.
CODE:
In Workbook
Private Sub Workbook_BeforeClose(Cancel As Boolean)...
|
April 27th, 2009 10:12 PM
by MAX
|
0 |
65 |
|
|
Please HELP! by
MonkOnAMission
Hi,
Coloum A has dates and Coloum B has productivity numbers (no of tasks
completed). Coloumn C contains the names of the tasks. The catch is:
duplicate...
|
April 27th, 2009 08:58 PM
by Pete_UK
|
1 |
64 |
|
|
Excel 07 worksheet problem - HELP!! by
RobSan72
Help!! I used to be quite a whiz on Excel 03. Now I'm using 07 and for some
reason when I right click a worksheet, insert, rename, delete, move, copy...
|
|
1 |
89 |
|
|
Vlookup, Column Index Num and Autofill by
mp
If I have a vlookup in one cell and I try to autofill across multiple
columns, how do get the column index num reference to increase by one as I
autofill...
|
|
9 |
171 |
|
|
data alteration by
ben87y
how do I stop excel from altering inputted data?
eg "03/2009" is reformatted to 01/03/2009, or Mar-09, seemingly at random
I've tried right click format...
|
|
1 |
67 |
|
|
|
|
1 |
70 |
|
|
|
|
1 |
74 |
|
|
Column Number of a cell with text by
Hilvert Scheper
Hi All,
I'd be Greatful if someone could answer me this question:
Is there a Formula that gives me the Column Number of the Cell that contains
the Text...
|
|
4 |
69 |
|
|
Hyperlink to cell in separate workbook by
rbeach
I need to hyperlink to worksheet "Mod2" cell "E4" in a seperate workbook
named "CMS KVA KW READINGS SHEET.XLXS". The below link works to open the
workbook...
|
April 27th, 2009 05:18 PM
by rbeach
|
3 |
72 |
|
|
Flashing cells by
MAX
I need a code to flashing 4 cells in a workbook of 3 sheets.
1. Sheet 1 (Cell A1)
2. Sheet 2 (Cell B1) and
3. Sheet 3 (Cells C1 and C2).
If possible when I...
|
April 27th, 2009 04:55 PM
by MAX
|
3 |
116 |
|
|
Creating new worksheets by
Funkyfido
I have a spreadsheet with a huge amount of data on one worksheet. I am
looking to put all data on a new worksheet whenever the data changes. Any
idea how I...
|
|
1 |
68 |
|
|
Pick up some text in a cell by
Elton Law[_2_]
Dear Expert,
Want to extract 3 letters after /, in this case, the answer should be JPY.
EUR/JPY SHORT EUR 20 MIO
AUD/JPY SHORT AUD 1 MIO
USD/JPY SHORT USD 1...
|
|
9 |
69 |
|
|
Missing info on worksheet by
BCalaway
I have a worksheet that we type in specific info. The info is barcoded in
this worksheet. We then print out each sheet.
The worksheet has been corrupted and...
|
|
0 |
52 |
|
|
Multiple Instances in a Column by
GRANDIVA77
How do I get a column to only show one instance of a number when it appears
multiple times? For example I am working with a large worksheet. The main
column...
|
|
1 |
57 |
|
|
Open XL - A Powerful Excel Addin by
Ashish Jain[_2_]
If you want to do any or all of the following. Visit http://www.excelitems.com
and Download Open XL.
1. Run Charts Slideshow
2. Calculate Business Working...
|
|
0 |
93 |
|
|
Open XL - A Powerful Excel Addin by
Ashish Jain[_2_]
If you want to do any or all of the following. Visit http://www.excelitems.com
and Download Open XL.
1. Run Charts Slideshow
2. Calculate Business Working...
|
|
0 |
106 |