+ Reply to Thread
Results 1 to 2 of 2

Cell info transfering to another workbook in sequencial order

  1. #1
    Registered User
    Join Date
    Sacramento, CA
    MS-Off Ver
    Excel 2007

    Cell info transfering to another workbook in sequencial order


    I am new at this Macro programing and need a little assistant.

    This is what I'm trying to achieve from this batch print out.

    A1 B1 C1 D1
    Batch # Material 1 (kg) Material 2 (kg) Material 3 (L)
    43 (150) (250) (5.0)

    This is a batch print out and every single time the batch number changes, the material number changes, and it only prints out current batch line and delete the old batch line as soon as it gets new info. (i.e. for batch #44, the values from B1 to D1 will change while erasing the old data)

    So, what I am trying to do is to write a Macro where for every batch increment It copies the materials info to a different work sheet and it continues to copy the new information one line after another as the batch number increases.

    This is what I got so far and it isn't working and need help

    Please Login or Register  to view this content.

    This macro isn't working and at the same time I want to run this macro continuously rather than running it only once.
    Last edited by pkazi; 02-26-2009 at 02:28 AM. Reason: As suggested by the moderator

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)

    Re: Need help with simple Macro

    Welcome to the forum.

    Please read the forum rules below and then edit you're post to include code tags and amend you're title

    VBA Noob

    Credo Elvem ipsum etian vivere
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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