Adding daily updates to other master sheets

S

sanju

Hi

Please can nayone help me in following

There are an activity sheet which will contain update related to
orders in coulmn D. I need to tranfer the updates column H and Column
J of this worksheet to different worksheet as per match found in
column D.
Column J entries need to be replaced in other sheets which I am able
to do as per macro_run.

For B = 2 To 50
For A = 3 To 50

If Worksheets("Activity").Cells(B, 4).Value =
Worksheets("IP_MPLS").Cells(A, 1).Value Then
Worksheets("IP_MPLS").Cells(A, 32).Value =
Worksheets("Activity").Cells(B, 10).Value

But Column H entries, I need this to be added up in the existing
column AF of other worksheets Voice, BB, IPLC VCIPLC, IP_MPLS and
BB . This addition I want as date ; update format.

Please can anyone help me in this
 

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 is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activit 1
Excel 2013 Merge Data 2
InputBox for column letter problem 2
Search other sheets for numbers & color them 10
Modify working code to expand the output. 5
Macro to Format Multiple Sheets based on "Master" Format 0
Automatic updates to other sheets from master sheet 1
Help in sorting data 2

Top