Data in different sheets

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
 
D

Don Guillett

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to delete row if cells greater than certain value 1
Macro to match 2 column values in different sheets 1
Merging 2 sheets. 1
Macro to look up values in 2 different columns 3
Copy cell values if cells match on two diff sheets 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
Matching data in two sheets 3
Excel Macro or Formula Question 1

Top