View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
No News No News is offline
external usenet poster
 
Posts: 14
Default Aquiring data from one sheet to another sheet in the same work

Dear Max.

Thanks for all your help and sincere reply.

Great. All that works fine.

But for me, not that much experienced in excel, it takes two days to
understand and make a trial. Now it is perfect. Welldone.

Thanks a lot for your help.

TT


"Max" wrote in message
...
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
---