Sorry, should have checked which version of excel you have. The enable/
disable the option in 2007:
1. Click the Office button and then click Excel Options. Excel
displays the Excel Options dialog box.
2. Click Advanced at the left side of the dialog box.
3. In the Editing Options section, clear t
Hi Spud
I mean for example, Cell A1... I have a formula = Sheet2!A3.
I have a worksheet for for example Feb GST incurred ... (I have lots which
are to caculate for exmpale.. FBT, Deposits.. different types of costs.. )
And i also have a workbook (separate file) which summarize all of these
wor
Dear All,
I need Urgent Help, How can calculate week by
formula in excel without vb script, Please find the attachment of data. i
am using but i can't got result
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Mon, Mar 22, 2010 at 12:27 PM, Yahya wrote:
> Dea
Hello Dear,
You can use go to reference.Sample sheet with code is attached.
I think it will help you.
Hope it will Help
Happy To Help
:)
Shyam
On Tue, Mar 23, 2010 at 5:19 AM, Spud wrote:
> Can you post an example showing how the format of the cell values (you
> mention that the cell valu
Can you post an example showing how the format of the cell values (you
mention that the cell value can be a workbook and a cell: does it show
the path correctly for the workbook? Unless you know the correct path
for the workbook, or they're all in the same path/folder, then it
would be impossible t
The problem is then I need a create hyperlink manually..
Then I need to create hundreds hyperlink..
Also, everytime I click the cell, it takes me to the reference cell, which I
don't want to. I want to go to the reference cell when I want to.
That's why I don't think Hyperlink is a solution.
Du
Dear Mark
I think you can do it by just using a Hyperlink. No need for macros. Please
see the attached file
Yahya
On Mon, Mar 22, 2010 at 2:37 AM, Markkim wrote:
> Hi
>
> I am wondering if anyone can help me creating a macro for the
> following..
> Get a reference from the selected cell and
Hi
I am wondering if anyone can help me creating a macro for the
following..
Get a reference from the selected cell and take me there .
For example, A1 contains C4. The macro will take me to C4. This is a
very simple one.
A1 contains a reference Sheet2!C4. I’d like the macro to take me
sheet2 C4.