I have a sheet which contains dynamic data (sheet2 in the attached workbook), refreshed frequently. Data displayed relates to a specific country, selected from the dropdown in A1. The only manual entries one can make are in column E. The rest of the calculations are based on the manual entries.
Now I want to transfer this data on another sheet (sheet3), so that information for the countries are stored one after the other, in the same format as sheet2.
I am unfamiliar with Macros/VBA so any help in bringing about the solution would be highly appreciated.
Many thanks in advance!