+ Reply to Thread
Results 1 to 3 of 3

Auto Populate data - VB/Macro Need help

  1. 04-29-2013, 08:35 PM #1
    sdip
    sdip is offline
    Registered User
    Join Date
    04-29-2013
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Smile Auto Populate data - VB/Macro Need help

    Hi,

    I have 0 knowledge on VB script and need help on configure one VB/Macro for one of our complicate Excel sheet which is running on Excel 2010. The basic requirement is as follows.

    We have around 8-10 worksheets with different sets of financial data. We had built a summary worksheet for management view. As example in Summary Sheet we put like =Input!N4:N14

    Now management wants to have ability to update on the summary page which would automatically populate back to those other worksheet!!

    Any help or guidance will be really appreciate.

    Sandy
    Reply With QuoteRegister To Reply
  2. 04-29-2013, 08:49 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Auto Populate data - VB/Macro Need help

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 04-30-2013, 12:50 AM #3
    sdip
    sdip is offline
    Registered User
    Join Date
    04-29-2013
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Auto Populate data - VB/Macro Need help

    Thanks for your reply..

    Now I have wrote a very basic VBA script to populate data from Summary page to Input page. Is there anyway I can instruct them to only copy the changes??
    Current issue is its overwritten with 0 value!!

    Please Login or Register  to view this content.
    Last edited by davesexcel; 05-01-2013 at 07:54 PM. Reason: Code tags required when supplying VBA code, please read the forum rules.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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.6.0 RC 1