Adding the contents of cells from other workbooks

[William Wootton]

Dear All
I am trying to develop a tour sheet which has values in given cells. I have
created a master tour sheet in another workbook so that when you input
numbers on the original worksheet they transfer overto the master workbook.
I want to be able to transfer data to the master workbook from multiple,
separate worksheets/books (other people will have copies of the worksheet
and fil it in.)
This is where i am struggling is how can i get the data to add when other
sheets are filed in as at the moment it just replaces the original data in
the master copy instead of adding to it.

Hope i have explained properly.

Bill

 

[CLR]

Hi Bill..........

I believe what you need is a sophisticated piece of VBA code that will go
out and open each of your satellite workbooks in sequence, analyze a
SpecialCodeCell therein to determine if that book has been changed since the
last interrogation, and if not, ignore the data therein, close the book and
go on to the next one.........if the data HAS been changed, then it would
import the new data to the Master book and add it to your existing values,
then close that book and go on to the next satellite book on your
list.............I can envision how it might work, but unfortunately it is
well beyond my VBA capabilities to do it for you.........but at least I
offer the support that I percieve it's do-able and hopefully someone else
can offer additonal information. Projects like this sometimes go unanswered
here, so that is why I passed along these thoughts............. Good luck.

Vaya con Dios,
Chuck, CABGx3