ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding daily updates to other master sheets (https://www.excelbanter.com/excel-programming/440408-adding-daily-updates-other-master-sheets.html)

sanju[_2_]

Adding daily updates to other master sheets
 
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


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com