To Frank Kabel or anyone who knows how

[Guest]

Here is a copy of the data as it is entered into the spreadsheet general data entry section in it's native state

10036305 SF PAL 13 115 Yes Teiji
10037323 FSV HC 13 115 No Teiji
10037325 SF MF 13 115 No Teiji
99998810 SF AR 13 115 No Teiji
10037584 SF AR 13 115 No Teiji
10037642 SF PAL 13 115 Yes Teiji

What I'd like is to have is the entire record plugged into a hidden range elsewhere on the spread sheet once the product is selected from a drop down in the second column in the main data entry section. I want to have each range per product look as the sample below

10036305 SF PAL 13 115 Yes Teiji
10037642 SF PAL 13 115 Yes Teiji

-------------------------------------

10037323 FSV HC 13 115 No Teiji

-------------------------------------

10037325 SF MF 13 115 No Teiji

------------------------------------

99998810 SF AR 13 115 No Teiji
10037584 SF AR 13 115 No Teiji

The product selected in column two would determine which hidden range the record's value gets plugged into. Hope this helps explain what I'm attempting to accomplish. It may not even be possible, but, if it is, HOW

Thanks

 

[Frank Kabel]

Hi Russ
I'm still not sure what you want to achieve (sorry for that9 but from
what I understand you'll need VBA (macros that are triggered by
selections, whcih move data to other ranges, etc.). From your
specification this can't be done with formulas. Though I'm still not
sure what you mean with 'plugged'

Frank

 

[Guest]

Thanks, for responding Frank.

What I want is to have the value of the complete record copied to another area of the spreadsheet within a range setup to group the records by product as in the previous data samples shown.

Hope this helps!

I attempted a MATCH/INDEX function last week which looked to the "Product" column to copy the record to the range based on the product selected. However, there were problems with it. From what I've been reading a MATCH/INDEX function may work, not sure though.