|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 14th, 2006, 07:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help needed!
I have a multiple page workbook and I need to consolidate all the information on one page. Problem is that some of the pages have different information than others and I need all line items accounted for. I do not want to put un needed information in all reports to make one unified report form as it would be too big. Any ideas how I can best do this? -- DBsWifeLB ------------------------------------------------------------------------ DBsWifeLB's Profile: http://www.excelforum.com/member.php...o&userid=10802 View this thread: http://www.excelforum.com/showthread...hreadid=522335 
|
|
#2
March 14th, 2006, 07:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help needed!
DBsWifeLB wrote...
I have a multiple page workbook and I need to consolidate all the information on one page. Problem is that some of the pages have different information than others and I need all line items accounted for. I do not want to put un needed information in all reports to make one unified report form as it would be too big. Any ideas how I can best do this? Too vague. You may want to consider adding a blank worksheet and using it to consolidate information from the other worksheets using simple formulas like =AnotherSheet!X99. You could leave the formulas in the other worksheets alone and still give the impression that you've consolidated everything into a single worksheet.
|
|
#3
March 14th, 2006, 07:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help needed!
ABC, LLC INCOME STATEMENT 12/31/2005 INCOME Income from Property Sales Sandwick $284,000 Total Income from Property Sales 284,000 Income from Partnerships Lakeridge Heights 440,968 Total Income from Partnerships 440,968 Income from Affiliate Construction Lifestyle Homes 820,049 Total Income from Affiliate Construction 820,049 Miscellaneous Income 4,825 TOTAL INCOME 1,549,841 COST OF SALES Construction Costs Thistle Street 1,350,815 Sandwick - Other Developments 3,713 Total Construction Costs 1,354,529 GROSS PROFIT 195,313 *********************************** DEF, LLC INCOME STATEMENT 12/31/2005 INCOME Income from Property Sales Heritage Eagle Creek 485,000 Total Income from Property Sales 485,000 Income from Partnerships Shorewood View 616,339 Total Income from Partnerships 616,339 Income from Affiliate Construction Lifestyle Homes 820,049 Total Income from Affiliate Construction 820,049 Miscellaneous Income 4,825 TOTAL INCOME 1,926,212 COST OF SALES Construction Costs Heritage Eagle Creek - Lifestyle Homes 769,784 Thistle Street 1,350,815 Other Developments 3,713 Total Construction Costs 2,124,312 GROSS PROFIT (198,100) ******************************** ABCDEF, LLC CONSOLIDATED INCOME STATEMENT 12/31/2005 INCOME Income from Property Sales Sandwick $- Heritage Eagle Creek - Total Income from Property Sales - Income from Partnerships Shorewood View - Lakeridge Heights - Total Income from Partnerships - Income from Affiliate Construction Lifestyle Homes - Thistle Street - Total Income from Affiliate Construction - Miscellaneous Income - TOTAL INCOME - COST OF SALES Construction Costs Heritage Eagle Creek - Lifestyle Homes - Thistle Street - Sandwick - Other Developments - Total Construction Costs - GROSS PROFIT - This doesn't look real pretty but you can at least see that the info on the first 2 pages contain some different info and the last one needs to have all the info. What formula would best work to add from all pages? -- DBsWifeLB ------------------------------------------------------------------------ DBsWifeLB's Profile: http://www.excelforum.com/member.php...o&userid=10802 View this thread: http://www.excelforum.com/showthread...hreadid=522335
|
|
#4
March 14th, 2006, 08:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help needed!
It appears you don't have any real option except manually creating the links.
Using the Construction Costs area as an example: Go to the first individual income statement, select the cells that contain the descriptions and the values, copy those cells (edit-Copy), then navigate to the consolidated worksheet, select the place you want the data to appear and use Edit-Paste Special-Paste link Repeat as needed "DBsWifeLB" wrote: ABC, LLC INCOME STATEMENT 12/31/2005 INCOME Income from Property Sales Sandwick $284,000 Total Income from Property Sales 284,000 Income from Partnerships Lakeridge Heights 440,968 Total Income from Partnerships 440,968 Income from Affiliate Construction Lifestyle Homes 820,049 Total Income from Affiliate Construction 820,049 Miscellaneous Income 4,825 TOTAL INCOME 1,549,841 COST OF SALES Construction Costs Thistle Street 1,350,815 Sandwick - Other Developments 3,713 Total Construction Costs 1,354,529 GROSS PROFIT 195,313 *********************************** DEF, LLC INCOME STATEMENT 12/31/2005 INCOME Income from Property Sales Heritage Eagle Creek 485,000 Total Income from Property Sales 485,000 Income from Partnerships Shorewood View 616,339 Total Income from Partnerships 616,339 Income from Affiliate Construction Lifestyle Homes 820,049 Total Income from Affiliate Construction 820,049 Miscellaneous Income 4,825 TOTAL INCOME 1,926,212 COST OF SALES Construction Costs Heritage Eagle Creek - Lifestyle Homes 769,784 Thistle Street 1,350,815 Other Developments 3,713 Total Construction Costs 2,124,312 GROSS PROFIT (198,100) ******************************** ABCDEF, LLC CONSOLIDATED INCOME STATEMENT 12/31/2005 INCOME Income from Property Sales Sandwick $- Heritage Eagle Creek - Total Income from Property Sales - Income from Partnerships Shorewood View - Lakeridge Heights - Total Income from Partnerships - Income from Affiliate Construction Lifestyle Homes - Thistle Street - Total Income from Affiliate Construction - Miscellaneous Income - TOTAL INCOME - COST OF SALES Construction Costs Heritage Eagle Creek - Lifestyle Homes - Thistle Street - Sandwick - Other Developments - Total Construction Costs - GROSS PROFIT - This doesn't look real pretty but you can at least see that the info on the first 2 pages contain some different info and the last one needs to have all the info. What formula would best work to add from all pages? -- DBsWifeLB ------------------------------------------------------------------------ DBsWifeLB's Profile: http://www.excelforum.com/member.php...o&userid=10802 View this thread: http://www.excelforum.com/showthread...hreadid=522335
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Loan Originators Needed | New Users | 0 | July 31st, 2004 07:05 PM | |
| Loan Originators Needed | General Discussion | 0 | July 30th, 2004 10:30 PM | |
| Slight change needed for VBA Code | Bob Vance | General Discussion | 6 | July 20th, 2004 05:17 AM |
| Expanding Data As Needed | MT | General Discussion | 2 | July 1st, 2004 12:52 AM |
| visio 2002 gpedit template needed | Maureen | Visio | 0 | May 5th, 2004 05:30 PM |
Linear Mode
