Transpose large data from columns to rows
Tue, 9 Mar 2010 23:30:28 -0800 (PST)
Hello thanks for the help if possible.
I have 2 columns. Column A contains names of employees column B
contains the trainings the employees attended.
Each employee has different number of trainings (I got this data
sorted by simple pivot table)
A B
Employee X ...
|
XL Sheet Display
Wed, 10 Mar 2010 16:45:29 +1000
Hi,
I am using Excel 2003.
For some sheets I do not want the Row & Column Headers showing, so in
Tools > Options > View then in the "Window options" I uncheck the box "Row
& Column headers". By doing this I can set each sheet individually. Some
have the headers showing others not.
What I want t ...
|
Re: Excel 2007 Macro/VB Question DDE Question
Tue, 9 Mar 2010 15:25:41 -0800 (PST)
Bump
On Mar 4, 6:16 pm, MadDog wrote:
> I have figured out how to make a macro copy and paste the value to the cell in the next column and then go to the next row in the column. However, I cannot figure out how to create a macro that would enter a cell, hit F2, ?press enter? then proceed to the cell below it. ...
|
Expand list in Excel.
Tue, 9 Mar 2010 12:28:01 -0800
Hi.
I had made a list menu (Validation data, drop down list etc.) in an Excel
sheet. I would like now to expand (to add new cells with extra data) to the
list. I tried to do this but I couldnâ??t .
Is it possible ? How?
(I donâ??t want to write the total workbook again from the beginning)
Thank you.
...
|
Average Formula
Tue, 9 Mar 2010 12:26:19 -0500
I'm trying to find the average of bulletins used each Sunday. I'm keeping
track of how many I produce each Sunday and how many are left.
Basic table...
Week Bulletin Amt. Bulletins left
Week 1 100 34
Week 2 100 17
Week 3 110 ...
|
default font color
Tue, 09 Mar 2010 09:09:21 -0800
It's unbelievable that you have to jump through these hoops to do a simple thing like change the default font color.
Gord Dibben wrote:
Re: Setting default font color
26-Jan-09
See in-line responses.
On Mon, 26 Jan 2009 08:47:58 -0600, "Dave" <djbahb@dcwis.com> wrote:
We all get those days.
Actua ...
|
Automatically closing slave workbook when main workbook is closed...
Tue, 9 Mar 2010 03:48:54 -0800 (PST)
Hi
Have two workbooks - lets call them workbook1 and workbook2 for ease.
Workbook 1 is the main document, however, some of data is drawn from
Workbook 2 which is currently mininmized by following code in VBA
Workbook1:
Private Sub Workbook_Open()
Workbooks.Open "Workbook2.xls"
ActiveWindow.WindowState = ...
|
|
|
Automatically closing slave workbook when main workbook is closed...
Tue, 9 Mar 2010 03:46:54 -0800 (PST)
Hi
Have two workbooks - lets call them workbook1 and workbook2 for ease.
Workbook 1 is the main document, however, some of data is drawn from
Workbook 2 which is currently mininmized by following code in VBA
Workbook1:
Private Sub Workbook_Open()
Workbooks.Open "Workbook2.xls"
ActiveWindow.WindowState = ...
|
VBA Syntax problem
Tue, 9 Mar 2010 09:47:23 -0000
I am trying to set up a macro which would only run if there is a value in
any of the three cells to the left of active cell. The following does not
seem to work and would appreciate any help in correcting this:
If ActiveCell.FormulaR1C1 = "(SUM(RC[-3]:RC[-1])<>0" Then
run macro code
End If
JP
...
|
Excel 2010 (beta)
Tue, 09 Mar 2010 08:27:31 +0000
I am running Excel 2010 beta and have managed to install the Data Mining
pack. However it needs to be connected to the localhost to work.
Not being into networking, I find this aspect of things quite daunting.
Clicking on the data mining tap shows that I have no connection on the
'connection' icon.
Cli ...
|