Macro Copy From Invoice To Table Database

Hi,

Please for Help need macros :

Copy From Sheets ("PO")
Copy D7 & H7
Copy C11 : H25 (Only Active Cells)

Paste To Sheets ("Sheet1")
D7 & H7 = Column A & B
C11 : H25 = Column C, D, E, G, H


Thanks - John

database.xlsm

Hi,

Please for help,

Sheets (PO)
D7 = 1111, H7 = 23/02/2014
C11 = Single Vision 1,56, D11= = 4.00, E11 = 0.00, G11 = 1, H11 = 123
C12 = Single Vision 1,61, D12= = -2.00, E12 = -0.50, G12 = 2, H12 = 1234
C13 = Single Vision 1,61, D13= = -2.00, E13 = 0.00, G13 = 4, H12 = 4321


I want copy to Sheets (Sheet1) like this :
A2 = 1111, B2 = 23/02/2014, C2 = Single Vision 1,56, D2= = 4.00, E2 = 0.00, G2= 1, H2 = 123
A3 = 1111, B3 = 23/02/2014, C3 = Single Vision 1,61, D3= = -2.00, E3 = -0.50, G3= 2, H3 = 1234
A4 = 1111, B4 = 23/02/2014, C4 = Single Vision 1,61, D4= = -2.00, E4 = 0.00, G4= 4, H4 = 4321

It's like create Invoice to Database. have suggest for example code ..


Thanks

Revised Attach remove Merge ..

I search about copy topic and find great work http://www.excelforum.com/excel-prog...-database.html but it's create New Worksheet ...

My question i need paste to same sheets (Sheet1) update database receive from Sheets (PO) after click button New & Save.

Thanks