Hello Everyone:
I have ws containing two tables of info that is vlookup'd from a range in a separate ws. The amount of data within the tables varies depending on the value of a data validated cell. I have already done a simple macro to autofilter the sheet but i cannot get the print area sorted.
Each table contains 42 rows and 5 columns that can be filtered down to a min of 7 rows each (obviously depends on the amount of data that is vlookup'd), there is also text inbetween the tables.
Also, does anyone have a code for selecting the 1st, 2nd, 3rd, etc data value within the data validated cell?
I'm really a beginner in VBA, any help would be great.
Many Thanks
Woody
I have ws containing two tables of info that is vlookup'd from a range in a separate ws. The amount of data within the tables varies depending on the value of a data validated cell. I have already done a simple macro to autofilter the sheet but i cannot get the print area sorted.
Each table contains 42 rows and 5 columns that can be filtered down to a min of 7 rows each (obviously depends on the amount of data that is vlookup'd), there is also text inbetween the tables.
Also, does anyone have a code for selecting the 1st, 2nd, 3rd, etc data value within the data validated cell?
I'm really a beginner in VBA, any help would be great.
Many Thanks
Woody
