software

I have an Excel spreadsheet with 4 tabs. I have seen another spreadsheet
whereby you enter your social security number and it will populate for
example your commission amount. On this spreadsheet, there are no other tabs
so I don't where the financial information is coming? I am trying to recreate
this for another spreadsheet I am working on. Can someone please help?

Don't forget that a single sheet has in excess of 250 columns and 65,000
rows, so there is a lot of room to quot;putquot; a datalist in an out-of-the-way
location, and then access it with simple Vlookup formulas.

If you're looking for help with lookup formulas, start at this link of Debra
Dalgleish, and then post back with any questions:

www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;mayoslcquot; gt; wrote in message
...
gt; I have an Excel spreadsheet with 4 tabs. I have seen another spreadsheet
gt; whereby you enter your social security number and it will populate for
gt; example your commission amount. On this spreadsheet, there are no other
tabs
gt; so I don't where the financial information is coming? I am trying to
recreate
gt; this for another spreadsheet I am working on. Can someone please help?or under the format menu you can hide a whole sheet
--
paul
remove nospam for email addy!
quot;Ragdyerquot; wrote:

gt; Don't forget that a singor le sheet has in excess of 250 columns and 65,000
gt; rows, so there is a lot of room to quot;putquot; a datalist in an out-of-the-way
gt; location, and then access it with simple Vlookup formulas.
gt;
gt; If you're looking for help with lookup formulas, start at this link of Debra
gt; Dalgleish, and then post back with any questions:
gt;
gt; www.contextures.com/xlFunctions02.html
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt; quot;mayoslcquot; gt; wrote in message
gt; ...
gt; gt; I have an Excel spreadsheet with 4 tabs. I have seen another spreadsheet
gt; gt; whereby you enter your social security number and it will populate for
gt; gt; example your commission amount. On this spreadsheet, there are no other
gt; tabs
gt; gt; so I don't where the financial information is coming? I am trying to
gt; recreate
gt; gt; this for another spreadsheet I am working on. Can someone please help?
gt;
gt;

or hide some rows and columns within a sheet
--
paul
remove nospam for email addy!
quot;paulquot; wrote:

gt; or under the format menu you can hide a whole sheet
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Ragdyerquot; wrote:
gt;
gt; gt; Don't forget that a singor le sheet has in excess of 250 columns and 65,000
gt; gt; rows, so there is a lot of room to quot;putquot; a datalist in an out-of-the-way
gt; gt; location, and then access it with simple Vlookup formulas.
gt; gt;
gt; gt; If you're looking for help with lookup formulas, start at this link of Debra
gt; gt; Dalgleish, and then post back with any questions:
gt; gt;
gt; gt; www.contextures.com/xlFunctions02.html
gt; gt;
gt; gt; --
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt;
gt; gt; ---------------------------------------------------------------------------
gt; gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; gt; ---------------------------------------------------------------------------
gt; gt; quot;mayoslcquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I have an Excel spreadsheet with 4 tabs. I have seen another spreadsheet
gt; gt; gt; whereby you enter your social security number and it will populate for
gt; gt; gt; example your commission amount. On this spreadsheet, there are no other
gt; gt; tabs
gt; gt; gt; so I don't where the financial information is coming? I am trying to
gt; gt; recreate
gt; gt; gt; this for another spreadsheet I am working on. Can someone please help?
gt; gt;
gt; gt;