Results 1 to 6 of 6

Thread: Update a target workbook with values from a source workbook

Threaded View

  1. Jul 11th, 2009, 08:04 AM #1
    SpellBound
    SpellBound is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2009
    Posts
    19

    Update a target workbook with values from a source workbook

    Hi,

    I have attached 2 example workbooks (TargetBook and SourceBook) each contains a sheet (TargetSheet and SourceSheet). I need to lookup data in the SourceSheet, and where the Group matches, the Quantity is added to the relevent Group in the TargetSheet. I can do this with a VLookup, but have no idea where to start with VBA. Can anyone help me as it has to be done using VBA?

    If you look at the attached spreadsheet examples it will make more sense.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width