: Re: $$Excel-Macros$$ Splitting of files
Try this Code :
Sub MakeSeperat()
Dim rngCell As Range
Dim rngHeading As Range
Dim rngData As Range
Dim strClientName As String
Dim wksSheetAs Worksheet
Dim wbWorkbook As Workbook
strClient
]
Subject: Re: $$Excel-Macros$$ Splitting of files
Hi Shrinivas
Try :
Sub Mtest()
Dim Rng As Range
Dim ws As Worksheet
Dim shname As String
Dim i As Integer
Dim shn As Long
Dim mx As Variant
Dim x As Integer
Dim LR As Long
Dim sPath As String, sFileName As String
On Error Resume Next
Hi Shrinivas
Try :
Sub Mtest()
Dim Rng As Range
Dim ws As Worksheet
Dim shname As String
Dim i As Integer
Dim shn As Long
Dim mx As Variant
Dim x As Integer
Dim LR As Long
Dim sPath As String, sFileName As String
On Error Resume Next
Application.DisplayAlerts = False
Sheets("Temp").Delete
Applica
This is easy enough to do with a macro. However, please consider leaving all
in one file and simply use
data>filter>autofilter.
-Original Message-
From: Chidurala, Shrinivas
Sent: Saturday, October 01, 2011 6:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Spl
