| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
ok, this is the best way i can describe my question. i have a workbook that has 2 sheets. Sheet 1 : client database. (Name,Address,Phone,loan amount,date, etc...) Sheet 2 : Client evaluation/scenario ( something similar to a loan calc. ) What I am trying to accomplish is, create 5000 worksheets that pull data from sheet 1. To do this page by page would take weeks. How can I create these sheets so that each new page pulls the information from the defaulting line? For example Sheet 1 : Database = 20 column 1-20 Sheet 2 : Pulls Data from Column 1 Sheet 3 : Pulls Data from Column 2 Sheet 4 : Pulls Data from Column 3 Sheet 5 : Pulls Data from Column 4 etc This would allow me to print my database with individual scenarios for each client. PLEASE HELP. Microsoft has given me the runaround and suggests I setup an account for software support. This cannot be that difficult. -- Amaxwell ------------------------------------------------------------------------ Amaxwell's Profile: http://www.excelforum.com/member.php...o&userid=37631 View this thread: http://www.excelforum.com/showthread...hreadid=572481 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
Creating 5000 separate worksheets would be wasteful to say the least.
A better way would be to create a template form and use a formula like VLOOKUP to display the data in the fields you want by entering the name, account number or whatever in a specified cell on that sheet. That way you would only need one extra sheet. Regards, Alan. "Amaxwell" wrote in message ... ok, this is the best way i can describe my question. i have a workbook that has 2 sheets. Sheet 1 : client database. (Name,Address,Phone,loan amount,date, etc...) Sheet 2 : Client evaluation/scenario ( something similar to a loan calc. ) What I am trying to accomplish is, create 5000 worksheets that pull data from sheet 1. To do this page by page would take weeks. How can I create these sheets so that each new page pulls the information from the defaulting line? For example Sheet 1 : Database = 20 column 1-20 Sheet 2 : Pulls Data from Column 1 Sheet 3 : Pulls Data from Column 2 Sheet 4 : Pulls Data from Column 3 Sheet 5 : Pulls Data from Column 4 etc This would allow me to print my database with individual scenarios for each client. PLEASE HELP. Microsoft has given me the runaround and suggests I setup an account for software support. This cannot be that difficult. -- Amaxwell ------------------------------------------------------------------------ Amaxwell's Profile: http://www.excelforum.com/member.php...o&userid=37631 View this thread: http://www.excelforum.com/showthread...hreadid=572481 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
im not sure how vlookup works. How would you use that if i wanted to print 500 individual worksheets from Sheet 1 -- Amaxwell ------------------------------------------------------------------------ Amaxwell's Profile: http://www.excelforum.com/member.php...o&userid=37631 View this thread: http://www.excelforum.com/showthread...hreadid=572481 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
Check out VLOOKUP in Help to get the general idea, post back if you're not
sure of the method, Regards, Alan. "Amaxwell" wrote in message ... im not sure how vlookup works. How would you use that if i wanted to print 500 individual worksheets from Sheet 1 -- Amaxwell ------------------------------------------------------------------------ Amaxwell's Profile: http://www.excelforum.com/member.php...o&userid=37631 View this thread: http://www.excelforum.com/showthread...hreadid=572481 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA
Hi
In same NG, I posted an some guidelines how to display data according selected conditions from a master sheet - look at thread "Automatically updating worksheets from a master worksheet" by Nlevans at 04.07.2006. Probably you get some ideas from there -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Amaxwell" wrote in message ... ok, this is the best way i can describe my question. i have a workbook that has 2 sheets. Sheet 1 : client database. (Name,Address,Phone,loan amount,date, etc...) Sheet 2 : Client evaluation/scenario ( something similar to a loan calc. ) What I am trying to accomplish is, create 5000 worksheets that pull data from sheet 1. To do this page by page would take weeks. How can I create these sheets so that each new page pulls the information from the defaulting line? For example Sheet 1 : Database = 20 column 1-20 Sheet 2 : Pulls Data from Column 1 Sheet 3 : Pulls Data from Column 2 Sheet 4 : Pulls Data from Column 3 Sheet 5 : Pulls Data from Column 4 etc This would allow me to print my database with individual scenarios for each client. PLEASE HELP. Microsoft has given me the runaround and suggests I setup an account for software support. This cannot be that difficult. -- Amaxwell ------------------------------------------------------------------------ Amaxwell's Profile: http://www.excelforum.com/member.php...o&userid=37631 View this thread: http://www.excelforum.com/showthread...hreadid=572481 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Pulling data from another workbook | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| How do I create a pivot table from multiple pages of data? | Excel Worksheet Functions | |||
Linear Mode
