How Do I do this?
Select contents from "Column I" from sheet named "Data" Select Distinct values from this column and then transpose it and paste in another sheet called "ClassCount" in the cell D to H. Now select formula of column D1,E1,F1,G1,H1 of sheet "Sheet1" and paste it in Sheet"Classcount" in cell D1, E1,F1, G1,H1 respectively. Now I have a column "Time: which is in numbers example: 480,510,540,...I want to convert it into 8:00AM, 8:30AM,9:00AM...respectively....How do i do all these using VBA macros?
Your help will be much appreciated. Thank you in advance
Select contents from "Column I" from sheet named "Data" Select Distinct values from this column and then transpose it and paste in another sheet called "ClassCount" in the cell D to H. Now select formula of column D1,E1,F1,G1,H1 of sheet "Sheet1" and paste it in Sheet"Classcount" in cell D1, E1,F1, G1,H1 respectively. Now I have a column "Time: which is in numbers example: 480,510,540,...I want to convert it into 8:00AM, 8:30AM,9:00AM...respectively....How do i do all these using VBA macros?
Your help will be much appreciated. Thank you in advance
