Filling Form, Extracting Data ?? 1

[JPM73]

Hi All..

I have a form created to track the histor of an engineering job. I would like to create another form that summarizes or extracts data of the engineering change forms, without having to do a bunch of copy & pastes.

Is there a macro that I can create that will extract data off of other worksheets & be entered onto my new form? If so, how?

Thanks




QuEST / GE Mechanical Designer

 

[MintJulep]

Lacking any detail on what you really want to do, it would seem possible with native functions and formulas.

 

[JPM73]

Hi,

Here's an attempt to clarify my first posting.

I have 2 main worksheets in the same file, each with its own different form. One worksheet or form has data pertaining to a particular Engineering job only. There will be multipe worksheets or forms like this, but the data containted on each form is for a specifice Engineering job.

I would like to create a summary form that easily extracts data from a specified worksheet & cell without having to do a bunch of cut & pastes or having to modify a formula to equal the data to a specific worksheet & cell multiple times.

I know there is some type of extraction feature available because I've seen in other spreadsheets. However, I don't know if works through a macro or through formulas & how it works.

I hope this clarifies what I'm trying to attempt & someone out here can provide some guidance.

Thanks

QuEST / GE Mechanical Designer

 

[cummings54]

Supose each of your specific job forms has range names that identify the fields. For example on Sheet1 you have JobNumber defined as Sheet1!A1 and ProjectName defined as Sheet1!A2. That is each field has been defined as a local range name. It can be one once for a template and copied for each new job. I've attached a sample workbook that shows a summary and five job forms.

 

[JPM73]

Hi Cummings54 or Whoever else that can help,

I entered the formula & named the cells as it appears in the example file. I can't find anything different, other than the names I'm giving.

For some reason, I am gettnig a '#REF' error.

I must be missing something?

Here's the formula on my summary sheet:

=INDIRECT(C5&"!MLI") on my "Summary" worksheet

My Engineering worksheet is called, "MLI 0705-DCI 07026836"


Cell E10 has been renamed, "MLI".

Why would I get a '#REF' error?

Thanks


QuEST / GE Mechanical Designer

 

[cummings54]

Your formula need to be rewriten because of the space in your worksheet name. Try

=INDIRECT("'"&C5&"'!MLI")

Or better...
don't use spaces in the worksheet name

 

[yakpol]

JPM73,

It looks like you are dealing with classical database problem. I would create a List (Data - List - Create List) which will provide you an easy way to sort and display data in any way you wish. This way you will need to support only one worksheet with complete listing of jobs in it. Try, it's easy.

Yakpol

 

[JPM73]

Hi Cummings54 & everyone that helped,

Tweeking my formula to, =INDIRECT("'"&C5&"'!MLI") helped.

QuEST / GE Mechanical Designer