Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH EXCEL SPREADSHEET
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH EXCEL SPREADSHEET
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH EXCEL SPREADSHEET
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" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH EXCEL SPREADSHEET
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Importing an Excel spreadsheet from the web. | Excel Discussion (Misc queries) | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |