Thread: How to copy data automatically to particular sheet?
View Single Post
 
Old 03-10-2014, 05:44 AM
macropod's Avatar
macropod macropod is online now Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The comments in the Demo.xls file show how you can adapt the formulae to suit your needs. Since it's not that hard, I don't propose to do all the work for you. Besides, although it's possible, I really don't think it's practical to do this with a formula for more than a small amount of data - your workbook will become very slow at recalculating.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote