+ Reply to Thread
Results 1 to 7 of 7

Use macro or other function

  1. 05-05-2017, 04:02 AM #1
    fahadmohsin
    fahadmohsin is offline
    Registered User
    Join Date
    11-18-2016
    Location
    Islamabad, Pakistan
    MS-Off Ver
    2010
    Posts
    42

    Use macro or other function

    Hi,

    I have attached an excel file. I want to separate the data according to account code. I have over 200 ledgers and I want each account code in a separate sheet (Not workbook). E.g. 100-001-002 should be in sheet 1, 100-001-003 in sheet etc...

    Can any one help me here
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-05-2017, 05:11 AM #2
    PFDave
    PFDave is offline
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Use macro or other function

    This will work providing you do not have duplicate group names in column A. Let me know your thoughts please
    Attached Files Attached Files
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.
    Reply With QuoteRegister To Reply
  3. 05-05-2017, 05:18 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Use macro or other function

    Hi fahadmohsin

    Here you go:
    Please Login or Register  to view this content.
    EDITED: Code amended to make provision for closing balance row
    Attached Files Attached Files
    Last edited by sintek; 05-05-2017 at 05:35 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 05-05-2017, 05:32 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Use macro or other function

    @ PFDave

    Nice, once again i see you made provision for something I did not....ending balance
    Reply With QuoteRegister To Reply
  5. 05-05-2017, 05:49 AM #5
    PFDave
    PFDave is offline
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Use macro or other function

    Quote Originally Posted by sintek View Post
    @ PFDave

    Nice, once again i see you made provision for something I did not....ending balance
    We seem to be double teaming a number of threads recently!

    Great to see the different workings and I'm picking up lots.
    Reply With QuoteRegister To Reply
  6. 05-05-2017, 05:57 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Use macro or other function

    Great to see the different workings and I'm picking up lots.
    Yep, that is true
    Reply With QuoteRegister To Reply
  7. 05-07-2017, 02:29 PM #7
    fahadmohsin
    fahadmohsin is offline
    Registered User
    Join Date
    11-18-2016
    Location
    Islamabad, Pakistan
    MS-Off Ver
    2010
    Posts
    42

    Re: Use macro or other function

    Thanks it truly did help me alot....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Not working Macro --Distance Function/Macro made a couple of years ago
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-20-2016, 10:33 AM
  2. Macro function has been passed to me. not sure its exact function
    By SeanBaird in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2015, 03:04 PM
  3. Using the Find Function inside the Right function in macro
    By namruht in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2013, 02:12 PM
  4. Macro exits prematurely from function after calling other function
    By LouisPhilippe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 03:22 AM
  5. [SOLVED] Help : Macro Function - unable to apply filter function after macro the file.
    By Shermaine2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2013, 12:50 AM
  6. Macro function Get Comment Text function with format
    By guynextdoor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2010, 01:08 AM
  7. Macro Function:create a new function
    By Tomas in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-09-2006, 07:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1