hai all forum member,
Please help me about this case, I want to break down the data in a particular column in a table and move the results of each of the data in the last column to the other sheets (separated sheet). For example, there is a table with his column title header cities and population. on a column of data contained city of Jakarta, Bali and Bandung with each 1000,1500,2000 population. I want to break down each column of the city and the number of people to another sheet and rename the sheet breakdown products in accordance with the specified column. Solving the column based on the column of the city, so the end result on the second sheet (sheet name into Jakarta and the contents of the column sheet cities (Jakarta) and population (1000), the third sheet (sheet name into the sheet and fill bali city column (bali) and population (1500), on sheet 4 (sheet name into the sheet duo and fill the city column (Bandung) and population (2000), please enlightenment friends. If done manually copy and paste it will take a long time . Please help how to code macros to execute it. Thanks for the enlightenment.
Please help me about this case, I want to break down the data in a particular column in a table and move the results of each of the data in the last column to the other sheets (separated sheet). For example, there is a table with his column title header cities and population. on a column of data contained city of Jakarta, Bali and Bandung with each 1000,1500,2000 population. I want to break down each column of the city and the number of people to another sheet and rename the sheet breakdown products in accordance with the specified column. Solving the column based on the column of the city, so the end result on the second sheet (sheet name into Jakarta and the contents of the column sheet cities (Jakarta) and population (1000), the third sheet (sheet name into the sheet and fill bali city column (bali) and population (1500), on sheet 4 (sheet name into the sheet duo and fill the city column (Bandung) and population (2000), please enlightenment friends. If done manually copy and paste it will take a long time . Please help how to code macros to execute it. Thanks for the enlightenment.
