Data in different sheets

  • Thread starter Thread starter ankud1
  • Start date Start date
A

ankud1

hello everyone

i am trying to write a macro but as m not much familiar how to mave
data between two or more sheet so would like sum suggestions and sub
procedures if possible

my querry is

i have data in two work sheets sheet1 & sheet2
in column ABC in both the sheets

i would like to "subtract" [sheet2] colC from
[sheet1] 'colC'

and and would like to move these subtracted values to sheet3 colC &
also like to move colA colB data of [sheet1]

to colA & colB of [sheet3]
like wwise for other columns DEF, GHI , JKL

i hope sumbody would help me out as its quite simple problem , plz let
me knw if i havnt frmaed my problem properly

Many Thanks in advance
 
try something like:
for i = 2 to sheets("sheet1").cells(rows.count,"c").end(xlup).row
sheets("sheet3").cells(i,"c").value= _
sheets("sheet1").cells(i,"c") - _
sheets("sheet2").cells(i,"c")
next i
sheets("sheet1").range("a1:b1").entirecolumn.copy _
sheets("sheet3").range("a1")
 
Back
Top