hello dears
i'm using ms-excel 2016, under windows-7 sp1.
i usually get files workbooks each one has 1 or many sheets
i want to collect data from these files / sheets into master workbook in one sheet
will copy all data mostly but in some columns by different order.
sheets have data like this:
id, name, address, telephone,branch,area, ...
master sheet will have:
id, name,adress,telephone-1, telephone-2,area,branch
in most cases if customer has 2 telephones data entery system enter it in 2 rows, like this:
id, name, address, telephone,branch,area
g13, jake, 7 st., 23456343, ,
k12,johne,ca st., 142635, ,
k12,johne,ca st.,150979, ,
in master sheet will be like this:
id, name, address, telephone-1,telephone-2,area,branch,verified_id
g13, jake, 7 st.,456343, , ,
k12,johne,ca st.,142635,150979, , ,k12
just will add the id at the end to verify that this data coppied from the same customer id.
hope i explained it fine, as a visually impaired unable to show screenshot.
many thanks
i'm using ms-excel 2016, under windows-7 sp1.
i usually get files workbooks each one has 1 or many sheets
i want to collect data from these files / sheets into master workbook in one sheet
will copy all data mostly but in some columns by different order.
sheets have data like this:
id, name, address, telephone,branch,area, ...
master sheet will have:
id, name,adress,telephone-1, telephone-2,area,branch
in most cases if customer has 2 telephones data entery system enter it in 2 rows, like this:
id, name, address, telephone,branch,area
g13, jake, 7 st., 23456343, ,
k12,johne,ca st., 142635, ,
k12,johne,ca st.,150979, ,
in master sheet will be like this:
id, name, address, telephone-1,telephone-2,area,branch,verified_id
g13, jake, 7 st.,456343, , ,
k12,johne,ca st.,142635,150979, , ,k12
just will add the id at the end to verify that this data coppied from the same customer id.
hope i explained it fine, as a visually impaired unable to show screenshot.
many thanks