3 Messages
Digest #3722
2a
Re: unable update download table despite already refreshed calculati by "Randy Harmelink" rharmelink
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
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 :)
>
>
*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"
> 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 :)
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"
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar