Hi Satender,
Share your data with example.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles.
Dear sir,
my query is i have a master workbook with all clients row data. now i want
clinets row data in a seprate workbook client name then save in folder.
please solve this query.
thank you so much for your quick reply!
On Tue, Sep 9, 2014 at 10:05 PM, NOORAIN ANSARI
wrote:
> Dear Saten
Dear Satendra,
Please try it...hope it will help to you...
http://www.excelvbaclinic.com/2013/12/combine-all-workbook-of-folder.html
Thanks,
Noorain Ansari
On Tue, Sep 9, 2014 at 5:07 PM, Satendra kumar
wrote:
> Hi All Expert,
>
> please solve my query, i want Data Compiler from one workbook
Hi All Expert,
please solve my query, i want Data Compiler from one workbook to another
workbook.
*Noorain sir please look below code highlight range. how to fix this range.*
Sub Compiler()
Dim rng, rng1 As Range
Dim i, j, k As Integer
Set rng = Sheet1.Range("h1:h" & Sheet1.Range("h65536").End