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")
--
Don Guillett
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>