-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on
Behalf Of vivek agrawal
Sent: Monday, August 10, 2009 2:37 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Hi ShriNiwas
The macro which i have given already
.@googlegroups.com]*on Behalf Of *vivek agrawal
> *Sent:* Friday, August 07, 2009 5:39 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Split data to different Sheet ***
> URGENT***
>
> Hi
>
> Attached is the Text File
>
> Thanks and Regards,
Sent: Friday, August 07, 2009 5:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Hi
Attached is the Text File
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On
l
Sent: Friday, August 07, 2009 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Hi Shrinivas
Please Find Attached the required Module. Import this module in your workbook
using the VBE.
You just need to open that master she
ooglegroups.com] *On Behalf Of *vivek agrawal
> *Sent:* Friday, August 07, 2009 11:24 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Split data to different Sheet ***
> URGENT***
>
>
>
> Hi Shrinivas
>
>
>
> Please Find Attached the requi
ek agrawal
Sent: Friday, August 07, 2009 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Hi Shrinivas
Please Find Attached the required Module. Import this module in your
workbook using the VBE.
You just need to open th
Hi,
Try the below code it will work
---
Sub splitdata()
' Macro Cracked by SJ
Dim rnge As Range, subrnge As Range
Dim strdata(), shtname() As String
Dim i As Integer, r As Integer, s As Integer, ir As Integer
Dim currentshtname As Strin
Couple of prerequisites for this sent module
1. the master sheet to be opened when the sub procedure is run.
2. The first column should contain the names on the unique names of which
different files will be created (here in your case its "CLIENTS")
3. The first row should contain the all the headi
Hi Shrinivas
Please Find Attached the required Module. Import this module in your
workbook using the VBE.
You just need to open that master sheet and run the Sub Procudure "COPY
UNIQUE".
The module will do the rest of the task. it would create separate sheets
based on client and then save these
