Macro Code to copy range of data in excel

February 3, 2011 at 19:38:29
Specs: Windows Vista
Sirs,

I have a workbook in excel with 3 sheets.

Sheet 1 ("COLUMNAR")

ID DATE PAGE NO OR NO NAME OF PAYEE AMOUNT SECTION PARTICULARS

1 1/5/11 PAGE 1 0000701 JOEY BANTOG 26.00 DRY GOODS


Sheet 2 ("SAMPLE")
Page 1

Serial No. Amount
(From - To) PayEE Acct. Code Description
A B C D E

I need to automatically transfer Serial No, Payee and amount to Sheet Named "Sample" which is the report form leaving Acct Code blank however using the Page No as the ref cell

Sirs please help me my job is at stake with this report. Thanks


See More: Macro Code to copy range of data in excel

Report •


#1
February 5, 2011 at 16:36:04
Please repost your data after reading the How To referenced in the following line:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question