Formula in Excel 07 to get the formula used in one cell in another cell, showing VALUES, not cells references
I'm gonna illustrate this by an example as I think it is the easiest
way to explain what I need:
A1 = 10
A2 = 5
A3 = 2 because A3 = A1/A2
Now, what I want is to be able to in cell B3 to write some sort of
formula e.g. =GetFormula(A3) that will give me:
=10/5 and NOT =A1/A2 , NOR 2
Does anyone know what I can do?
I don't know how to work with VBA or anything, but I know how to copy-
paste if you know the codes.
I previously got the following answer:
Here is a custom function that will do what you want.
To install the custom function:
Alt+F11 to ope...References...
I have one column with names and nationalities, the latter as an abbreviation
such as “(USA)”
In a separate list I have to sum the different nationalities. Somewhat like
(The names in this col. A may be typed in the cells or come from a formula)
The List in say, col. Q and R, should the look like this:
Great Britain 1
The column in Q with the country names exists already and the two columns
(Q:R) should be able to be s...Cell reference #5
What technique is used by excel for cell referencing?
Microsoft excel uses absolute references
Click "Yes" button if it helps
> What technique is used by excel for cell referencing?
"Suleman Peerzade" wrote:
> Microsoft excel uses absolute references
> Click "Yes" button if it helps
> Suleman Peerzade
> "Vick" wrote:
> > What technique is used by exc...Integration Mgr-GL Reference
We use Integration Manager to integrate our semi-monthly invoices into the
GL. The Reference field was inadvertently not changed when the end of the
month invoices were integrated. Consequently all of our Aug inv have an 8/15
Is there a way to change the reference to the correct date?
We use Great Plains eEnterprise 7.00g12
Thank you, Susan
The clean way would be to use your integration file and reverse the debits
and credits, then reimport the file. This will effectively reverse your
Then modify the file again by adjusting the reference fiel...How to get the answer to reference a worksheet
For example - if the answer to a calculation is 18, then look in sheet named
"18". If 19, then look in sheet "19".
Use the INDIRECT function. E.g.,
This will return the value in cell A10 from the sheet named in
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Marcus Fox" <please-reply-via-newsgroup-th@-i-posted-to.com>
wrote in message
> F...Calculating a cell reference
Hi, it is possible to get excel to recognise a cell reference based on a
I have this formula which gives me a number that i'd like to use as a row
I also know the column letter that I'd like to use, but have no idea how I
can marry the 2 together so that I can then use the CELL("Contents", )
function on the cell and display the contents in a particular cell.
Any ideas, or if I'...Transferring cell content between workbooks using cell references
I want to transfer cell content onto a spreadsheet that has a list of
cell references pertaining to a series of other workbooks. The cell
references are in the A1 reference style and there are about 800 from
8 different workbooks. Is there an efficient way (macro, formulas?)
that you can do this � I can't seem to see the wood for the trees. If
anyone has any ideas it would be appreciated.
not really sure what you want to transfer. Do you want to transfer the
values returned from these formulas?
"Kiwi Mike" &l...Entering a cell value in a reference
Win98SE / Excel 2000 / Basic level user
I have what I think must be a fairly simple question...
I have our sales figures for the past 3 years entered on a spreadsheet in
columns. Column A has figures for 2004, B is 2003, etc. There are 52 rows,
one for each week of the year. I use the figures in B, C and D to help
predict what our sales are going to be this year based on previous years
performance to date.
I would like to enter a number in one cell and use it as part of the cell
reference in other cells. For example, I would enter "4" in one particular
cell and then have formu...How can I remove unwanted returns above a footnote?
When I insert a footnote, Word adds two paragraph returns above the footnote
text. I see a short horizontal rule, two returns, and then my text. I am
unable to select the unwanted returns - and the horizontal rule for that
matter. I am using Word 7. I'll appreciate any help on this!
Switch to Draft view. On the References tab, click Show Notes. In the Footnotes
pane, choose to display the Footnote Separator. Delete the excessive paragraph
Microsoft Word MVP
"Beth Obenshain" <BethObenshain@discussions.microsoft.com> wrote in mes...name references
I have constants name1, name2, name3 etc.
I have a loop structure with a counter. If the counter is at 3, then I want
to use the constant name3. If it is at 2 then I want to use the constant
How do I reference the correct constant?
"name" & xloop
On Sat, 6 Feb 2010 14:39:02 -0800, SuzyQ <SuzyQ@discussions.microsoft.com>
>I have constants name1, name2, name3 etc.
>I have a loop structure with a counter. If the counter is at 3, then I want
>to use the constant name3. If it is at 2 then I want to use the constant
is it possible or a reference to allow me to extract data from a html
file... example, i needed my vba code to return me all href and src attribs
values from a few selected tags. do i have to clearly write a code from
scratch? someone in my office said to look up on DOM, something on object
model or something, but non of us here know enough about vba to make a clue
in the vast sea of tech abbriviation.
could someone point me in a direction? anything that helps would be greatly
ps: could anyone past a small code that would allow me to open a simple text
file and pull i...Linking a reference within a formula
Is it possible to have a link to another cell that is derived from a
I have a spread sheet that is created weekly that displays our daily
forecasts. Each week is stored in the same spreadsheet, but the individual
day's forecast location differs. I've created a concatenate formula that
gives me a link to the formula as it should read in the spreadsheet, but I
cannot get the data in the other spreadsheet to populate....any help?
Check out the INDIRECT function.
*Remember to click "yes" if this post helped you!*...Cross Reference not Updating
I have paragraph styles with numbering and the reference to the first
paragraph will not update when it moves. All the other references work fine.
If I had:
4. this references 1.
5. this references 2.
6. this references 3.
If I add a new one, e.g.,
1. New One
5. this references 1. (SHOULD BE 2, stays 1)
5. this references 3. (Works)
6. this references 4. (Works)
Any ideas why?
Cross-references don't update automatically. You have to update them
explicitly with Ctrl+A, F9 or by switching...Calculated range reference in graph
=QTData!$E$2:"$E$"&COUNTA(QTData!E:E) gives an error in the graph X Values
field. I want to graph some data that I load from Access. The problem is
that I do not allways want to plot the same number of points. What I hoped
would work is just to concatenate the calculated end to the range statement.
How do I make this work?
not tested but try:
"Compcat" <Compcat@discussions.microsoft.com> schrieb im Newsbeitrag
news:117DC5E9-1D92-4E8C-8150...How to add Assembly as Reference
In order to have access to the APIs used in a aspx page, you need to add a
reference to the Microsoft CRM SOAP Proxy assembly: Microsoft.CRM.Proxy.dll
What does this mean ? Is it enough to copy <Microsoft.CRM.Proxy.dll> to the
<C:\Inetpub\wwwroot\crm\bin> folder or something else is neeeded ?
no that is not enough
you need to create a reference to the assembly inside of visual studio but
selecting project-add reference then choosing the microsoft.crm.proxy.dll
"Sebastiano Castrini" <[remove this]firstname.lastname@example.org> wrote in message
news:OXJ...Cross-Reference Dialog Box No Longer Works Right
This is a change in Word 2007 from previous versions, and it's starting to
drive me crazy.
I often insert a cross reference to a "numbered item" - normally a heading.
You can do with keystroke shortcuts or by clicing "Cross-reference" in the
The problem is with the little dialog box that pops up at this point. Its
main window shows, in outline form, all the headings in the document, and I
then pick the one to which I want to insert a reference.
Except ... it doesn't. The main window in the dialog box OMITS all the
...reference to a formula
Hi I have a workbook that has several formulas and 15 sheets which causes
the workbook to be very large. Is there a way to reference to a formula
instead of copy and pasting the same formula on every worksheet?
On Feb 17, 6:23=A0pm, "Fawn Lagimodiere" <flagimodi...@shaw.ca> wrote:
> Hi I have a workbook that has several formulas and 15 sheets which causes
> the workbook to be very large. =A0Is there a way to reference to a formul=
> instead of copy and pasting the same formula on every worksheet?
Group the sheets, select the first she...Object reference not set to an instance of an object.
I have some code which simply reads a RSS with the
XmlTextReader and XmlDocument. Unfortunaly I get the error:
Object reference not set to an instance of an object.
Here is my simple code:
private function CheckRSS(byval strRSS as string)
Dim reader as new XmlTextReader(strRSS)
Dim xmlDoc as XmlDocument
Catch ex As Exception
Response.Write("ERR in Rss File:" & strRSS
Response.Write("Err: RSS File:" & ex.Message
& "...bar code help, adding asterix to reference
A simple one im sure, cell b4 contains a number, i want cell c4 to display
the same number with an asterix (asterisk?) at either side for my bar code
What's the correct way to enter this?
Many thanks as ever,
seems to work after some trial and error,
could there arise a problem doing it this way?
"R D S" <email@example.com> wrote in message
> A simple one im sure, cell b4 contains a number, i want cell c4...Excel 2007: "Reference is not valid" when refreshing pivot table
I have a pivot table that works fine in Excel 2003. I've created an
Excel 2007 version and some code fails because (in VBA) "The
PivotTable report was saved without the underlying data". Yet, when I
manually try to refresh the pivot table, I get a message saying
"Reference is not valid". I've had a look at the source data, but
there doesn't appear to be any issues with that. Can anyone suggest
what the error might be?
BTW, I'm not sure if I've cross-posted correctly (excel.misc &
excel.programming), so apologies if this causes...Autofill declining reference.
I am currently using Excel XP on a Windows 2000 system. I
am trying to do an auto fill of a decling refference with
increasing rows the cells should decrement by 2 as
follows: row 160 "=C33355", row 161 "=C33353", row
162 "=C33351" When I fill in a few of these and try to do
an autofill I get sequence that makes no sense. Am I
trying to do this the wrong way? Is there another option
to make the auto fill work properly?
enter the following in cell A160:
George Wils...Good reference source for Pub2003
I got Pub2003 with my office upgrade. This is the first time I've used=20
Publisher and can see some great use for my small business.
Although I'm pretty savvy with other office applications, this one is a =
different. I went to my local Barnes and Noble by couldn't find any =
for 2003. There is one for 2002.
We're there many important changes between Pub2002 and Pub2003? Does=20
anyone have a good reference book specific to Pub2003?
Tom <firstname.lastname@example.org> posted:...Excel 2007: Column Reference changed from Alpha to Numeric, ?
A Workbook I've been resaving as different versions recently changed
it's column references to numbers instead of letters. So, B=2, AA=27,
etc. Also, when I build forumlas the reference for a cell is it's row
x cell, each of which as position X & Y coordinates. There are some
copy/paste issue with formulas, which may or may not be related.
Tools / Options... General tab, UNcheck "R1C1 reference style"
MS Excel MVP
<email@example.com> wrote in message
>A Workboo...How to reference a text cell that changes weekly in Header or Foo.
In LOTUS 1-2-3 in the Header or Footer you can reference a text cell in the
worksheet and have the contents appear in the Header/Footer. The text cell
referenced changes weekly for date or some other text and this command puts
the text automatically in the Header/Footer. How do you do this in EXCEL/
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.LeftFooter = Format(Date, "dd mmm yyyy")
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the...absolute cell reference A spreadsheet cell reference that does no
Well help with what!?
Enter your question in the Body of the message instead of the Subject line.
Your question got cut off!!
Do you just want to use an absolute reference? If so enter $'s around your
$A$1 -or- $A1 -or- A$1
A $ preceding the column reference ensures the column letter doesn't change.
A $ preceding the row reference ensures the row number doesn't change.
Does that help?