Dear All, im an Educator n preparing my schemes of work on excel n then save as pdf to send to admin of schools. However they now want it on excel but i hv only one table with a drop down in cell A4. As i change it using vlookup it fills the table for one week n i do same for every week. But i want a vba code which can automate this dropdown A4 and copy the table paste on another sheet n populates it one after the other until the dropdown ends.
Please help
Please help