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
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 ??
RE: Filling Form, Extracting Data ??
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 ??
RE: Filling Form, Extracting Data ??
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 ??
=INDIRECT("'"&C5&"'!MLI")
Or better...
don't use spaces in the worksheet name
RE: Filling Form, Extracting Data ??
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 ??
Tweeking my formula to, =INDIRECT("'"&C5&"'!MLI") helped.
QuEST / GE Mechanical Designer