Senin, 06 Juni 2016

[smf_addin] Digest Number 3722

3 Messages

Digest #3722

Messages

Sun Jun 5, 2016 9:59 pm (PDT) . Posted by:

perseuslim11

Yellow Cell C6 = Magni ( ='@Input'!$E$1) Blue Cell B6 = 7087 ( ='@Input'!$E$2)


the ones in the bracket are the actual reference formula to another worksheet

Sun Jun 5, 2016 11:16 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

From the first link in the "FAQs and Tips" page about the macro:

*Here is the documentation for the table setup from the macro's module: *

1. *The upper left hand corner cell of the table needs to have a range
name of "Ticker"*
2. *The cells below the "Ticker" cell should be filled in with ticker
symbols, one per cell*
3. *The cells to the right of the "Ticker" cell should be filled with
column titles*
4. *The cells above the column titles need to be filled in with SMF
add-in formulas or element numbers.*

On Sun, Jun 5, 2016 at 9:56 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> But I thought if the cell to the left has a ticker symbol. it will work?
>
> the cell contains this symbol "Magni", it was referring to another cell
> from a diff worksheet, in my workbook it has value :)
>
>

Mon Jun 6, 2016 2:03 am (PDT) . Posted by:

"joo zhi" perseuslim11

Yes, I know the FAQs and tips regarding the 4 points below... my worksheet fulfills all 4 of these criteria..
It's just that I sent you an individual worksheet copied into a new workbook, hence you r unable to see the ticker symbol to the left 

Sent from Yahoo Mail on Android

On Mon, 6 Jun, 2016 at 14:16, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

From the first link in the "FAQs and Tips" page about the macro:

Here is the documentation for the table setup from the macro's module:

- The upper left hand corner cell of the table needs to have a range name of "Ticker"
- The cells below the "Ticker" cell should be filled in with ticker symbols, one per cell
- The cells to the right of the "Ticker" cell should be filled with column titles
- The cells above the column titles need to be filled in with SMF add-in formulas or element numbers.

On Sun, Jun 5, 2016 at 9:56 PM, perseuslim11@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

But I thought if the cell to the left has a ticker symbol. it will work?
the cell contains this symbol "Magni", it was referring to another cell from a diff worksheet, in my workbook it has value :)

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar