$$Excel-Macros$$ Purchase entry Macro

2010-11-19 Thread Raj Mahapatra
Hi Group, I am not able to run the below macro, kindly help. my requirement is like this. Sheet 4 is having data in one single row, which creates 3 or 4 multiple rows with the help of below macro. the below macro is only creates for the first line in sheet 4 only and it is not able to create for

$$Excel-Macros$$ Purchase entry Macro from Sheet 4 to Sheet 1-

2010-11-19 Thread Raj Mahapatra
Sub purchase_entry() Dim mod_date As Date Dim entry_date As Date Dim reference As String Dim description As String Dim period As String Dim amount As Long Dim locatio As String Dim coa As String Dim coa_code As String Dim tax_account As String Dim tax_account1 As String Dim tax_account_name As Var