+ Reply to Thread
Results 1 to 2 of 2

Copy to other Sheet Problem

  1. #1
    Registered User
    Join Date
    10-26-2011
    Location
    daska, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    46

    Copy to other Sheet Problem

    We have two Sheets one is "INVOICE" and other is "SALES". After pressing "print invoice" button , it will print and also copy to "SALES" sheet automatically . Following Code is working fine.

    INVOICE :As Follow,

    Date : 15/09/12 Invoice #: 717
    Name : Malik Tariq - Gujranwala

    Qty. Description Rate Rs.
    288 Pack 1-1/2 x 8 81 23328
    512 Pack 1-1/4 x 8 70 35840

    Date=B6 invoice # = D6 Name=B7
    Qty.= A10:A26 Description=B10:B26 (Description means "Sizes"we have more than 40 different Sizes)


    SALES As Follow,
    Line # 6
    Invoice#=A Column , Date=B Column, Customer name=C Column, Size1=D Column, Size2=E Column , Size 3=F Column , till BB Column

    Now its copying quantity after column C continiousely But we want copy invoice sheet "description " (B10:B26) to Sales sheet under relative size
    Please help me its urgent

  2. #2
    Registered User
    Join Date
    10-26-2011
    Location
    daska, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Copy to other Sheet Problem

    you can see both sheets with code from following link http://sdrv.ms/1dAnEwv

+ 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. Problem when copy pasting a picture from sheet to sheet
    By leugu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2011, 04:07 AM
  2. Sheet copy problem
    By Carlsbergen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-21-2010, 08:33 AM
  3. Peculiar Problem when Doing a Sheet.Copy
    By Chaplain Doug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2006, 10:20 AM
  4. Copy Sheet problem
    By Casey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2006, 05:15 PM
  5. Copy sheet macro problem
    By rpgun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2005, 09:13 AM

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