- Transfer data from one excel worksheet to another automatically - How-To - Excel
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - How-To - Excel
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
Sub PrintBatch() Dim lMaxRows As Long lMaxRows = Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row For SLIP = 2 To lMaxRows Sheets("Sheet2").Select Cells(1, "J") = Sheets("Sheet1").Cells(SLIP, "A").Value DoEvents ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)" DoEvents Next SLIP End Sub