Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 07, 02:30 PM posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
SSJ SSJ is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 58
Default LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS

Hello there!

I need guidance in coming up with an easy way to link my MAIN SHEET tab to various project tabs. The current way I am accomplishing this task is quite tedious.

1) Data in the MAIN SHEET is not in a list form. The MAIN SHEET is a complex work of art of download links and formulas. The MAIN SHEET contains data on multiple projects. Each project has varying numbers of work orders and of course more are added as needed. Some of the fields/columns for each project/work orders a in the area of actual cost (labour hours, labour cost, & material), additional cost (labour hours, labour cost, & material), Forecast (labour hours, labour cost, & material), amounting to almost 30 columns.

2) Each project along with its work orders are listed in its own project tab. A particular project tab will list all the work orders from the MAIN SHEET with it related fields/column of actual cost, additional cost, forecasts, etc.

3) I have inherited this spreadsheet and the way it was done current, which i want to change is as follows:

i) I open a tab for a project. The lay out of the project sheets are identical to the MAIN SHEET, however, the number of work order varyies. The number of work orders are in hundreds.
ii) List all the work orders numbers and description
iii) Manually link each and every field (there are 30) of the work order (there are 100s) with the corresponding cell in the MAIN SHEET.

As you can see it is pretty tedious. I need ideas how it can be made easy.

Thanks
SJ

  #2   Report Post  
Old July 3rd 07, 03:55 PM posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS

Sounds like a project for a professional
Pls dont post in html
--
Don Guillett
SalesAid Software

"SSJ" wrote in message
...
Hello there!

I need guidance in coming up with an easy way to link my MAIN SHEET tab to
various project tabs. The current way I am accomplishing this task is quite
tedious.

1) Data in the MAIN SHEET is not in a list form. The MAIN SHEET is a complex
work of art of download links and formulas. The MAIN SHEET contains data on
multiple projects. Each project has varying numbers of work orders and of
course more are added as needed. Some of the fields/columns for each
project/work orders a in the area of actual cost (labour hours, labour
cost, & material), additional cost (labour hours, labour cost, & material),
Forecast (labour hours, labour cost, & material), amounting to almost 30
columns.

2) Each project along with its work orders are listed in its own project
tab. A particular project tab will list all the work orders from the MAIN
SHEET with it related fields/column of actual cost, additional cost,
forecasts, etc.

3) I have inherited this spreadsheet and the way it was done current, which
i want to change is as follows:

i) I open a tab for a project. The lay out of the project sheets are
identical to the MAIN SHEET, however, the number of work order varyies. The
number of work orders are in hundreds.
ii) List all the work orders numbers and description
iii) Manually link each and every field (there are 30) of the work order
(there are 100s) with the corresponding cell in the MAIN SHEET.

As you can see it is pretty tedious. I need ideas how it can be made easy.

Thanks
SJ

  #3   Report Post  
Old July 9th 07, 03:13 AM posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 1,230
Default LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS

"SSJ" wrote...
....
3) I have inherited this spreadsheet and the way it was done current,
which i want to change is as follows:

i) I open a tab for a project. The lay out of the project sheets are
identical to the MAIN SHEET, however, the number of work order varyies.
The number of work orders are in hundreds.
ii) List all the work orders numbers and description
iii) Manually link each and every field (there are 30) of the work
order (there are 100s) with the corresponding cell in the MAIN SHEET.

....

You could use a macro to do this. Easiest to start by using the Macro
Recorder to record the steps needed to do this for one one project
worksheet. Then post the recorded macro and others here could help
generalize it to loop through all worksheets other than MAIN SHEET.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summary Sheet - Total Multiple Sheets Gayla Excel Discussion (Misc queries) 6 June 25th 07 10:17 PM
Summary Sheet help with multiple sheets lacey125 Excel Discussion (Misc queries) 1 September 21st 06 08:40 PM
Linking References from Multiple Sheets to One Summary Sheet Kim Setting up and Configuration of Excel 3 May 5th 05 04:56 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017