View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nitn28@gmail.com is offline
external usenet poster
 
Posts: 32
Default Moving data Between Two sheets

hello everyone

i m novice to Vba n trying to solve a problem , i never moved data
between two sheets so stucked here

my querry is i have some data in sheet1 and some "formula set" in
Sheet2

wat i want to do is to move column1 and column 3 of "sheet1" to
column 1 & column2 "sheet2' then apply the formula i have in sheet2
gets results in column3 [sheet2]
and send these values bach to "sheet1" in column6


and then move again to column 5 & column 7 of sheet1 and repeat the
above procedure till all the coumns get results

sorry if i havnt framed my question properly but please let me knw i
wil put it other way round

hope i wil get direction from experts here

many thanks
plz reply