COLLECT DATA ON ONE SHEET

  • Thread starter Thread starter R.v.Deursen
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
Saving collected data? 1
Combining data from multiple worksheets into one 4
Need to merge worksheets - Excel 2003 0
Merge data from different worksheets 3
Linked cells between worksheets and sorting 2
How to insert new worksheet based on # of rows in a data sourch 2
Sorting data on one sheet, linked to another, but staying the same 1

Back
Top