HELP WITH EXCEL SPREADSHEET

[mayoslc]

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?

[Ragdyer]

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 "put" 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:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mayoslc" <[email protected]> wrote in message
news:[email protected]...
> 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?

[paul]

or under the format menu you can hide a whole sheet
--
paul
remove nospam for email addy!



"Ragdyer" wrote:

> Don't forget that a singor le sheet has in excess of 250 columns and 65,000
> rows, so there is a lot of room to "put" 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:
>
> http://www.contextures.com/xlFunctions02.html
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "mayoslc" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>

[paul]

or hide some rows and columns within a sheet
--
paul
remove nospam for email addy!



"paul" wrote:

> or under the format menu you can hide a whole sheet
> --
> paul
> remove nospam for email addy!
>
>
>
> "Ragdyer" wrote:
>
> > Don't forget that a singor le sheet has in excess of 250 columns and 65,000
> > rows, so there is a lot of room to "put" 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:
> >
> > http://www.contextures.com/xlFunctions02.html
> >
> > --
> > HTH,
> >
> > RD
> >
> > ---------------------------------------------------------------------------
> > Please keep all correspondence within the NewsGroup, so all may benefit !
> > ---------------------------------------------------------------------------
> > "mayoslc" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> >
> >