Posts by tharusha

thank Mumps it works

Mumps thanks for the reply but its not removing the top blank row

hi guys i looking a code to check a way

if all the columns are empty delete the row

plz find the attachment

royUK error is still my my destination sheet is sheet1

Thanks you i found it dim as worksheet was wrong

Set DestSht = wbTo.Sheet1

Hi royUK im facing an error in this line "object not support the property method"
are you able to check it

royUK thanks

royUK if i run the code serveral times i need to append them from the last row of the target excel (mainfile.xlsx)

Hi alansidman

plz find the two attachment

hi i have two excel files i need to append only selected columns to another wordbook sheet how can i do that (column name might be change but the data are same)

Hi royUK

plz find the excel sheets

i need to append all duplicate data from data.xlsm to appendindata.xlsm based on "country" column on data.xlsm workbook

so need to append all duplicate country coloum rows to a new worksheet .how can i do that