OK VBA ninjas, this is beyond my skillset.
Problem statement:
"Examine a "filename" containing numbers and letters in one cell, and find the most recent revision number in another directly adjacent cell. Hide all rows except row containing the most recent revision."
1) Here's an example of the data (below):
Column "A" Column "B"
(Filename) (revision)
1401UC 9
1401UC_Rev0005 5
1401UC_Rev0006 6
1401UC_Rev0007 7
1403UC 8
1403UC_Rev0006.zip 6
1403UC_Rev0007 7
2)Nice to have an inputbox for number of characters to be examined in filename ???
3)Nice to have an inputbox for column ID containing filename,
4)Nice to have an inputbox for column ID containing revision info.
5)revision information is numeric only,
6)Filename information is numeric and letters = variant?
Thank you so much for the help; this is beyond my skillset.
-netbeui
Problem statement:
"Examine a "filename" containing numbers and letters in one cell, and find the most recent revision number in another directly adjacent cell. Hide all rows except row containing the most recent revision."
1) Here's an example of the data (below):
Column "A" Column "B"
(Filename) (revision)
1401UC 9
1401UC_Rev0005 5
1401UC_Rev0006 6
1401UC_Rev0007 7
1403UC 8
1403UC_Rev0006.zip 6
1403UC_Rev0007 7
2)Nice to have an inputbox for number of characters to be examined in filename ???
3)Nice to have an inputbox for column ID containing filename,
4)Nice to have an inputbox for column ID containing revision info.
5)revision information is numeric only,
6)Filename information is numeric and letters = variant?
Thank you so much for the help; this is beyond my skillset.
-netbeui