Hello everyone, I was wondering if any one can help me regarding this problem, I want to create a VBA code, As the image attached there is Building, Building 1, Building 2... i want it to take the data under Building 1 and under Building 2 and Building 3... and puts it under the data in Building and delete the other columns, But i want it to search for columns like this as there is more than 1 example like this in the same file, Is it possible to be done with VBA code or normal excel functions? , I've also attached the file so you can check it out in "Report details" sheet
Screenshot_25.jpgForm detail report (4).xlsx
Thanks,
Ahmed
Bookmarks