Hello,
I have data in many sheets. what I want macro show inputbox first should write sheet name , second write columns(EX: A,G,H,K,N)
then will arrange columns in location based on sheet name and columns letters are written in inputbox.
if the inputbox is empty then show message "please fill" ,if I cancel or close then will exit , if the sheet name is wrong then the message" the sheet name is not existed" and keep inputbox open to write right sheet name , if write column doesn't contain headers in row1 and are empty cells(entire column is empty) then show message" columns are no data so you can't arrange" and copy the rest of columns contain data . ex: column A,D ,F are empty , column K,M contain data then message should indicate to reference columns are empty.
thanks
I have data in many sheets. what I want macro show inputbox first should write sheet name , second write columns(EX: A,G,H,K,N)
then will arrange columns in location based on sheet name and columns letters are written in inputbox.
if the inputbox is empty then show message "please fill" ,if I cancel or close then will exit , if the sheet name is wrong then the message" the sheet name is not existed" and keep inputbox open to write right sheet name , if write column doesn't contain headers in row1 and are empty cells(entire column is empty) then show message" columns are no data so you can't arrange" and copy the rest of columns contain data . ex: column A,D ,F are empty , column K,M contain data then message should indicate to reference columns are empty.
thanks
