+ Reply to Thread
Results 1 to 4 of 4

Creating Macro for Barcode printing

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    Calgary
    MS-Off Ver
    2010
    Posts
    5

    Creating Macro for Barcode printing

    This is my first time using this website. It will be great if any of you can help me out.

    So I am trying to create a Macro on Excel that can select a data on sheet1 to specific numbers on sheet2 that are changing. For instance,

    I have numbers and letters on sheet1 as shown below:

    SD
    SDHG-39
    SHJKJ
    JDKSLJKD
    hfjkhfjkda0333
    JKDLHJ

    DG
    hjkdalhj
    hjkdhalkf0333
    hjkdslahjfjfkla
    jfkdlas;

    So I want the data above to execute an instruction that would only change the numbers '0333' on sheet1 to sheet2 for both two sets of data above. The number like 0333 are constantly changing so that the numbers above would eventually be used to print out a barcode with different set of numbers. Please help if you have any idea.

    Thanks!!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: Creating Macro for Barcode printing

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

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

    View Pic

  3. #3
    Registered User
    Join Date
    11-18-2014
    Location
    Calgary
    MS-Off Ver
    2010
    Posts
    5

    Re: Creating Macro for Barcode printing

    Please refer to this thread:

    http://www.excelforum.com/excel-prog...or-fixing.html
    Attached Files Attached Files
    Last edited by murerapp; 11-23-2014 at 09:21 PM.

  4. #4
    Registered User
    Join Date
    11-18-2014
    Location
    Calgary
    MS-Off Ver
    2010
    Posts
    5

    Re: Creating Macro for Barcode printing

    Quote Originally Posted by davesexcel View Post
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

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

    View Pic
    In the next post...
    Last edited by murerapp; 11-23-2014 at 09:01 PM.

+ 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. macro for barcode scaner
    By ALEXR919 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2015, 10:47 PM
  2. Printing Barcode containing cells data
    By nsr1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2013, 02:18 PM
  3. Replies: 1
    Last Post: 12-18-2011, 12:32 PM
  4. Creating a macro-enabled button with conditional printing
    By gavin0311 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-28-2010, 10:03 PM
  5. [SOLVED] creating a macro for printing
    By g48dd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2009, 03:25 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