Dear all , I tried to search and solve but I failed
I have two worksheets , in sheet1 there is one table is Table1 have 15 columns exist at row7 and down and in cell F3 there is data validation with 12 table names (months of the year) that exist in sheet2 , also I have sheet2 that has 12 Tables ( the names of the months of the year January February ,... ) each one has 8 columns exist at row7 and down and their header names are the same as some columns name in table1 in sheet1.
what I need when I choose the month name from cell I3 in sheet1 and press the rectangle shape where the code exist in:
to search for the same table name ( month that i choose in cell I3 in sheet1) and its header column name in row7 in sheet2 then go and copy the same 8 columns that exist in table1 in sheet1 that have the same header column name ,then paste the 8 columns data in the table named (as cell I3) in sheet2.
Note: I use excel 2016
Best Regards
Bookmarks