Thread: Aquiring data from one sheet to another sheet in the same workbook
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Aquiring data from one sheet to another sheet in the same work
Apologies, there were numerous typos within the entire para:
Inserting rows or deleting rows within the assumed data area in the source
sheet: Y, ie within rows 2 - 2000 will upset things in X. If you cannot help
this happening in daily ops, just restore things in sheet: X to working order
by re-filling the top row formulas in Y's A2:C2 down to C2000 (In Y, select
A2:C2, copy down to C2000).

Para should have read as:
Inserting rows or deleting rows within the assumed data area in the source
sheet: X, ie within rows 2 - 2000 will upset things in Y. If you cannot help
this happening in daily ops, just restore things in sheet: Y to working order
by re-filling the top row formulas in Y's A2:C2 down to C2000 (In Y, select
A2:C2, copy down to C2000).

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote