+ Reply to Thread
Results 1 to 4 of 4
  1. 12-19-2008, 01:48 AM #1
    Shan68
    Shan68 is offline
    Registered User
    Join Date
    10-10-2008
    Location
    India,Bangalore
    Posts
    10

    Copy value from another sheet

    Hi

    I have attached my rev excel sheet. In this sheet I need Auto fill the revenue value(in overall sheet) based on revenue data sheet

    regards,

    shan
    Attached Files Attached Files
    Last edited by Shan68; 12-19-2008 at 02:37 AM.
    Reply With Quote Reply With Quote
  2. 12-19-2008, 03:17 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Guru JBeaucaire's Avatar
    Join Date
    03-21-2008
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    18,225
    Send a message via Skype™ to JBeaucaire
    You needed some "helper" cells added on the RevData sheet (columns J & K) to make the data cross reference by your ranges.

    Take a look, is this what you needed?
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)
    Reply With Quote Reply With Quote
  3. 12-26-2008, 12:30 AM #3
    Shan68
    Shan68 is offline
    Registered User
    Join Date
    10-10-2008
    Location
    India,Bangalore
    Posts
    10
    isted of adding row J & K . can we right some macro for this
    Reply With Quote Reply With Quote
  4. 12-26-2008, 01:00 AM #4
    Shan68
    Shan68 is offline
    Registered User
    Join Date
    10-10-2008
    Location
    India,Bangalore
    Posts
    10
    Thank for reply.

    Can we right macros for this
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0