VBA Code to float,value,down Column for Index/Matching Value of other columns

[bdb1974]

Hi, I would like to amend my macro w/ additional code that will allow me
to view the value in column A, if a subject is chosen from list from columns
D or E. Choosing a singal subject to view from row2,from column,D or E will
cause the value in column A to not be seen if the subject does not correspond with the row the value is located. Is there a way to match
values from corresponding/matching column values with the rows with values
in columnA? And. allow if match found to display/list the value in the first empty cell in column A for match? I would also like the macro to reverse
match for column A. So if a single value is selected in column A for view,
then all rows for which the value pertains to will also be shown, instead of
just the single row with the value.

Here's an examplary make of the booklet.



This is over my head, and any help in getting this resolved is greatly appreciated.

Thanks,

bdb

[rylo]

Hi

Part of your original code removes the duplicate entries for the item number. Comment out that part of the code and each and every row will show the item number. That way when you filter, you will have all the data available.


rylo

[bdb1974]

Hi Rylo,

Yep, I did exactly that, and your right. It brought back the numbers to each row.


I'm still curious to know, if it's possible to float the value down the column, either by the stated method or by using the scroll bar or by some other means.

Thanks.

bdb

[rylo]

Hi

None that I can conceive. You would need to have code specifically to put them in, or, if they were there and "hidden" somehow, remove that "hiding" facility.


rylo