+ Reply to Thread
Results 1 to 2 of 2

tranfer data beatween three worksheets

  1. #1
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    tranfer data beatween three worksheets

    Hello guys,
    After sometime I came here again and I have a new problem.

    I need to make some paper labels according to packages contents, every day I filled ma table with data about packages (work sheet has a name “master file”), can Excel transfer data from master file to worksheet which has a name “Label form” into specific cell according to character of data as I described in sample02.

    Also in worksheet master file I have one problem where I want according to numbers in columns D and E make result in column C but all this should be done from code table worksheet (third worksheet).

    I hope that I did not be so confused with explanation.

    Thank you for your help in the past also.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: tranfer data beatween three worksheets

    Hello all,

    Maybe I was confused in my previous post what do I want to do and I will try again.
    This task could be divided into two parts, first where I want to transfer data from worksheet named code tables to master file worksheet, for example when I put manually producer cede and length customer code will be stored automatically in table, for this will be used table01 in worksheet code tables, table 02 I use to take the number of order when i put the date of order in master file table.

    Second task is to transfer specific data from the master file table to label form worksheet before I printed them, for every new row in master file I need to make label form, older entries will be overwritten by new, and after printing I will save label form for every row.
    I attached sample in this post where I try to picture all what I want.
    Thanks for answers in advance,cheers.
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1