+ Reply to Thread
Results 1 to 3 of 3

Auto update (addition) based on base data

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    44

    Post Auto update (addition) based on base data

    Hi Experts,

    I have set of data where sheet 2 have a Rate Card table for various services and geographies...sample have 10 service lines for four geos.

    Sheet 1 have a table for each geography catering all the services. From some other database I get number of heads serving that particular area. And sheet 1 produce revenue data for each geo for each service for each month.

    Now problem is, apart from defined services, if I want to add new service line, I have to add that particular service line to each geo.

    I was wondering if by any means, the addition of service line to rate table will add service line row for each geo automatically ie if I add new service line "11" to rate card table, the service line "11" row should be added to all geos automatically...

    Kindly help..
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Auto update (addition) based on base data

    Try this:

    Click the button on the "MpCost-Revenue" TAB

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    44

    Cool Re: Auto update (addition) based on base data

    Hi Xx7....thank you very much for your support..yes it worked as I wanted to....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. update production sheet from data base.
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2010, 12:05 PM
  2. Addition in base 6
    By Barking_Mad in forum Excel General
    Replies: 2
    Last Post: 06-14-2009, 04:49 AM
  3. Replies: 1
    Last Post: 03-15-2009, 05:38 AM
  4. Update E-Mail Data Base
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2006, 02:17 PM
  5. Addition base on condition
    By 68magnolia71 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1