Copying to another sheet

[Halid]

Hello dear Sir,

Please see attached copy spreadsheet which contains - sheet1 and sheet2.

Sheet1 - all information.
Sheet2 - destination.

There are some invoice details (sheet1) which should be copy to Sheet2 as appropriate ranges.

There are 3 steps:

STEP 1

1. Invoice number - (sheet1, from column C) should be copy to sheet2 (column J).
2. Date - (sheet1, from column D) should be copy to sheet2 (column H).
3. Amount - (sheet1, from column K) should be copy to sheet2 (column E)
4. Currency - (sheet1, from column J) should be copy to sheet2 (column C)
5. Acc. - (sheet1, from column A) should be copy to sheet 2 (column D)
6. put "SH" word to column A in sheet2 and column I from sheet2 should be +30days from rage H in sheet2.

STEP 2

1. put "SV" word to the second row after "SH" in column A (sheet2)
2. Currency(sheet2) should be copy to column C from sheet2 (previous row)
3. Amount(sheet2) should be copy from column E to column D sheet2 (previous row)

STEP 3

1. put "SN" word to the next row after "SV" in column A sheet2
2. Same as currency
3. Go to sheet1 and take nominal code from column B and copy to column D in sheet2.
4. Go to sheet1 and take ACC. from column A and copy to column A (only letters) and copy to column F (only digits) - for example: AAB(column E) 005(column F)
5. Go to sheet1 and take amount(appropriate row) from column K and copy to column G in sheet2.
6. Go to sheet1 and take Description(appropriate row) from column G and copy to column G in sheet2
7. Go to sheet1 and take Name(appropriate row) from column H and copy to column I in sheet2
8. Go to sheet1 and take Placement(appropriate row) from column I and copy to column J in sheet2.
9. Go to sheet1 and take Nominal code from column B and copy to column K in sheet2

You will see example copy of information from sheet1 to sheet2 in attached file.

Many Thanks in Advance

Regards

Halid