C
conditional merge data into a newmaster
I have three workbook with simple calculations and 100 rows each, they look
like this :
column a => 1
columb b => description
column c => value
column d => value
I would like to create a new master workbook that look over the woorkbooks
that are already created and if there is any number on column "a" on any
worksheet will copy all the original row in the row 1 in the master workbook,
if it founds a second one will copy all the row in the row 2 and so on. Can
this be acomplished?
like this :
column a => 1
columb b => description
column c => value
column d => value
I would like to create a new master workbook that look over the woorkbooks
that are already created and if there is any number on column "a" on any
worksheet will copy all the original row in the row 1 in the master workbook,
if it founds a second one will copy all the row in the row 2 and so on. Can
this be acomplished?