Hi, Im quite new to vba.
I have a spreadsheet that has several tabs labelled 2012,2013,2014 with investor distributins. they have the same layout but contain different ranges of data.
I have created a filter that filters each of these sheets according to criteria such as country of origin or type of product.
I then want to create a macro that takes a range to the last non blank cell in column A and copies all the cell A7:AQ7 and down of the filtered values, then consolidates the values from those sheets into 1 copying only the filtered out data.
Is there a way to do this? the problem I currently have is that there are other spreadsheets in the workbook that i do not want consolidated, only the ones labelled 2012-14.
my plan is to later create a dynamically changing dropdown list from the data that has been consolidated on the worksheet. this has to be done every time i run the macro,.
I know that there is a filter function in excel, however it does not surve the correct purpose in this case
any help would be much appreciated
Bookmarks