Thanks a lot Noorain..
On Wed, Feb 13, 2013 at 4:29 PM, NOORAIN ANSARI wrote:
> Dear Rahim,
>
> Please try it..see attachment.
>
> Sub Create_Batch()
> Dim sh As Worksheet
> Dim i As Long
> Dim j As Long
> Dim k As Long
> Set sh = ThisWorkbook.Sheets("Sheet1")
> j = sh.Cells(Rows.Count, "A").En
Hi,
I need a macro to divide the a range of data into batches of 125 each.
Further it should also insert the batch names at the beginning of each new
batch as per the attached sheet.
Please let me know if you need more details.
Thanks,
Rahim
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
