scholsey100
New Member
- Joined
- Oct 19, 2009
- Messages
- 1
Hi all,
Hoping someone will be able to help.
At present i have 10 sheets within 4 workbooks that then collate the values (countif) in to one sheet. The information that is put in these sheets is entered daily and i need to keep a copy of this data in a seperate tab, which i noramally have to copy and paste from like 40 sheets. I am want to automat the whole process so the sheets can be updated daily, it will colate the results for all the fields (some are sum and some are averages) and then copy the enterned data in to a running sheet and then deleted it from the individual sheets ready for use the next day (maybe set it to run at 12pm so there is not human input required... any help would be much appriciated.
Hoping someone will be able to help.
At present i have 10 sheets within 4 workbooks that then collate the values (countif) in to one sheet. The information that is put in these sheets is entered daily and i need to keep a copy of this data in a seperate tab, which i noramally have to copy and paste from like 40 sheets. I am want to automat the whole process so the sheets can be updated daily, it will colate the results for all the fields (some are sum and some are averages) and then copy the enterned data in to a running sheet and then deleted it from the individual sheets ready for use the next day (maybe set it to run at 12pm so there is not human input required... any help would be much appriciated.