santosh59211
06-16-2014, 08:09 AM
Hello
we want that macro or VBA for work following
Macro open a database.xls file (diloge box open where file to chose).. in this database file there is 3 sheets (roadlist, prarup-1, Prarup-2)
after choose we want copy data from DATABASE.XLS FILE TO MASTER.XLS FILE WITH FOLLOWING RANGE..
ROADLIST SHEET : from Range colum A4 to H (end of last row in sheet)
prarup-1 : from Range colum A4 to end of colum & end of row
prarup-2 : from Range colum A5 to end of colum & end of row
hope i clear my problem what i want..
looking for +ve responce..
my file's are attach in zip file
we want that macro or VBA for work following
Macro open a database.xls file (diloge box open where file to chose).. in this database file there is 3 sheets (roadlist, prarup-1, Prarup-2)
after choose we want copy data from DATABASE.XLS FILE TO MASTER.XLS FILE WITH FOLLOWING RANGE..
ROADLIST SHEET : from Range colum A4 to H (end of last row in sheet)
prarup-1 : from Range colum A4 to end of colum & end of row
prarup-2 : from Range colum A5 to end of colum & end of row
hope i clear my problem what i want..
looking for +ve responce..
my file's are attach in zip file