Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge 3 Xls worksheets updates into master xls Tim_Ver Charts and Charting in Excel 0 April 21st 09 04:37 PM
Link to other Worksheets - when data is added updates master works Pat[_3_] Excel Worksheet Functions 4 September 24th 07 05:56 PM
Adding daily updates without re-doing everything Bullseye Excel Discussion (Misc queries) 1 March 1st 07 01:32 PM
date that updates itself daily, plus another formula please?? Ted Excel Worksheet Functions 2 November 26th 05 03:36 PM
Daily updates of pivot tables jack ireland Excel Programming 0 September 29th 05 10:56 AM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"