×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Filling Form, Extracting Data ??

Filling Form, Extracting Data ??

Filling Form, Extracting Data ??

(OP)
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

RE: Filling Form, Extracting Data ??

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

RE: Filling Form, Extracting Data ??

(OP)
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

RE: Filling Form, Extracting Data ??

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.

RE: Filling Form, Extracting Data ??

(OP)
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

RE: Filling Form, Extracting Data ??

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

RE: Filling Form, Extracting Data ??

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

RE: Filling Form, Extracting Data ??

(OP)
Hi Cummings54 & everyone that helped,

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

QuEST / GE Mechanical Designer

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources