Thread: Copy data from 1 work sheet to another automatically
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Copy data from 1 work sheet to another automatically
In Sheet1,

You could place in A1:
=IF(Sheet2!A1="","",Sheet2!A1)
then copy across and fill down to cover the extent required
The formulated range will return the contents of Sheet2 to the extent covered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shazza" wrote:
I work with Excel 2000 and was wondering if there is a way of copying data
from one sheet to another so that any changed made will reflect onto the new
worksheets.
--
Thank you for reading my post. Hopefully you can answer my querie
Reply With QuoteReply With Quote