• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract data and save in workbook

S

Siba Sankar Badatya

New Member
Hello Team,

I have a master work book which contains all the employee data and every employee has a manager in "U" column, is there a macro available where the Planning Manager name can select and the data automatically save in one workbook in manager name wise irrespective of same manage name in multiple rows.

71421

Regards,
Sankar
 
Siba Sankar Badatya
Your like question: is there a macro available where ...
There are many macros, but Your written kind of macro is still missing.
... but, even that kind of macro is possible to do
... after You could give clear exact details ... what?
 
Hi Excel Ninja,

Thank you so much for looking this matter.

Basically i am looking a Macro which cut the Manager name ( ex. Abinav, Kailash, ) and his subordinates data and then data will save in workbook with the dedicate path. but we need to ensure that the formula also been captured in the individual manager workbook.

I have attached my requirements in the attachment file and image.

However i register the Chandoo. com by last week, very honestly speaking i am learning the skills from your website by last 5 years and i am keep on informing my friends and colleagues to learn from your Org.

Kindly do let me know for any more information, this is little urgent.

Regards,
Siba Sankar B
 

Attachments

  • Manager Cut.xlsx
    9.8 KB · Views: 3
  • Manager Cut Image.PNG
    Manager Cut Image.PNG
    12.3 KB · Views: 4
I asked three questions
... did You read eg the second line?
or
at least, explain ... what is missing?
 
Hello Ninja Sir,

Hope you are doing great and family are fine.

I am attaching a template which has a comprehensive formula and every field and cells is linked to other fields with formulla.

This template will cut the file and save the Manager wise in the folder.

But when i do that all the formula are gone and there is no use of the template....can you apply the VBA in the file where the formula should be retain.

Regards,
Siba Sankar B
 

Attachments

  • Split-data-into-separate-workbooks1.xlsx
    8.9 KB · Views: 7
Hi,

Thanks for asking questions.

Yes i have changed the template completely, Initially i have copied your VBA script in my new template, but some other reason its not working.

Can you please amend the same funda in the new template.

Its very helpful for me.

Regards,
Siba
 
Siba Sankar Badatya
I have no reason to modify my code - if You cannot write (third time) - what is missing?
Same way, You could use it with same layout.
It would be more surprise, if after Your change something could work!
 
Hey Ninja,

Sorry if i missed something, actually i am not the programmer where i can detect the error/missing's. I am an end user where i can go directly copy your code and paste the script in my excel via F11.

Please help to update your magic codes in my excel template ( Spit-data-into separate).

My apologies for delay in responding.

Regards,
Siba Sankar
 
Siba Sankar Badatya
You have missed already many times to give an answer ...
Do You know - what is an answer?
Do You know - what is a question?
Many times a question needs an answer.

If You cannot or won't give an answer - what is missing?
Then ... I cannot 'update' ... because I cannot know
- What is missing? ... because You asked something else.

Case - that You're not the programmer - I've noticed that...
... but if You cannot even ... as written many times about an answer.
Case - copy and paste - sometimes copy and paste would work ... but then that should do in correct ways.
... Do it help You - if I do something ... and You continue asking more more more - without learning anything?
Case - end user - then end user uses that as it has written.
 
Hi Ninja,

I think i am not able to answer your query as i dont know what is missing in the file.

My apologies for do not give any answer due to lack of my knowledge, i will stop the project which i am doing right now.

Thank you for your time sir.

Regards,
Siba
 
Siba Sankar Badatya
Hint: You should know, what do You really want (would like to get) before, You start to asking something.
This time - You tried to ask something - but seems that You didn't know what?
I guessed - what would you have asked - but after that You couldn't even write - do it work?
... just changed Your 'want'.
That would be okay - if You have hired someone,
other ways ... something else.
Good luck.
 
Hi Ninja,

There are lot of users can help and also the template is readily available in the google search.

I am still contacting you because you are only who helped me and show me the hope. but some how i am not able to sync to your expectation on the question, hence now planning to do the manual cut the files as my deadlines is very close almost in this week days.

Please don't mind sir, i know its my fault from my side, i could not answer your query.

Regards,
Siba Sankar B
 
Another possible solution...
Code: 
Sub test()
    Dim rg As Range, v As Variant, i As Long, wb As Workbook
    
    Application.ScreenUpdating = False
    With Sheet1.Cells(1, 1).CurrentRegion
        Set rg = .Columns(4).Offset(1).Resize(.Rows.Count - 1)
        With CreateObject("Scripting.Dictionary")
            For Each v In rg.Value
                .Item(v) = Empty
            Next v
            v = .keys
        End With
        For i = LBound(v) To UBound(v)
            Set wb = Workbooks.Add
            .AutoFilter 4, v(i)
            .SpecialCells(xlCellTypeVisible).Copy wb.Worksheets(1).Cells(1)
            .AutoFilter
            wb.SaveAs ThisWorkbook.Path & "\" & v(i) & ".xlsx"
            wb.Close
        Next i
    End With
    Application.ScreenUpdating = True
End Sub
 
Hi Ninja,

One more thing, i have an assignment which requires multiple rows and its a heavy data load in the excel workbook.
Can we do something which will ease and will not hang every time during the preparation of the excel workbook.
Any code you would suggest.

Regards,
Siba Sankar B
 
You must log in or register to reply here.
Back
Top