Formula to get data from files #3
Thanks for the reply.
Using your formula, I get the filename and the cell number in C, bu
how do I get the results of that cell number.
I need to type the name of the file in A and a certain cell of tha
file in B and have the formula go to that file and get the value o
greasybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=792
View this thread: http://www.excelforum.com/showthread.php?threadid=26321
...stopping columns for one page
I am creating a several page document in two column format. There is one =
page in the middle the I want to be a full width, but I can't figure out =
do this without making the previous pages also full page.
How do I "turn off" the columns for a page or partial page within a=20
In article <email@example.com>,
"firstname.lastname@example.org" <email@example.com> wrote:
> I am creating a several page document in two column format. There is one
> page in the middle the I want to be a ful...how do you total columns that are not adjacent
how do you total columns that are not adjacent but in the same row?
I saw this previous post but cannot figure it out:
"I want to add up, the first is at G4, the next is N4, then U4 etc etc...
until the last cell is BCZ4. So, every interval space of 6 cells. The values
are all in the same row.
reply: Try this
I would like to: begin with the amount in D7
subtract amount in E7
add amount in H7
provide answer in I7
is this possible? if so, how...I keep getting the error message 'not responding' with Outlook?
I keep getting the error message 'not responding' with Outlook? So
ultimately it takes a long time to load then the message disappears. Does
any one know what this means? Have I got a bug somewhere that I need to get
Shazza wrote on Fri, 12 March 2010 07:33
> I keep getting the error message 'not responding' with Outlook? So
> ultimately it takes a long time to load then the message disappears. Does
> any one know what this means? Have I got a bug somewhere that I need to get
> rid of?
1- try to check your ad-dons may be one of th...Get paid while you get online!!
I found a great Internet company - Cashfiesta.com - that has created a
product everyone can benefit from. They pay you while you work or play
on your computer. All you need to do is keep their software - the
FiestaBar=99 - active while you are online. They even pay you when your
friends are using their computers.
Unlike other companies, Cashfiesta gives you control over how much
money you earn. They have an individual payrate based on the number of
Special Offers you sign up for. As some of these offers are free, you
can increase your payrate up to 33 times without spending a penny.
It's...How do you set up a repeating column in Outlook?
I have three sheets in one workbook, and I want to make changes to one column
in sheet one, but I want the changes to apply to the other sheets when I make
that one edit.
You can group the sheets.
Select the first sheet
ctrl-click on the subsequent tabs
Make your changes.
rightclick on one of those grouped worksheet tabs and select "Ungroup Sheets"
(Everything you do to one, you'll be doing to all in the group--so be careful!)
> I have three sheets in one workbook, and I want to make changes to one column
> in sheet one, but I want the change...Hidden ActiveX gets focus
i have a MFC CDialog that contains several controls and ActiveX'es.
Depending on the configuration of the dialog, I have to hide an ActiveX (I
tried different ways like ::ShowWindow(...) or ::SetWindowPos(...) etc. to do
that). The ActiveX gets hidden as it should.
Let's say, I have the following tab order:
Edit1 (ActiveX) - Edit2 (ActiveX, hidden) - Button - Edit3 (ActiveX, hidden)
I jump from control to control by pressing the tab-key. What I expect is
that the focus jumps from Edit1 to Button and back to Edit1 and so on. But....
What really happens is that:
- Edit1 is foc...How to add a second axis to a chart?
I am trying to do a chart with items in Millions and in Units so I need a
second axis. Please help.
You can't select Secondary Axis until a second series is on the chart. Once
you've done that, select Format Data Series and Axis to select the Secondary
> I am trying to do a chart with items in Millions and in Units so I need a
> second axis. Please help.
...Worksheet diplays formulas and not the calculated values.
My workshhet displays the formula that I entered (Vlookup) and is not
displaying the values of the function.
Formatted cells to numbers, copied formula from a worksheet that dispalys
values etc etc but nothing is working.
How could I resolve this?
Sounds like an Excel question and this news group is for Access.
Try putting an equal sign in front of the formula.
Build a little - Test a little
> My workshhet displays the formula that I entered (Vlookup) and is not
> displaying the values of the function.
> Formatted cells to numbers...Sumproduct where cell values are the same in a sorted column
In cell C2 I have the following formula that works fine for what I need it
In the cells in column J i have a list of numbers that are the same in the
following different ranges as follows
J2:J23 = 123456
J24:J30 = 123457
J31 = 123458
J32:J33 = 123459
I copy the formula in cell C2 down the column and then I have to manually
change the range in the formula to match the ranges of other columns. So the
following cells will have the following formulas in. The rest of the cells in
the range are ...Can't get Vista recovery CD to recognize installation
I'm trying to get a Powerspec B647 Vista64 Business PC to boot. After
booting to the Vista Recovery CD and choosing to repair, the process
can't find any installed O/S.
So I press the Load Drivers button to load the B647 RAID controller
drivers, which I downloaded from Powerspec to my flash drive. After
pointing it to the "sataraid" folder, the system installs some
controllers and drivers but still doesn't find my Vista installation
afterwards. Even worse, the C drive letter is given to one of the
removable media drives.
After pressing the Next button I'...How to get the active document
Hi. How can I get the active document object (to clarify, the document
object associated with the view that has focus) in an MDI application? I'm
using a worker thread for communication and I need to tell the active
document about communication event that occur.
You can get the active document in MDI using GetActiveFrame(), checking its
validity and then calling GetActiveDocument on it. The only catch here is
that you are doing it in a worker thread. I think it should work there as
well because you are not using the (CWnd,handle) map of MFC that is not
valid in your thre...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...How do I get my text wrap tools to work?
I've followed every instruction in the help files that I can find, and my
text wrapping features will not work in any format other than top and bottom.
My computer is new & has Publisher 2003. I've worked on Pub. 2000 & did not
have this problem. Is there a setting that I'm missing???
Right-click the text box, format text box, layout tab, select the text wrapping you
Did you edit the wrap points on your object?
Select your object, click the dog icon on the picture toolbar, select a wrap there.
It could be how your are arranging the objects and text box. Experime...How to get font information from clipboard #2
I am writing an image process program. I want to cut or copy some text
with font information from other software, such as MS Word, Excel etc .
In my program, the text will be draw on screen with same font. So I
need to get the font information from clipboard, what should I do?
...how do i flip a column round in excel?
I've a long column of numbers in excel which i need to flip round or invert
but dont know how. I cant use the sort function as it only sorts it in
ascending or descending order but i want to reverse the order of the numbers
so that bottom becomes top and top becomes bottom for example. Thanks
One way is to use a helper column next to your data and enter 1 at the top
and fill down holding the CTRL key down until you reach the bottom of your
data. Then sort both columns using the 1 thru N column as the sort column.
"shockwave_dave" <shockwave_dave@di...can't get ical into entourage
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
no matter what i do i can't get my calendar into entourage. i've got sync services set to delete entourage and replace with ical/contacts on my imac. my contacts are there, but i've never been able to get my calendar over. i gave up last june but wanted to see if there was any help so i could try to use entourage and then compare to ical/contacts/mail. <br><br>help!!!
On 2/8/10 3:25 PM, in article 59bb27cf.-1@webcrossing.JaKIaxP2ac0,
"Carol_Schultz@officeform...Cond format based on if field value is valid
I have a combo box whos control source is a filed on a form,its Row Source
type is a query and its row source is a record from the query. Basically the
field on the form is a category ID number. The query compares that category
number to the list of category numbers and the end result is that the
category descritpion text is displayed on the form. I need that descritpion
combo box to change colors if the category code is not on the list of
available category codes.
How can I accomplish this?
Thanks for your advice....
...Pivot Table default Value Field Settings
I use pivot tables a lot and the vast majoirty of the time I use it to sum
data. Excel defaults the Value Field Setting to Count so I have to change it
every time. Is there any way I can change the default to Sum?
If all the data in the field is numeric, then you'll see Sum.
If any of the data in the field is text (or empty!), then you'll see Count.
I don't think you can change this behavior.
But you can use Debra Dalgleish's pivottable addin to lots of stuff:
Max Scott wrote:
> I use pivot ta...How to get totals
Hello all. I have a list I am working with in excel 2003. The columns I am
interested in are Employee, Overtime Code, Pay and Comp. There are
overtime codes. I need to total the pay and comp columns for each employee.
My problem is that if the OT codes are certain numbers, they will not be used
in the calcualtions. Like so:
EMPLOYEE OT CODE PAY COMP
Jones 1 4 0
Jones 6 4 0
Jones 5.02 0 4
Jones 18 2 0
Jones 9 ...2 users getting same email
Hi-I recently added another user to my outlook 2002 pro
account. The email is working for both-I tested sending &
receiving to each one-but both accounts are getting the
same emails. If I delete a message in 1 account, it is
deleted in the other account because it is the same
message. What can I do? Thanks!
ali <firstname.lastname@example.org> wrote:
> Hi-I recently added another user to my outlook 2002 pro
> account. The email is working for both-I tested sending &
> receiving to each one-but both accounts are getting the
> same emails. If I delete a...how do I get this done
If anyone can help me with this I'd greatly appreciate it
If I have some data such as
Plan A 2.00 4.00
Plan B 3.00 5.00
Plab C 4.00 6.00
and also have
cost X what formula for X will look at the data abov
and return the value 2.00
pgruening's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2601
View this thread: http://www.excelforum.com/showthread.php?threadid=39368
A1...How to get combo box selected index changed event in another page from the existing page in winforms
I am working on windows forms project. I have two winforms (window1 and
I have a combobox called cmbEmail in window1 and Textbox called txtName in
I want to retrieve some information into the txtName in window2 when I
selected something from cmbEmail in window1.
If I write code to retrieve something into the txtName (which is in window2)
in cmbEmail SelectedIndexchanged event in window1, I will get an error of
txtName doesn't exist in this page.
Can anybody help me to solve this problem..
Thanks and Regards
"Naresh" &...Tab Value
Is there a way to make a tab assume the same value as a cell on that sheet?
ie. value of cell G1 is Feeler have tab value be Feeler and have the tab
value update automaticaly when the Cell value is changed.
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$G$1" Then
Me.Name = Target.Value
Application.EnableEvents = True
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a sta...Column names??
My Column names are not showing-up as A, B, C, D...
They are showing-up as 1, 2, 3, 4, 5...
I do not understand why this is happening??
I have tried running: Excel.exe /regserver
In xl2003 and below:
Tools|Options|General|Uncheck R1C1 reference style
> My Column names are not showing-up as A, B, C, D...
> They are showing-up as 1, 2, 3, 4, 5...
> I do not understand why this is happening??
> I have tried running: Excel.exe /regserver