COLLECT DATA ON ONE SHEET

R

R.v.Deursen

There are two worksheets with lines of different data on
each sheet.(only the template for the two worksheets
arethe same.
Is there a way of collecting the information automaticaly
from the two worksheets into a third worksheet each time
there are made changes into the two worksheets or data is
added.
 
F

Frank Kabel

Hi
and how do you want to combine both sheets in one new file?
You may use simple formulas like
='[otherbook.xls]sheet1'!A1
for linking specific cells
 
Top