Excel VBA

17 comments:

  1. kishore6 June 2017 at 08:52

    Hi please let me know the code for
    single excel sheet in to Multiple Excel Files.
    1. total column will be 7
    2. sheet to split in to multiple excel files based on unique name on particular column
    3.While splinting in to multiple files, each excel sheet need to have first 5 rows empty on top then the data need to be there
    4. Multiple excel files names must be with different coloumn name

    dpet code Employee Code Badge Number Manager place
    CAL 1 1146753 kishore Bangalore
    BZS 2 947662 kishore Gurgaon
    RTY 3 1097637 kishore Bangalore
    PIP 4 1101576 kishore Pune
    RTY 5 1197344 sunil Bangalore
    IJG 6 1313832 sunil Bangalore
    3TY 7 987023 sunil Bangalore
    NON 8 1315490 sunil Pune
    TAR 9 1314818 krishna Pune
    GFD 10 1314818 krishna Pune
    KJH 11 868727 krishna Pune

    ABOVE THE EXAMPLE SHEET

    REQUIRED LIKE BELOW
    FILE NAME MUST BE "SUNIL (BANGALORE)"

    Please provide code. thanks in advance

    ReplyDelete
  2. Nizar24 February 2018 at 14:00

    Hi,
    Thanks for the download google sheets VBA code...
    Great JOB!
    Nizar

    ReplyDelete
  3. Cynthia20 June 2018 at 11:38

    This comment has been removed by the author.

    ReplyDelete
  4. Madoox11 July 2018 at 07:19

    Brilliant, worked as charm. Please make more video, you are making life easier.

    ReplyDelete
  5. Panda12 November 2018 at 11:29

    Hi, how do you create multiple sheets base on the cells value while copy the data in the main sheet in each of the multiple sheets.

    ReplyDelete
  6. Unknown24 November 2018 at 18:48

    Thanks for your help.

    ReplyDelete
  7. Unknown4 December 2018 at 08:18

    Hi

    I need to do this, but with following:

    I need to perform at same time on multiple different tabs of same excel sheet
    I need to save as the filename_tab name_[insert some text here].txt
    I want to export each column independantly. Your code seems to merge all columns together so they appear as a single column when you opn the txt file in excel

    Thanks !

    ReplyDelete
  8. Unknown16 April 2019 at 06:19

    farid

    ReplyDelete
  9. Unknown2 May 2019 at 10:02

    Can sent a macro of arrange maltiple header in a sheet of base on top header

    ReplyDelete
  10. hamsi16 November 2019 at 06:43

    uf elearning

    ReplyDelete
  11. Unknown1 February 2020 at 02:18

    nice

    ReplyDelete
  12. Krishna Optif15 February 2020 at 02:55

    very nice and provide me informative content thanks for sharing for more information Looking for the best Create new worksheet

    ReplyDelete
  13. Unknown17 March 2020 at 19:36

    Hi Shakti..where can I find the commands from your video? converting excel into txt ..thanks

    ReplyDelete
  14. Unknown4 May 2020 at 05:58

    Great video and very instructive. Now if we could have one showing how can we move records from the .txt file back to excel selectively would be great help.

    Good work.
    Thank you and regards

    ReplyDelete
  15. nayar26 June 2021 at 04:46


    Wonderful post and more informative!keep sharing Like this!
    Full stack developer course in bangalore
    Full stack developer course in pune
    Full stack developer course in Gurgaon
    Full stack developer course in hyderabad
    Full stack developer course in delhi
    Full stack developer course in Trivandrum
    Full stack developer course in kochi
    Full stack developer course in mumbai
    Full stack developer course in ahmedabad

    ReplyDelete
  16. Charles17 September 2021 at 06:04

    Coding is not a necessary skill to create data visualization in Microsoft Excel and Google Sheets in this article, we will show you How to Create Pareto Chart with great graphic to make your visualization sophisticated.

    ReplyDelete
  17. oak1 January 2022 at 07:25

    thank

    ReplyDelete

Subscribe to: Posts (Atom)