Merging data in different excel workbooks - Microsoft Community
hello all,
running courier company. receive orders different customers different cities.
tough job enter first in customers files separately, different cities separately.
there way specific data can directed each individual customer , city file single master file in excel.
thank support.
running courier company. receive orders different customers different cities.
tough job enter first in customers files separately, different cities separately.
there way specific data can directed each individual customer , city file single master file in excel.
thank support.
if have data in single master file, don't need other files, , in fact lead more chances error.
use 1 sheet, data, , apply data filters on table. when want find specific customer use filter on customer column, , when want @ specific city use column's filter.
Office / Excel / Windows other / Office 2016
Comments
Post a Comment