+ Reply to Thread
Results 1 to 5 of 5

Excel data sheet to sheet

  1. #1
    Registered User
    Join Date
    03-30-2010
    Location
    DK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel data sheet to sheet

    Hi,

    Can anyone tell me how to import data from 1 sheet to another sheet.

    Exsample.
    sheet 1

    -ordre number- -prize- -total- -how many to ordre-

    sheet 2

    if any ordre is made then transfer the line to this sheet (if 10 ordres is made then 10 lines)

    then i can print this page on a button.

    Hope you can help.

    Regards Henrik

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,704

    Re: Excel data sheet to sheet

    Hi,

    Have you tried using Data Filter on the sheet1 data and then copying the filtered rows to sheet2?

    HTH
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-30-2010
    Location
    DK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel data sheet to sheet

    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    Have you tried using Data Filter on the sheet1 data and then copying the filtered rows to sheet2?

    HTH
    no, but i would like the data automatic transfer to sheet 2 if there i any ordre.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,704

    Re: Excel data sheet to sheet

    Hi,

    In that case you'll need a macro.

    Try the Data Filter manually to ensure that you know the keystrokes involved in creating the filter, then switch on the macro recorder and repeat the exercise.

    When you've done that, and if you have any problems, upload the workbook with your captured macro and no doubt someone will be able to help further.

    Regards

  5. #5
    Registered User
    Join Date
    03-30-2010
    Location
    DK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel data sheet to sheet

    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    In that case you'll need a macro.

    Try the Data Filter manually to ensure that you know the keystrokes involved in creating the filter, then switch on the macro recorder and repeat the exercise.

    When you've done that, and if you have any problems, upload the workbook with your captured macro and no doubt someone will be able to help further.

    Regards
    Ok, thanks. ill try it but im shure i can

+ 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