Excel data sheet to sheet

**--sonic--** · 03-30-2010, 09:16 AM

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

**Richard Buttrey** · 03-30-2010, 09:52 AM

Hi,

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

HTH

**--sonic--** · 03-30-2010, 10:15 AM

Originally Posted by Richard Buttrey

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.

**Richard Buttrey** · 03-30-2010, 10:23 AM

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

**--sonic--** · 03-30-2010, 10:38 AM

Originally Posted by Richard Buttrey

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. i´ll try it but i´m shure i can