PC Review


Reply
Thread Tools Rate Thread

Adding daily updates to other master sheets

 
 
sanju
Guest
Posts: n/a
 
      9th Mar 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help With Daily Sheets! sherry@tryingtoexcel.com Microsoft Excel New Users 5 29th Aug 2010 08:26 AM
Adding daily updates without re-doing everything =?Utf-8?B?QnVsbHNleWU=?= Microsoft Excel Misc 1 1st Mar 2007 01:32 PM
Adding new design template to a New slide master/title master =?Utf-8?B?S2F5ZQ==?= Microsoft Powerpoint 3 17th Mar 2006 02:45 PM
Daily transaction updates from remote to master file =?Utf-8?B?UGVya29u?= Microsoft Access 7 3rd Oct 2005 06:11 AM
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets hanuman Microsoft Excel Programming 0 9th Sep 2003 11:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:49 AM.